| From: | Richard Guo <guofenglinux(at)gmail(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Andrey Lepikhov <a(dot)lepikhov(at)postgrespro(dot)ru>, PostgreSQL mailing lists <pgsql-bugs(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Clause accidentally pushed down ( Possible bug in Making Vars outer-join aware) |
| Date: | 2023-03-02 09:57:35 |
| Message-ID: | CAMbWs49J+VXT6KA2nmjdrm_i4tt5B1PRP0uge0F52MMV9OdvFQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | Postg와이즈 토토SQL : Postg와이즈 토토SQL 메일 링리스트 : 2023-03-02 이후 PGSQL-BUGS 09:57 |
On Wed, Mar 1, 2023 at 2:44 PM Richard Guo <guofenglinux(at)gmail(dot)com> wrote:
> Do we need to revise how we build target list for outer join by
> adjusting the nullingrels of Vars and PHVs from input_rel in a similar
> way?
>
Hmm. Doing this complicates matters even more. Maybe we can just loosen
the cross-check for nullingrels to cope with this change by using
NRM_SUBSET matches for joinquals (including mergeclauses, hashclauses
and hashkeys) in set_join_references()?
Thanks
Richard
| From | Date | Subject | |
|---|---|---|---|
| Next Message | PG Bug reporting form | 2023-03-02 11:46:06 | BUG #17819: The assert failed #17334 has not been repaired |
| Previous Message | PG Bug reporting form | 2023-03-02 08:33:51 | BUG #17818: CTE is not returning the right data. |