Re: BUG #17982: Inconsistent results of SELECT with CTE caused by subquery comparison - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #17982: Inconsistent results of SELECT with CTE caused by subquery comparison
Date
Msg-id 2980037.1687190927@sss.pgh.pa.us
Whole thread Raw
In response to BUG #17982: Inconsistent results of SELECT with CTE caused by subquery comparison  (PG Bug reporting form <noreply@postgresql.org>)
Responses Re: BUG #17982: Inconsistent results of SELECT with CTE caused by subquery comparison  (Zu-Ming Jiang <zuming.jiang@inf.ethz.ch>)
List pgsql-bugs
PG Bug reporting form <noreply@postgresql.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



pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #17978: Unexpected error: "wrong varnullingrels (b) (expected (b 5)) for Var 6/2" triggered by JOIN
Next
From: Andres Freund
Date:
Subject: Re: BUG #17973: Reinit of pgstats entry for dropped DB can break autovacuum daemon