| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Richard Guo <guofenglinux(at)gmail(dot)com> |
| Cc: | 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-28 15:33:37 |
| Message-ID: | 556194.1669649617@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
Richard Guo <guofenglinux(at)gmail(dot)com> writes:
> I haven't got too much time looking into it. But the comment near the
> assertion failure that says
> * Unlike the LEFT/RIGHT cases, we just Assert that there are
> * no PHVs that need to be evaluated at the semijoin's RHS,
> * since the rest of the query couldn't reference any outputs
> * of the semijoin's RHS.
> I doubt this is true as a semijoin's qual can actually reference its
> RHS. In this case the assertion failure happens because there is PHV in
> the join's qual.
Yeah, the possibility of a PHV in the qual refutes that argument.
So we need to make the test honestly, as in the other arms of that
switch. Will fix.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2022-11-28 16:22:07 | Re: BUG #17700: An assert failed in prepjointree.c |
| Previous Message | PG Bug reporting form | 2022-11-28 15:27:17 | BUG #17701: Certificate verification problem when using proxies to access the server |