[MDEV-11433] JSON_MERGE returns a non-NULL result with a NULL argument - Jira

XML

Word

Printable

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Fixed
Affects Version/s: 10.2(EOL)
Fix Version/s: 10.2.3
Component/s: JSON
Labels:
- json-10.2

Description

Note: Since we don't have any documented differences between our implementation of JSON functions and Oracle's, here and further I will assume they are supposed to be result-compatible.

MariaDB 10.2
MariaDB [test]> select JSON_MERGE(NULL,JSON_OBJECT('foo', 1));
+----------------------------------------+
\| JSON_MERGE(NULL,JSON_OBJECT('foo', 1)) \|
+----------------------------------------+
\| [null, {"foo": 1}] \|
+----------------------------------------+
1 row in set (0.00 sec)

MySQL 5.7
MySQL [test]> select JSON_MERGE(NULL,JSON_OBJECT('foo', 1));
+----------------------------------------+
\| JSON_MERGE(NULL,JSON_OBJECT('foo', 1)) \|
+----------------------------------------+
\| NULL \|
+----------------------------------------+
1 row in set (0.00 sec)

It is also documented in MySQL manual:
https://dev.mysql.com/doc/refman/5.7/en/json-modification-functions.html#function_json-merge

Returns NULL if any argument is NULL

Attachments

Issue Links

relates to

MDEV-9143 JSON_xxx functions

Closed

Activity

People

Assignee:: Alexey Botchkov

Reporter:: Elena Stepanova

Votes:: 0 Vote for this issue

Watchers:: 2 Start watching this issue

Dates

Created:: 2016-12-01 02:08

Updated:: 2017-02-20 15:26

Resolved:: 2016-12-05 21:58

Git Integration

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