Re: BUG #15857: Parallel Hash Join makes join instead of exists

Поиск
Список
Период
Сортировка
От Pantelis Theodosiou
Тема Re: BUG #15857: Parallel Hash Join makes join instead of exists
Дата
Msg-id CAE3TBxzstnF8HH7-=j0DDugwixjEjiONfZ15-sjvdKz8pvp9uA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: BUG #15857: Parallel Hash Join makes join instead of exists  (Pantelis Theodosiou <ypercube@gmail.com>)
Список pgsql-bugs
Дерево обсуждения


On Tue, Jun 18, 2019 at 9:56 AM Pantelis Theodosiou <ypercube@gmail.com> wrote:

...

I think it is correct result. This:

> UPDATE c SET base_id = id / 10;

would result in 9 rows (id from 1 to 9) to be updated with base_id = 0, as it should with integer division. These 9 rows will not match the condition:

WHERE c.base_id = a.id

as there is no row in a with a.id = 0



Please ignore the above, I  didn't read carefully.

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