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/