Fix JSON_ARRAY(query) empty set handling and view deparsing

Title

CI (CFBot)

Needs rebase! Needs rebase since 15 hours. Failing since 15 hours.
Additional links previous successfully applied patch (outdated):

Summary

Stats (from CFBot)

Unknown

Tags

Bugfix

Created

2026-03-31 06:39:08

Last modified

2026-03-31 06:39:08 (2 weeks ago)

Latest email

2026-03-04 06:35:56 (1 month ago)

Status

PG20-1 (2026-07-01 – 2026-07-31): Needs review

Target version

stable

Authors

Richard Guo (richardguo)

Reviewers

Committer

Links

Emails

BUG #19418: SQL/JSON JSON_VALUE() does not conform to ISO/IEC 9075-2:2023(E) 6.34 <JSON value constructor>: First at 2026-02-26 09:57:50 by PG Bug reporting form <noreply at postgresql.org>
Latest at 2026-03-04 06:35:56 by Richard Guo <guofenglinux at gmail.com>
Latest attachment (v3-0001-Fix-JSON_ARRAY-query-empty-set-handling-and-view-.patch) at 2026-03-04 06:35:56 from Richard Guo <guofenglinux at gmail.com>
    Attachment (v3-0001-Fix-JSON_ARRAY-query-empty-set-handling-and-view-.patch) at 2026-03-04 06:35:56 from Richard Guo <guofenglinux at gmail.com> (Patch: Yes)
    Attachment (v2-0001-Fix-JSON_ARRAY-query-empty-set-handling-and-view-.patch) at 2026-03-03 14:32:12 from Richard Guo <guofenglinux at gmail.com> (Patch: Yes)
    Attachment (v1-0001-Fix-JSON_ARRAY-query-to-return-on-empty-sets.patch) at 2026-03-02 05:09:46 from Richard Guo <guofenglinux at gmail.com> (Patch: Yes)

History

When	Who	What
2026-04-15 06:02:32	CFbot	Patch needs rebase
2026-03-31 06:39:08	Richard Guo (richardguo)	Attached mail thread 19418-591ba1f29862ef5b@postgresql.org
2026-03-31 06:39:08	Richard Guo (richardguo)	Created patch record