Unexpected results of JSON_VALUE with DEFAULT ON EMPTY

Title

CI (CFBot)

Summary

Stats (from CFBot)

Patch version: v3, Patch count: 1, First patch: +111−16, All patches: +111−16

Tags

Bugfix

Created

2026-10-08 10:57:31

Last modified

2026-10-08 11:18:51 (35 minutes ago)

Latest email

2026-09-28 04:03:36 (1 week ago)

Status

PG20-3 (2026-11-01 – 2026-11-30): Needs review

Target version

Authors

Andrey Rachitskiy (a.rachitskiy)

Reviewers

Become reviewer

Committer

Links

Emails

First at 2026-08-15 03:25:40 by PG Bug reporting form <noreply at postgresql.org>
Latest at 2026-09-28 04:03:36 by Andrey Rachitskiy <pl0h0yp1 at gmail.com>
Latest attachment (v3-0001-Handle-SQL-NULL-inside-EEOP-JSONEXPR-PATH.patch) at 2026-09-28 04:03:36 from Andrey Rachitskiy <pl0h0yp1 at gmail.com>

    Attachment (v3-0001-Handle-SQL-NULL-inside-EEOP-JSONEXPR-PATH.patch) at 2026-09-28 04:03:36 from Andrey Rachitskiy <pl0h0yp1 at gmail.com> (Patch: No)
    Attachment (rows_oracle.sql.txt) at 2026-09-26 18:14:04 from Manu <manuelreyesbravo at gmail.com> (Patch: No)
    Attachment (v3-0001-Reset-JsonExpr-empty-error-flags-before-NULL-short-circuit.patch) at 2026-09-26 16:28:59 from jian he <jian.universality at gmail.com> (Patch: No)
    Attachment (v2-0001-Reset-JsonExpr-empty-error-flags-before-NULL-short-circuit.patch) at 2026-09-04 10:38:27 from Andrey Rachitskiy <pl0h0yp1 at gmail.com> (Patch: Yes)
    Attachment (0001-Reset-JsonExpr-empty-error-flags-before-NULL-short-circuit.patch) at 2026-08-16 14:29:25 from Andrey Rachitskiy <pl0h0yp1 at gmail.com> (Patch: Yes)

When	Who	Mail	Annotation
2026-10-08 10:58:52	Andrey Rachitskiy (a.rachitskiy)	From Andrey Rachitskiy <pl0h0yp1@gmail.com> at 2026-09-04 10:38:27	main patch
2026-10-08 11:18:50	Andrey Rachitskiy (a.rachitskiy)	From Andrey Rachitskiy <pl0h0yp1@gmail.com> at 2026-09-28 04:03:36	alternative patch from jian he

History

When	Who	What
2026-10-08 11:18:51	Andrey Rachitskiy (a.rachitskiy)	Added annotation "alternative patch from jian he" to CAB8bMiua3O8ZA1YHzQQYNLeDg+Pyom-XoiDx4_Z_QoA8WCu7Rw@mail.gmail.com
2026-10-08 11:16:19	Andrey Rachitskiy (a.rachitskiy)	Deleted annotation "alternative patch" from CACJufxFL-xzeD_GVVqbd1Jeab8unkbibM_=1cLBUASyi2bDx=g@mail.gmail.com
2026-10-08 10:59:36	Andrey Rachitskiy (a.rachitskiy)	Added annotation "alternative patch" to CACJufxFL-xzeD_GVVqbd1Jeab8unkbibM_=1cLBUASyi2bDx=g@mail.gmail.com
2026-10-08 10:58:52	Andrey Rachitskiy (a.rachitskiy)	Added annotation "main patch" to CAB8bMitawD=ERVLwYuDXvMT_OJqf+qAKx=3GEH6V_WHT7jnq7A@mail.gmail.com
2026-10-08 10:57:31	Andrey Rachitskiy (a.rachitskiy)	Attached mail thread 19621-0a480d2dc74e6bd5@postgresql.org
2026-10-08 10:57:31	Andrey Rachitskiy (a.rachitskiy)	Created patch record