| From: | Richard Guo <guofenglinux(at)gmail(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | zuming(dot)jiang(at)inf(dot)ethz(dot)ch, Alexander Korotkov <aekorotkov(at)gmail(dot)com>, pgsql-bugs(at)lists(dot)postgresql(dot)org |
| Subject: | Re: BUG #18261: Inconsistent results of SELECT affected by joined subqueries |
| Date: | 2024-01-02 01:43:21 |
| Message-ID: | CAMbWs49dx+gpBG8H4S-J03F1-WVLqVc7_zFGwwJO3_jBY4+KDA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
On Fri, Dec 29, 2023 at 12:32 AM Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Richard Guo <guofenglinux(at)gmail(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | John Naylor | 2024-01-02 03:18:41 | Re: Segmentation fault caused by Postgrest - reateplan.c:6178 - prepare_sort_from_pathkeys |
| Previous Message | Magnus Hagander | 2024-01-01 15:14:25 | Re: Segmentation fault caused by Postgrest - reateplan.c:6178 - prepare_sort_from_pathkeys |