From: | Richard Guo <guofenglinux(at)gmail(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | Daniel Gustafsson <daniel(at)yesql(dot)se>, xinwen(at)stu(dot)scu(dot)edu(dot)cn, pgsql-bugs(at)lists(dot)postgresql(dot)org |
Subject: | Re: BUG #17700: An assert failed in prepjointree.c |
Date: | 2022-11-29 00:12:16 |
Message-ID: | CAMbWs4_68Hh9CSnCPhHy0eHmsJcGMiDRxswQfMT0SjxmB=EB2w@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
On Tue, Nov 29, 2022 at 12:22 AM Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Actually ... it seems like we could just drop that Assert, as per
> revised argument in the comment. This'd explain the lack of field
> complaints: there's no bug in a production build.
Ah yes, that's right. We can be sure that above the semijoin there
would be no reference to its RHS. And the PHV in semijoin's qual seems
unnecessary.
This reminds me of another question I had about unwrapping unnecessary
PHVs [1]. Sad that we don't have infrastructure for that.
Thanks
Richard
From | Date | Subject | |
---|---|---|---|
Next Message | David G. Johnston | 2022-11-29 00:35:32 | Re: daterange() is ignoring 3rd boundaries argument |
Previous Message | Robert KOFLER | 2022-11-28 23:50:51 | daterange() is ignoring 3rd boundaries argument |