Re: BUG #17982: Inconsistent results of SELECT with CTE caused by subquery comparison

Thanks for your information and the fixing! I will then apply your patch
and test postgres again.

Best,
Zuming

------------------------------------------------------------------------
*From:* Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us]
*Sent:* Monday, June 19, 2023 at 6:08 PM
*To:* zuming(dot)jiang(at)inf(dot)ethz(dot)ch
*Cc:* pgsql-bugs(at)lists(dot)postgresql(dot)org
*Subject:* BUG #17982: Inconsistent results of SELECT with CTE caused by
subquery comparison

> PG Bug reporting form<noreply(at)postgresql(dot)org> writes:
>> My fuzzer finds a correctness bug in Postgres, which makes Postgres return
>> inconsistent results.
> This appears to be the same issue you already reported in bug #17978.
> At least, the patch I just posted in that thread fixes this too.
>
> regards, tom lane