Re: Inconsistent RestrictInfo serial numbers
Ashutosh Bapat <ashutosh.bapat.oss@gmail.com>
From: Ashutosh Bapat <ashutosh.bapat.oss@gmail.com>
To: Richard Guo <guofenglinux@gmail.com>
Cc: PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2024-11-06T14:06:36Z
Lists: pgsql-hackers
On Wed, Nov 6, 2024 at 4:10 PM Richard Guo <guofenglinux@gmail.com> wrote: > > On Tue, Oct 8, 2024 at 8:20 PM Richard Guo <guofenglinux@gmail.com> wrote: > > > > I ran into an "ERROR: variable not found in subplan target lists" > > error, which can be reproduced with the following query. > > > To fix, I think we can reset the root->last_rinfo_serial counter after > > generating the additional constant-FALSE RestrictInfo. Please see > > attached. > > I intend to push this patch shortly, barring any objections, so that > it can catch up with the next minor release (Nov. 14). I didn't get time to respond to your email and create a patch based on my proposal. Sorry. I may not get time for another week or so. Please feel free to push the patch, if you feel that it's in a committable state. -- Best Wishes, Ashutosh Bapat
Commits
-
Fix inconsistent RestrictInfo serial numbers
- 78b1c553bb1c 17.1 landed
- f00ab1fd156e 18.0 landed
-
Recalculate where-needed data accurately after a join removal.
- a3179ab692be 18.0 cited
-
Add better handling of redundant IS [NOT] NULL quals
- b262ad440ede 17.0 cited