Bug #81283 JSON replace or merge_replace function

Description:
Michael Slowik requested this feature at MySQL Innovation Day.
 	

JSON_MERGE('{ "a": 1, "b":2 }','{ "a": 3, "c":4 }');
returns { "a": [1,3], "b":2, "c": 4}

He wants a JSON_Merge_Replace function.
JSON_Merge_Replace('{ "a": 1, "b":2}','{ "a": 3, "c":4 }');
returns '{ "a": 3, "b":2, "c": 4}'

How to repeat:
JSON_MERGE('{ "a": 1, "b":2 }','{ "a": 3, "c":4 }');
returns { "a": [1,3], "b":2, "c": 4}

He wants a JSON_Merge_Replace function.
JSON_Merge_Replace('{ "a": 1, "b":2}','{ "a": 3, "c":4 }');
returns '{ "a": 3, "b":2, "c": 4}'

Hello Manyi Lu,

Thank you for the reasonable feature request!

Thanks,
Umesh

Fixed in MySQL 8.0.3 through addition of JSON_MERGE_PATCH() function and renaming of JSON_MERGE() to JSON_MERGE_PRESERVE().

Closed.