Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.2(EOL)
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
| Link | This issue relates to TODO-873 [ TODO-873 ] |
| Labels | json-10.2 |
| Component/s | JSON [ 13908 ] | |
| Component/s | OTHER [ 10125 ] |
| Status | Open [ 1 ] | In Progress [ 3 ] |
| Fix Version/s | 10.2.3 [ 22115 ] | |
| Fix Version/s | 10.2 [ 14601 ] | |
| Resolution | Fixed [ 1 ] | |
| Status | In Progress [ 3 ] | Closed [ 6 ] |
| Workflow | MariaDB v3 [ 78552 ] | MariaDB v4 [ 151276 ] |
http://lists.askmonty.org/pipermail/commits/2016-December/010213.html