On Sun, Feb 18, 2024 at 5:04 PM Alexander Korotkov <aekorot...@gmail.com> wrote: > On Sun, Feb 18, 2024 at 3:00 PM Alexander Lakhin <exclus...@gmail.com> wrote: > > 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 > > Thank you for spotting. I'm looking at this.
Attached is a draft patch fixing this query. Could you, please, recheck? ------ Regards, Alexander Korotkov
0001-Replace-relids-in-lateral-subquery-target-list-du-v1.patch
Description: Binary data