[MDEV-19664] JSON_VALUE and null values - Jira

XML

Word

Printable

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Duplicate
Affects Version/s: 10.5, 10.6, 10.4.5, 10.2(EOL), 10.3(EOL), 10.4(EOL), 10.7(EOL)
Fix Version/s: 10.3.38, 10.4.28, 10.5.19, 10.6.12, 10.7.8
Component/s: JSON
Labels:
None
Environment:
Windows

I have found the following bug:

> set @xxx= JSON_INSERT('{}', '$.C', NULL);

> select @xxx

+-------------+

| @xxx        |

+-------------+

| {"C": null} |

+-------------+

1 row in set (0.001 sec){quote}

> select nvl(json_value(@xxx, '$.C'),'NVL-NULL-VALUE');

+-----------------------------------------------+

| nvl(json_value(@xxx, '$.C'),'NVL-NULL-VALUE') |

+-----------------------------------------------+

| null                                          |

+-----------------------------------------------+

1 row in set (0.001 sec)

I was expecting

> select nvl(json_value(@xxx, '$.C'),'NVL-NULL-VALUE');

+-----------------------------------------------+

| nvl(json_value(@xxx, '$.C'),'NVL-NULL-VALUE') |

+-----------------------------------------------+

| NVL-NULL-VALUE                                |

+-----------------------------------------------+

1 row in set (0.001 sec)

is duplicated by

MDEV-27151 JSON_VALUE() does not parse NULL properties properly

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.