Fix JSON_ARRAY(query) empty set handling and view deparsing

Title

CI (CFBot)

Summary

Stats (from CFBot)

Patch version: v4, Patch count: 1, First patch: +304−27, All patches: +304−27

Tags

Bugfix

Created

2026-03-31 06:39:08

Last modified

2026-05-01 05:25:41 (2 weeks ago)

Latest email

2026-05-08 08:35:27 (1 week ago)

Status

PG20-1 (2026-07-01 – 2026-07-31): Committed

Target version

stable

Authors

Richard Guo (richardguo)

Reviewers

Become reviewer

Committer

Richard Guo (richardguo)

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-05-08 08:35:27 by Richard Guo <guofenglinux at gmail.com>
Latest attachment (v4-0001-Fix-JSON_ARRAY-query-empty-set-handling-and-view-.patch) at 2026-04-16 06:04:49 from Richard Guo <guofenglinux at gmail.com>
    Attachment (v4-0001-Fix-JSON_ARRAY-query-empty-set-handling-and-view-.patch) at 2026-04-16 06:04:49 from Richard Guo <guofenglinux at gmail.com> (Patch: No)
    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-05-01 05:25:41	Richard Guo (richardguo)	Closed in commitfest PG20-1 with status: Committed
2026-05-01 05:25:41	Richard Guo (richardguo)	Changed committer to richardguo
2026-04-16 06:36:30	CFbot	Patch does not need rebase anymore
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