Re: Bug in execution of EXISTS and IN clauses for large tables

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: Bug in execution of EXISTS and IN clauses for large tables
Дата
Msg-id CAKFQuwZu-JTRz2R6+Xshm3-VzYEctzMo7hjj4Zn+dVcXypJHMA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Bug in execution of EXISTS and IN clauses for large tables  ("David G. Johnston" <david.g.johnston@gmail.com>)
Ответы Re: Bug in execution of EXISTS and IN clauses for large tables  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs


On Tuesday, February 22, 2022, David G. Johnston <david.g.johnston@gmail.com> wrote:


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.


My bad, too early for me…

This seems like a decent report (haven’t played with it), still, version 11.1!

David J.
 

В списке pgsql-bugs по дате отправления:

Предыдущее
От: "David G. Johnston"
Дата:
Сообщение: Re: Bug in execution of EXISTS and IN clauses for large tables
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Bug in execution of EXISTS and IN clauses for large tables