Quick Links

Re: Removing unneeded self joins

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:	2024-02-18 13:00:00
Message-ID:	56ee4520-e9d1-d519-54fe-c8bff880ce9b@gmail.com
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-hackers

Hi Alexander,

09.01.2024 01:09, Alexander Korotkov wrote:
> Fixed in 30b4955a46.

Please look at the following query which fails with an error since
d3d55ce57:

create table t (i int primary key);

select t3.i from t t1
join t t2 on t1.i = t2.i,
lateral (select t1.i limit 1) t3;

ERROR: non-LATERAL parameter required by subquery

Best regards,
Alexander

	From	Date	Subject
Next Message	Konstantin Knizhnik	2024-02-18 13:33:30	Re: PGC_SIGHUP shared_buffers?
Previous Message	Robert Haas	2024-02-18 11:53:43	Re: PGC_SIGHUP shared_buffers?