Re: BUG #18123: The execution plan for the left join is incorrect, returning incorrect rows of data.

Поиск
Список
Период
Сортировка
От Sergei Kornilov
Тема Re: BUG #18123: The execution plan for the left join is incorrect, returning incorrect rows of data.
Дата
Msg-id 7190521695295812@frjtxhjj64lsgce4.myt.yp-c.yandex.net
обсуждение исходный текст
Ответ на BUG #18123: The execution plan for the left join is incorrect, returning incorrect rows of data.  (PG Bug reporting form <noreply@postgresql.org>)
Список pgsql-bugs
Дерево обсуждения 
Hello
Usual query error, not a bug.

"where a2.a=3" turns left join to inner join because a2.a can not be null here.

This way the conditions contradict each other and it is possible to immediately get an empty set as a result without
actuallyexecuting the query.
 

regards, Sergei

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

Предыдущее
От: PG Bug reporting form
Дата:
Сообщение: BUG #18127: Assertion HaveRegisteredOrActiveSnapshot failed on REINDEX CONCURRENTLY when blocksize=1
Следующее
От: Dean Rasheed
Дата:
Сообщение: Re: BUG #18103: bugs of concurrent merge into when use different join plan