Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #18766: not exists sometimes gives too few records - Mailing list pgsql-bugs

From David Rowley
Subject Re: BUG #18766: not exists sometimes gives too few records
Date
Msg-id CAApHDvoArAazq4SO6=8Ug_=2kMfhy96umr1GWUzQ6RDr_uRowA@mail.gmail.com
Whole thread Raw
In response to BUG #18766: not exists sometimes gives too few records  (PG Bug reporting form <noreply@postgresql.org>)
Responses Re: BUG #18766: not exists sometimes gives too few records
List pgsql-bugs
Tree view 
On Sat, 4 Jan 2025 at 06:28, PG Bug reporting form
<noreply@postgresql.org> wrote:
> All databases are running PostgreSQL 16.2 on Windows, to be specific:

You should really be running 16.6.   There was a bug fixed in 16.4
that sounds very likely to solve your problem, namely:

"Avoid incorrect results from Merge Right Anti Join plans (Richard
Guo)".  See [1]

If you still get wrong results with 16.6, please let us know.

David

[1] https://www.postgresql.org/docs/release/16.4/

pgsql-bugs by date:

Previous
From: Tomas Vondra
Date:
Subject: Re: BUG #18766: not exists sometimes gives too few records
Next
From: PG Bug reporting form
Date:
Subject: BUG #18767: Inconsistency in result of a Plpgsql GET DIAGNOSTICS PG_CONTEXT instruction.