Add SQL/JSON ON MISMATCH clause to JSON_VALUE, JSON_QUERY, JSON_TABLE

Edit
ID 6429
Title Add SQL/JSON ON MISMATCH clause to JSON_VALUE, JSON_QUERY, JSON_TABLE
CI (CFBot) Summary
Stats (from CFBot) Patch version: v2, Patch count: 1, First patch: +747−52, All patches: +747−52
Tags SQL Commands
Created 2026-01-24 17:16:29
Last modified 2026-04-10 12:23:37 (3 hours ago)
Latest email 2026-01-27 08:01:48 (2 months ago)
Status
PG20-1 (2026-07-01 – 2026-07-31): Needs review
PG19-Final (2026-03-01 – 2026-04-09): Moved to different CF
Target version 19
Authors Florents Tselai (florentst)
Reviewers Become reviewer
Committer
Links
Emails
Add SQL/JSON ON MISMATCH clause to JSON_VALUE
First at 2026-01-24 17:14:22 by Florents Tselai <florents.tselai at gmail.com>
Latest at 2026-01-27 08:01:48 by Florents Tselai <florents.tselai at gmail.com>
Latest attachment (v2-0001-Add-SQL-JSON-ON-MISMATCH-clause-to-JSON_VALUE-JSO.patch) at 2026-01-25 01:15:39 from Florents Tselai <florents.tselai at gmail.com>
    Attachment (v2-0001-Add-SQL-JSON-ON-MISMATCH-clause-to-JSON_VALUE-JSO.patch) at 2026-01-25 01:15:39 from Florents Tselai <florents.tselai at gmail.com> (Patch: Yes)
    Attachment (v1-0001-Add-SQL-JSON-ON-MISMATCH-clause-to-JSON_VALUE.patch) at 2026-01-24 17:14:22 from Florents Tselai <florents.tselai at gmail.com> (Patch: Yes)
History
When Who What
2026-04-10 12:23:37 Florents Tselai (florentst) Moved from CF PG19-Final to CF PG20-1
2026-01-25 01:13:33 Florents Tselai (florentst) Changed name to Add SQL/JSON ON MISMATCH clause to JSON_VALUE, JSON_QUERY, JSON_TABLE
2026-01-24 17:16:30 Florents Tselai (florentst) Attached mail thread CA+v5N42Kn65HauYbZJ=bAVHjzdp=wCg64dd+WzRmtu=Uu1z+Ow@mail.gmail.com
2026-01-24 17:16:29 Florents Tselai (florentst) Created patch record
Edit