Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #15857: Parallel Hash Join makes join instead of exists - Mailing list pgsql-bugs

From Pantelis Theodosiou
Subject Re: BUG #15857: Parallel Hash Join makes join instead of exists
Date
Msg-id CAE3TBxzstnF8HH7-=j0DDugwixjEjiONfZ15-sjvdKz8pvp9uA@mail.gmail.com
Whole thread Raw
In response to Re: BUG #15857: Parallel Hash Join makes join instead of exists  (Pantelis Theodosiou <ypercube@gmail.com>)
List pgsql-bugs
Tree view


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 by date:

Previous
From: Pantelis Theodosiou
Date:
Subject: Re: BUG #15857: Parallel Hash Join makes join instead of exists
Next
From: Thomas Munro
Date:
Subject: Re: BUG #15857: Parallel Hash Join makes join instead of exists