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 по дате отправления: