Re: subquery pullup misses lateral refs in join alias Vars - Mailing list pgsql-hackers

From Tatsuya Kawata
Subject Re: subquery pullup misses lateral refs in join alias Vars
Date
Msg-id CAHza6qcLzJqDtn6mBd-j4b8DzODUXQ4uNxw+GOVR73fx-+pdRQ@mail.gmail.com
Whole thread
In response to Re: subquery pullup misses lateral refs in join alias Vars  (Richard Guo <guofenglinux@gmail.com>)
List pgsql-hackers
Hi!

> Thanks for looking at this.  This query seems to be the same as the
> first query in my initial report (with a different targetlist) and has
> already been covered in the test cases of v1 patch.

Sorry for the confusion. Yes, it's the same query as yours. I just
wanted to note that without asserts it silently returns wrong results
(1 row instead of 4) rather than raising an error, in case that's
useful for the back-patch decision.

Regards,
Tatsuya Kawata

pgsql-hackers by date:

Previous
From: Narayanan Venkateswaran
Date:
Subject: Re: Proposal: Conflict log history table for Logical Replication
Next
From: Zsolt Parragi
Date:
Subject: Re: pg_dump: ALTER INDEX SET STATISTICS missing for index-backed constraints