Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.2(EOL)
Description
I am not sure where to refer what "json merge" means formally, but looking in several places makes me think that current 10.2 behavior is incorrect :
MariaDB [test]> select json_merge('{"a":"b"}', '{"a":"c"}') ; |
| {"a":"b", "a":"c"} | |
While both http://tools.knowledgewalls.com/onlinejsonmerger and MySQL 5.7 show:
mysql > select json_merge('{"a":"b"}', '{"a":"c"}') ; |
| {"a": ["b", "c"]} | |
Attachments
Activity
| Field | Original Value | New Value |
|---|---|---|
| Description |
I am not sure where to refer what "json merge" means formally, but looking in several places makes me think that current 10.2 behavior is incorrect :
{code:sql} MariaDB [test]> select json_merge('{"a":"b"}', '{"a":"c"}') ; | {"a":"b", "a":"c"} | {sql} While both http://tools.knowledgewalls.com/onlinejsonmerger and MySQL 5.7 show: {code:sql} MariaDB [test]> select json_merge('{"a":"b"}', '{"a":"c"}') ; | {"a": ["b", "c"]} | {sql} |
I am not sure where to refer what "json merge" means formally, but looking in several places makes me think that current 10.2 behavior is incorrect :
{code:sql} MariaDB [test]> select json_merge('{"a":"b"}', '{"a":"c"}') ; | {"a":"b", "a":"c"} | {code} While both http://tools.knowledgewalls.com/onlinejsonmerger and MySQL 5.7 show: {code:sql} MariaDB [test]> select json_merge('{"a":"b"}', '{"a":"c"}') ; | {"a": ["b", "c"]} | {code} |
| Description |
I am not sure where to refer what "json merge" means formally, but looking in several places makes me think that current 10.2 behavior is incorrect :
{code:sql} MariaDB [test]> select json_merge('{"a":"b"}', '{"a":"c"}') ; | {"a":"b", "a":"c"} | {code} While both http://tools.knowledgewalls.com/onlinejsonmerger and MySQL 5.7 show: {code:sql} MariaDB [test]> select json_merge('{"a":"b"}', '{"a":"c"}') ; | {"a": ["b", "c"]} | {code} |
I am not sure where to refer what "json merge" means formally, but looking in several places makes me think that current 10.2 behavior is incorrect :
{code:sql} MariaDB [test]> select json_merge('{"a":"b"}', '{"a":"c"}') ; | {"a":"b", "a":"c"} | {code} While both http://tools.knowledgewalls.com/onlinejsonmerger and MySQL 5.7 show: {code:sql} mysql > select json_merge('{"a":"b"}', '{"a":"c"}') ; | {"a": ["b", "c"]} | {code} |
| Affects Version/s | 10.2 [ 14601 ] |
| Labels | 10.2-rc |
| Status | Open [ 1 ] | In Progress [ 3 ] |
| issue.field.resolutiondate | 2017-02-09 21:24:53.0 | 2017-02-09 21:24:53.39 |
| Fix Version/s | 10.2.4 [ 22116 ] | |
| Fix Version/s | 10.2 [ 14601 ] | |
| Resolution | Fixed [ 1 ] | |
| Status | In Progress [ 3 ] | Closed [ 6 ] |
| Workflow | MariaDB v3 [ 79303 ] | MariaDB v4 [ 151570 ] |