Request a Demo
Home   >   mailing lists

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

From Tom Lane
Subject Re: BUG #19046: Incorrect result when using json_array() with column reference in subquery combined with RIGHT JOIN
Date
Msg-id 1705246.1757560593@sss.pgh.pa.us
Whole thread Raw
In response to Re: BUG #19046: Incorrect result when using json_array() with column reference in subquery combined with RIGHT JOIN  (Richard Guo <guofenglinux@gmail.com>)
List pgsql-bugs
Tree view 
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

pgsql-bugs by date:

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