Re: BUG #19046: Incorrect result when using json_array() with column reference in subquery combined with RIGHT JOIN

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Richard Guo <guofenglinux(at)gmail(dot)com>
Cc: Tender Wang <tndrwang(at)gmail(dot)com>, runyuan(at)berkeley(dot)edu, pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: BUG #19046: Incorrect result when using json_array() with column reference in subquery combined with RIGHT JOIN
Date: 2025-09-11 03:16:33
Message-ID: 1705246.1757560593@sss.pgh.pa.us
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Richard Guo <guofenglinux(at)gmail(dot)com> writes:
> I tested JsonExpr, which is the representation of json_value,
> json_query and json_exists. It seems that they could not produce
> non-NULL output with a NULL input. So we are good on that front.

Seems like we ought to actually look at the relevant code, not
try to test our way to an understanding of it.

regards, tom lane

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message PG Bug reporting form 2025-09-11 07:09:36 BUG #19047: pg_last_wal_replay_lsn() returns non-NULL after pg_promote()
Previous Message Richard Guo 2025-09-11 03:10:15 Re: BUG #19046: Incorrect result when using json_array() with column reference in subquery combined with RIGHT JOIN