Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #18261: Inconsistent results of SELECT affected by joined subqueries - Mailing list pgsql-bugs

From Richard Guo
Subject Re: BUG #18261: Inconsistent results of SELECT affected by joined subqueries
Date
Msg-id CAMbWs49dx+gpBG8H4S-J03F1-WVLqVc7_zFGwwJO3_jBY4+KDA@mail.gmail.com
Whole thread Raw
In response to Re: BUG #18261: Inconsistent results of SELECT affected by joined subqueries  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: BUG #18261: Inconsistent results of SELECT affected by joined subqueries  (Alexander Korotkov <aekorotkov@gmail.com>)
Re: BUG #18261: Inconsistent results of SELECT affected by joined subqueries  (Andrei Lepikhov <a.lepikhov@postgrespro.ru>)
List pgsql-bugs
Tree view

On Fri, Dec 29, 2023 at 12:32 AM Tom Lane <tgl@sss.pgh.pa.us> wrote:
Richard Guo <guofenglinux@gmail.com> writes:
> I've looked into it a bit.  The problem lies in how the SJE code handles
> the transfer of qual clauses from the removed relation to the remaining
> one.

I am definitely starting to think that the SJE patch was not ready
for prime time.  We keep finding not only minor but major problems
in it --- I'd call this one a "major" one.  Is it time to revert
and rethink it from scratch?

I feel the same way.  It seems to me that the SJE code still needs some
refactoring to get to a committable state.

Thanks
Richard

pgsql-bugs by date:

Previous
From: Magnus Hagander
Date:
Subject: Re: Segmentation fault caused by Postgrest - reateplan.c:6178 - prepare_sort_from_pathkeys
Next
From: John Naylor
Date:
Subject: Re: Segmentation fault caused by Postgrest - reateplan.c:6178 - prepare_sort_from_pathkeys