JSON_MERGE_PRESERVE
was introduced in MariaDB 10.2.25, MariaDB 10.3.16 and MariaDB 10.4.5.
JSON_MERGE_PRESERVE(json_doc, json_doc[, json_doc] ...)
Merges the given JSON documents, returning the merged result, or NULL if any argument is NULL.
JSON_MERGE_PRESERVE
was introduced in MariaDB 10.2.25, MariaDB 10.3.16 and MariaDB 10.4.5 as a synonym for JSON_MERGE, which has been deprecated.
SET @json1 = '[1, 2]'; SET @json2 = '[2, 3]'; SELECT JSON_MERGE_PATCH(@json1,@json2),JSON_MERGE_PRESERVE(@json1,@json2); +---------------------------------+------------------------------------+ | JSON_MERGE_PATCH(@json1,@json2) | JSON_MERGE_PRESERVE(@json1,@json2) | +---------------------------------+------------------------------------+ | [2, 3] | [1, 2, 2, 3] | +---------------------------------+------------------------------------+
© 2019 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.
https://mariadb.com/kb/en/json_merge_preserve/