Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Duplicate
-
10.11, 11.4, 11.8, 12.1
-
Not for Release Notes
Description
It seems some recent change has broken JSON parsing/quering.
SQL:
select json_value('""', '$') |
started to return:
+-----------------------+
|
| json_value('""', '$') |
|
+-----------------------+
|
| NULL |
|
+-----------------------+
|
but I expect the following result instead:
+-----------------------+
|
| json_value('""', '$') |
|
+-----------------------+
|
| |
|
+-----------------------+
|
since version:
- 10.11.14
- 11.4.8
- 11.8.3
- 12.0.2
I belive this functional change is unintended as no other DB vendors behave like this.
Please confirm and fix.
Attachments
Issue Links
- duplicates
-
MDEV-37428 JSON_VALUE returns NULL for a key with an empty string value rather than an empty string
-
- Closed
-