Re: BUG #18852: Unexpected expression in subquery output

From: Robins Tharakan <tharakan(at)gmail(dot)com>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Cc: Tender Wang <tndrwang(at)gmail(dot)com>
Subject: Re: BUG #18852: Unexpected expression in subquery output
Date: 2025-03-19 01:01:16
Message-ID: CAEP4nAw01qm8XyoKwjXFo7qSJx0izc0EBq8N_ZWM8FvYmVeX+Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Tue, 18 Mar 2025 at 01:51, Tender Wang <tndrwang(at)gmail(dot)com> wrote:

>
> PG Bug reporting form <noreply(at)postgresql(dot)org> 于2025年3月17日周一 16:35写道:
>
>> The following bug has been logged on the website:
>>
>> Bug reference: 18852
>>
>>
> I can reproduce this issue on HEAD.
> SELECT FROM a.f RIGHT JOIN b.h ON EXISTS (SELECT FROM a.e WHERE (SELECT
> NULL) > g) LIMIT 9;
>

FWIW, there's additional discussion happening in the original thread -

https://www.postgresql.org/message-id/flat/CAPpHfdsf_9OBXS1KzPQi%2BTAnNWPZGAzZ67xKn4-5uWhbg2dj-Q%40mail.gmail.com#555e7e7264f7c879f70810bf5b49c66f

-
robins
https://robins.in

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message 谭忠涛 2025-03-19 01:23:33 The != and +/- signs are joined together as an operator
Previous Message Robert Pufky 2025-03-18 22:38:06 Re: BUG #18856: Include directives for postgresql.conf, pg_hba.conf, pg_ident.conf behave inconsistently.