Bug #70574 JSON_MERGE treats document without opening bracket as valid
| Submitted: | 9 Oct 2013 19:23 | Modified: | 6 Nov 2013 18:21 |
|---|---|---|---|
| Reporter: | Sveta Smirnova | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | MySQL Server: JSON User-defined function ( UDF ) | Severity: | S3 (Non-critical) |
| Version: | 0.2 | OS: | Any |
| Assigned to: | Sveta Smirnova | CPU Architecture: | Any |
[9 Oct 2013 22:12]
Sveta Smirnova
Sorry: used outdated udf binary. With correct binary results are still wrong, but in different way:
mysql> select json_merge('[1,2]', '[3,4,5]' );
+---------------------------------+
| json_merge('[1,2]', '[3,4,5]' ) |
+---------------------------------+
| [1,2] |
+---------------------------------+
1 row in set (0.00 sec)
mysql> select json_merge('"a":"b"}', '{"c":"d"}' );
+--------------------------------------+
| json_merge('"a":"b"}', '{"c":"d"}' ) |
+--------------------------------------+
| "a":"b", "c":"d"} |
+--------------------------------------+
1 row in set (0.00 sec)
mysql> select json_merge('"a":"b"}', '{"c":"d"}' );
+--------------------------------------+
| json_merge('"a":"b"}', '{"c":"d"}' ) |
+--------------------------------------+
| "a":"b", "c":"d"} |
+--------------------------------------+
1 row in set (0.00 sec)
[6 Nov 2013 18:20]
Sveta Smirnova
Posted by developer: Fixed in versions 0.2.1 and 0.3.0
Portions of this website are copyright © 2001, 2002 The PHP Group
Page generated in 0.039 sec. using MySQL 8.4.7-u6-cloud
Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the
respective copyright holders.
It is not reviewed in advance
by Oracle and does not necessarily represent the opinion of
Oracle or any other party.
Description: README file says that if the first document does not contain opening curly bracket, JSON_MERGE should return NULL. But it does not. How to repeat: mysql> select json_merge('"a":"b"}', '{"c":"d"}' )\G *************************** 1. row *************************** json_merge('"a":"b"}', '{"c":"d"}' ): { } A user reports different output: mysql> select json_merge('"a":"b"}', '{"c":"d"}' )\G *************************** 1. row *************************** json_merge('"a":"b"}', '{"c":"d"}' ): "a":"b", "c":"d"} (http://blog.ulf-wendel.de/2013/mysql-5-7-sql-functions-for-json-udf/)