Postgres Pro
Downloads
Home   >   mailing lists

Re: Bug in execution of EXISTS and IN clauses for large tables - Mailing list pgsql-bugs

From David G. Johnston
Subject Re: Bug in execution of EXISTS and IN clauses for large tables
Date
Msg-id CAKFQuwbUMiHqeLZkCqqCL9gr0soREjprmTrQXJT1iQATfoNWEQ@mail.gmail.com
Whole thread Raw
In response to Bug in execution of EXISTS and IN clauses for large tables  (Martin Kos <martin.kos@molecularhealth.com>)
Responses Re: Bug in execution of EXISTS and IN clauses for large tables  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-bugs
Tree view


On Tuesday, February 22, 2022, Martin Kos <martin.kos@molecularhealth.com> wrote:


I would like to report an unexpected behavior of the queries using either the EXISTS or IN clauses.


I am using PostgreSQL version 11.1 (accessed via the DBVisualizer).



Reporting bugs without a standalone reproducer against long unsupported versions is generally inactionable.

Though at minimum providing explain analyze results, especially if you have a near equivalent query that supposedly works, is needed.

David J.

pgsql-bugs by date:

Previous
From: Martin Kos
Date:
Subject: Bug in execution of EXISTS and IN clauses for large tables
Next
From: "David G. Johnston"
Date:
Subject: Re: Bug in execution of EXISTS and IN clauses for large tables