Unexpected results of JSON_VALUE with DEFAULT ON EMPTY

Log in to edit
ID 7414
Title Unexpected results of JSON_VALUE with DEFAULT ON EMPTY
CI (CFBot) Summary
Stats (from CFBot) Patch version: v4, Patch count: 1, First patch: +140−19, All patches: +140−19
Tags Bugfix
Created 2026-10-08 10:57:31
Last modified 2026-11-05 03:52:36 (9 minutes ago)
Latest email 2026-11-04 16:28:56 (11 hours ago)
Status
PG20-3 (2026-11-01 – 2026-11-30): Committed
Target version
Authors Andrey Rachitskiy (a.rachitskiy)
Reviewers Log in to become reviewer
Committer Amit Langote (amitlan)
Links
Emails
BUG #19621: Unexpected results of JSON_VALUE with DEFAULT ON EMPTY
First at 2026-08-15 03:25:40 by PG Bug reporting form <noreply at postgresql.org>
Latest at 2026-11-04 16:28:56 by Andrey Rachitskiy <pl0h0yp1 at gmail.com>
Latest attachment (v4-0001-SQL-JSON-Fix-ON-EMPTY-ERROR-state-leakage-on-NULL.patch) at 2026-11-04 10:05:42 from Amit Langote <amitlangote09 at gmail.com>
    Attachment (v4-0001-SQL-JSON-Fix-ON-EMPTY-ERROR-state-leakage-on-NULL.patch) at 2026-11-04 10:05:42 from Amit Langote <amitlangote09 at gmail.com> (Patch: No)
    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)

Annotations

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-11-05 03:52:36 Andrey Rachitskiy (a.rachitskiy) Closed in commitfest PG20-3 with status: Committed
2026-11-05 03:52:36 Andrey Rachitskiy (a.rachitskiy) Changed committer to amitlan
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
Log in to edit