Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.2(EOL)
Description
|
MySQL 5.7 |
MySQL [test]> SELECT JSON_MERGE('a','b'); |
ERROR 3141 (22032): Invalid JSON text in argument 1 to function json_merge: "Invalid value." at position 0. |
|
MariaDB 10.2 |
MariaDB [test]> SELECT JSON_MERGE('a','b'); |
+---------------------+ |
| JSON_MERGE('a','b') | |
+---------------------+ |
| ["a", "b"] | |
+---------------------+ |
1 row in set (0.00 sec) |
Attachments
Issue Links
- relates to
-
MDEV-9143 JSON_xxx functions
-
- Closed
-
Activity
In 10.2.3 this now returns NULL instead of the warning in MySQL 5.7.
|
MariaDB 10.2.3 |
SELECT JSON_MERGE('a','b'); |
+---------------------+ |
| JSON_MERGE('a','b') | |
+---------------------+ |
| NULL | |
+---------------------+ |
|
MySQL 5.7 |
SELECT JSON_MERGE('a','b'); |
ERROR 3141 (22032): Invalid JSON text in argument 1 to function json_merge: "Invalid value." at position 0. |
—
UPDATE: Apologies, different defaults and the warning does appear.
SHOW WARNINGS;
|
+---------+------+--------------------------------------------------------------------------------+
|
| Level | Code | Message |
|
+---------+------+--------------------------------------------------------------------------------+
|
| Warning | 4038 | Syntax error in JSON text in argument 1 to function 'json_merge' at position 1 |
|
+---------+------+--------------------------------------------------------------------------------+
|
Safe to re-close, unfortunately I can't do this.
http://lists.askmonty.org/pipermail/commits/2016-December/010214.html