Postgres Pro
Downloads
Home   >   mailing lists

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

From Sergei Kornilov
Subject Re: BUG #18123: The execution plan for the left join is incorrect, returning incorrect rows of data.
Date
Msg-id 7190521695295812@frjtxhjj64lsgce4.myt.yp-c.yandex.net
Whole thread Raw
In response to BUG #18123: The execution plan for the left join is incorrect, returning incorrect rows of data.  (PG Bug reporting form <noreply@postgresql.org>)
List pgsql-bugs
Tree view 
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 by date:

Previous
From: PG Bug reporting form
Date:
Subject: BUG #18127: Assertion HaveRegisteredOrActiveSnapshot failed on REINDEX CONCURRENTLY when blocksize=1
Next
From: Dean Rasheed
Date:
Subject: Re: BUG #18103: bugs of concurrent merge into when use different join plan