Re: BUG #15128: Erroneous inner query is executing with wrong results

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: "yossi(dot)eilaty(at)gong(dot)io" <yossi(dot)eilaty(at)gong(dot)io>, "pgsql-bugs(at)lists(dot)postgresql(dot)org" <pgsql-bugs(at)lists(dot)postgresql(dot)org>
Subject: Re: BUG #15128: Erroneous inner query is executing with wrong results
Date: 2018-03-22 15:02:21
Message-ID: CAKFQuwa8pAMecPSBx3yxwaY1YdYrkR1VkFLv-_A+OSGObQQ5bw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Thursday, March 22, 2018, PG Bug reporting form <noreply(at)postgresql(dot)org>
wrote:

>
> where, again, the innermost query is wrong (there's no x in a).
>

This is a correlated subquery working as designed.

David J.

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Keith Fiske 2018-03-22 16:25:44 Re: BUG #15126: bug report for pgAdmin 4 v2.1
Previous Message Tom Lane 2018-03-22 14:35:02 Re: BUG #15127: epoch lies 1 hour ahead