pg.ddx.io  pgsql-bugs@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Richard Guo <guofenglinux@gmail.com>
Cc: Tender Wang <tndrwang@gmail.com>
Cc: runyuan@berkeley.edu
Cc: pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #19046: Incorrect result when using json_array() with column reference in subquery combined with RIGHT JOIN
Date: Wed, 10 Sep 2025 23:16:33 -0400
Message-ID: <1705246.1757560593@sss.pgh.pa.us> (raw)
In-Reply-To: <CAMbWs4-8iPbMZy3+pTvM1EkTyYNGVhX+GX+d9MUXYpYGkB6qJg@mail.gmail.com>
References: <19046-765b6602b0a8cfdf@postgresql.org>
	<CAHewXNmbpaVXfw7LSyHB8k8dVnJLNQO9R_-Zx7QK2XLPtz5QwA@mail.gmail.com>
	<CAHewXNnLLO1VuP3OJGRy2sc34xA0nWYSthCM1eeMD=bhkvMfYg@mail.gmail.com>
	<CAMbWs4_ijQEsfJPOvexRn0oweMoGZetOfmEZwRKrw6t_e0YY+g@mail.gmail.com>
	<CAHewXNnDLD9LZsOpzmymiFdaWmObhz=wCBBZdbrP2KAH+1-FJQ@mail.gmail.com>
	<CAMbWs4-8iPbMZy3+pTvM1EkTyYNGVhX+GX+d9MUXYpYGkB6qJg@mail.gmail.com>

Richard Guo <guofenglinux@gmail.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





view thread (11+ messages)  latest in thread

Message-ID: <1705246.1757560593@sss.pgh.pa.us>
Permalink:  ../1705246.1757560593@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/1705246.1757560593@sss.pgh.pa.us

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-bugs@postgresql.org
  Cc: tgl@sss.pgh.pa.us, guofenglinux@gmail.com, tndrwang@gmail.com, runyuan@berkeley.edu, pgsql-bugs@lists.postgresql.org
  Subject: Re: BUG #19046: Incorrect result when using json_array() with column reference in subquery combined with RIGHT JOIN
  In-Reply-To: <1705246.1757560593@sss.pgh.pa.us>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox