Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-13992

Implement JSON_MERGE_PATCH

Details

    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

      Attachments

        Issue Links

          causes

          Task - A task that needs to be done. MDEV-20174 Remove the JSON_MERGE function

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Closed
          relates to

          Epic - Created by Jira Software - do not edit or delete. Issue type for a big user story that needs to be broken down. MDEV-17397 Implement JSON functions available in MySQL 8.0 but not MariaDB

          • Major - Major loss of function.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. MDEV-20173 Document the JSON_MERGE_PATCH / JSON_MERGE_PRESERVE functions.

          • Major - Major loss of function.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            Ellerbrockr richardeaxon added a comment -

            This would be great.

            Ellerbrockr richardeaxon added a comment - This would be great.
            alekseymvt Aleksey M. added a comment - - edited

            This is very necessary!
            Stupid json_merge break the object.

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

            alekseymvt Aleksey M. added a comment - - edited This is very necessary! Stupid json_merge break the object. SELECT JSON_MERGE( '{"Name": "Bartholomew"}' , '{"Name": "Bart"}' )   -- {"Name": ["Bartholomew", "Bart"]}
            alekseymvt Aleksey M. added a comment - - edited

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

            alekseymvt Aleksey M. added a comment - - edited Please, @elenst, look at this task. JSON_MERGE_PATCH is very necessary!
            holyfoot Alexey Botchkov added a comment -

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

            holyfoot Alexey Botchkov added a comment - http://lists.askmonty.org/pipermail/commits/2019-May/013781.html

            People

              holyfoot Alexey Botchkov
              darkain Vincent Milum Jr
              Votes:
              5 Vote for this issue
              Watchers:
              6 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.