| From: | Alexander Lakhin <exclusion(at)gmail(dot)com> |
|---|---|
| To: | Alexander Korotkov <aekorotkov(at)gmail(dot)com> |
| Cc: | Andrei Lepikhov <a(dot)lepikhov(at)postgrespro(dot)ru>, "Gregory Stark (as CFM)" <stark(dot)cfm(at)gmail(dot)com>, Michał Kłeczek <michal(at)kleczek(dot)org>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>, Richard Guo <guofenglinux(at)gmail(dot)com> |
| Subject: | Re: Removing unneeded self joins |
| Date: | 2023-12-29 05:00:00 |
| Message-ID: | a89f480f-8143-0965-f22d-0a892777f501@gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | Postg토토 커뮤니티SQL |
Hi Alexander,
23.10.2023 14:29, Alexander Korotkov wrote:
> Fixed all of the above. Thank you for catching this!
I've discovered that starting from d3d55ce57 the following query:
CREATE TABLE t(a int PRIMARY KEY);
WITH tt AS (SELECT * FROM t)
UPDATE t SET a = tt.a + 1 FROM tt
WHERE tt.a = t.a RETURNING t.a;
triggers an error "variable not found in subplan target lists".
(Commits 8a8ed916f and b5fb6736e don't fix this, unfortunately.)
Best regards,
Alexander
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Maciek Sakrejda | 2023-12-29 05:02:04 | Re: Pdadmin open on Macbook issue |
| Previous Message | Amit Kapila | 2023-12-29 04:55:20 | Re: Synchronizing slots from primary to standby |