Horton
Menu

Re: BUG #18852: Unexpected expression in subquery output

Robins Tharakan <tharakan@gmail.com>

View thread
From: Robins Tharakan <tharakan@gmail.com>
To: pgsql-bugs@lists.postgresql.org
Cc: Tender Wang <tndrwang@gmail.com>
Date: 2025-03-19T01:01:16Z
Lists: pgsql-bugs 
On Tue, 18 Mar 2025 at 01:51, Tender Wang <tndrwang@gmail.com> wrote:

>
> PG Bug reporting form <noreply@postgresql.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

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

  1. Add support for deparsing semi-joins to contrib/postgres_fdw