Re: BUG #18766: not exists sometimes gives too few records

From: David Rowley <dgrowleyml(at)gmail(dot)com>
To: jan(dot)kort(at)genetics(dot)nl, pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: BUG #18766: not exists sometimes gives too few records
Date: 2025-01-04 12:15:11
Message-ID: CAApHDvoArAazq4SO6=8Ug_=2kMfhy96umr1GWUzQ6RDr_uRowA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Sat, 4 Jan 2025 at 06:28, PG Bug reporting form
<noreply(at)postgresql(dot)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/

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message PG Bug reporting form 2025-01-06 08:24:33 BUG #18767: Inconsistency in result of a Plpgsql GET DIAGNOSTICS PG_CONTEXT instruction.
Previous Message Tomas Vondra 2025-01-04 11:43:28 Re: BUG #18766: not exists sometimes gives too few records