From: Tom Lane <tgl@sss.pgh.pa.us>
To: Richard Guo <guofenglinux@gmail.com>
Cc: xinwen@stu.scu.edu.cn
Cc: pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #17700: An assert failed in prepjointree.c
Date: Mon, 28 Nov 2022 10:33:37 -0500
Message-ID: <556194.1669649617@sss.pgh.pa.us> (raw)
In-Reply-To: <CAMbWs4-VqpU4qBmO6Ktrt0Ur5OuV7OgZuDEx2GuVCajFrV6xAA@mail.gmail.com>
References: <17700-2b5c10d917c30687@postgresql.org>
<CAMbWs4-VqpU4qBmO6Ktrt0Ur5OuV7OgZuDEx2GuVCajFrV6xAA@mail.gmail.com>
Richard Guo <guofenglinux@gmail.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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: tgl@sss.pgh.pa.us, guofenglinux@gmail.com, xinwen@stu.scu.edu.cn, pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #17700: An assert failed in prepjointree.c
In-Reply-To: <556194.1669649617@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox