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

From: Sergei Kornilov <sk(at)zsrv(dot)org>
To: dafoer_x(at)163(dot)com, pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: BUG #18123: The execution plan for the left join is incorrect, returning incorrect rows of data.
Date: 2023-09-21 11:30:12
Message-ID: 7190521695295812@frjtxhjj64lsgce4.myt.yp-c.yandex.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 actually executing the query.

regards, Sergei

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Dean Rasheed 2023-09-21 11:49:46 Re: BUG #18103: bugs of concurrent merge into when use different join plan
Previous Message PG Bug reporting form 2023-09-21 11:00:01 BUG #18127: Assertion HaveRegisteredOrActiveSnapshot failed on REINDEX CONCURRENTLY when blocksize=1