[MDEV-13992] Implement JSON_MERGE_PATCH Created: 2017-10-03  Updated: 2022-08-01  Resolved: 2019-05-17

Status: Closed
Project: MariaDB Server
Component/s: JSON
Fix Version/s: 10.2.25, 10.3.16, 10.4.5

Type: Task Priority: Major
Reporter: Vincent Milum Jr Assignee: Alexey Botchkov
Resolution: Fixed Votes: 5
Labels: None

Issue Links:
Problem/Incident
causes MDEV-20174 Remove the JSON_MERGE function Closed
Relates
relates to MDEV-17397 Implement JSON functions available in... Open
relates to MDEV-20173 Document the JSON_MERGE_PATCH / JSON_... Closed
Epic Link: Implement JSON functions available in MySQL 8.0 but not MariaDB

 Description   

1) JSON_MERGE is listed as deprecated in MySQL (replaced by JSON_MERGE_PRESERVE), but is still in MariaDB.
2) RFC 7396 compliant JSON merging is missing from MariaDB.

MySQL 8.0 reference:
https://dev.mysql.com/doc/refman/8.0/en/json-modification-functions.html#function_json-merge-patch

MySQL 5.7.22 reference;
https://mysqlserverteam.com/new-json-functions-in-mysql-5-7-22/

RFC 7396:
https://tools.ietf.org/html/rfc7396

 Comments   
Comment by richardeaxon [ 2018-02-16 ]

This would be great.

Comment by Aleksey M. [ 2018-09-30 ]

This is very necessary!
Stupid json_merge break the object.

SELECT JSON_MERGE('{"Name": "Bartholomew"}', '{"Name": "Bart"}')
 
 
 
-- {"Name": ["Bartholomew", "Bart"]}

Comment by Aleksey M. [ 2018-10-07 ]

Please, @elenst, look at this task.
JSON_MERGE_PATCH is very necessary!

Comment by Alexey Botchkov [ 2019-05-17 ]

http://lists.askmonty.org/pipermail/commits/2019-May/013781.html

Generated at Thu Feb 08 08:10:04 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.