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

JSON_OBJECTAGG doesn't escape double quote in key

Details

    Description

      MariaDB [(none)]> SELECT JSON_OBJECT('"', 1), JSON_OBJECTAGG('"', 1);
      		 
      +---------------------+------------------------+
      		 
      | JSON_OBJECT('"', 1) | JSON_OBJECTAGG('"', 1) |
      		 
      +---------------------+------------------------+
      		 
      | {"\"": 1}           | {""":1}                |
      		 
      +---------------------+------------------------+
      		 
      1 row in set (0.000 sec)

      works correctly in MySQL 5.6

      Attachments

        Issue Links

          relates to

          Task - A task that needs to be done. MDEV-16620 Add support for JSON_ARRAYAGG and JSON_OBJECTAGG

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            libertyit Rogers created issue -
            libertyit Rogers made changes -
            Field Original Value New Value
            Description {{SELECT JSON_OBJECT('"', 1), JSON_OBJECTAGG('"', 1)}}

            returns

            {code}
            {"\"": 1} {""":1}
            {code}

            works correctly in MySQL 5.6

            {noformat}
            MariaDB [(none)]> SELECT JSON_OBJECT('"', 1), JSON_OBJECTAGG('"', 1);
            +---------------------+------------------------+
            | JSON_OBJECT('"', 1) | JSON_OBJECTAGG('"', 1) |
            +---------------------+------------------------+
            | {"\"": 1} | {""":1} |
            +---------------------+------------------------+
            1 row in set (0.000 sec)

            {noformat}

            works correctly in MySQL 5.6
            alice Alice Sherepa made changes -
            Affects Version/s 10.5 [ 23123 ]
            Affects Version/s 10.6 [ 24028 ]
            Affects Version/s 10.7 [ 24805 ]
            Affects Version/s 10.8 [ 26121 ]
            Affects Version/s 10.9 [ 26905 ]
            Affects Version/s 10.10 [ 27530 ]
            Affects Version/s 10.11 [ 27614 ]
            alice Alice Sherepa made changes -
            Fix Version/s 10.5 [ 23123 ]
            Fix Version/s 10.6 [ 24028 ]
            Fix Version/s 10.7 [ 24805 ]
            Fix Version/s 10.8 [ 26121 ]
            Fix Version/s 10.9 [ 26905 ]
            Fix Version/s 10.10 [ 27530 ]
            alice Alice Sherepa made changes -
            Assignee Alexey Botchkov [ holyfoot ]
            alice Alice Sherepa made changes -
            Status Open [ 1 ] Confirmed [ 10101 ]
            alice Alice Sherepa made changes -
            serg Sergei Golubchik made changes -
            Labels JSON_OBJECTAGG
            serg Sergei Golubchik made changes -
            Assignee Alexey Botchkov [ holyfoot ] Rucha Deodhar [ rucha174 ]
            Weijun Huang Weijun Huang added a comment - - edited

            This bug also happens in MasOS.

            MariaDB Version 10.5.16-MariaDB-debug
            		 
             - SSL connections supported
            		 
             - binaries are debug compiled
            		 
             - binaries built with wsrep patch
            		 
            Collecting tests...
            		 
            Installing system database...
            		 
             
            		 
            ==============================================================================
            		 
             
            		 
            TEST                                      RESULT   TIME (ms) or COMMENT
            		 
            --------------------------------------------------------------------------
            		 
             
            		 
            worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 16000..16019
            		 
            SELECT JSON_OBJECT('"', 1), JSON_OBJECTAGG('"', 1);
            		 
            JSON_OBJECT('"', 1)     JSON_OBJECTAGG('"', 1)
            		 
            {"\"": 1}       {""":1}
            		 
            main.json_test                           [ pass ]       
            --------------------------------------------------------------------------
            		 
            The servers were restarted 0 times
            		 
            Spent 0.000 of 7 seconds executing testcases
            		 
             
            		 
            Completed: All 1 tests were successful.

            Weijun Huang Weijun Huang added a comment - - edited This bug also happens in MasOS. MariaDB Version 10.5 . 16 -MariaDB-debug - SSL connections supported - binaries are debug compiled - binaries built with wsrep patch Collecting tests... Installing system database...   ==============================================================================   TEST RESULT TIME (ms) or COMMENT --------------------------------------------------------------------------   worker[ 1 ] Using MTR_BUILD_THREAD 300 , with reserved ports 16000 .. 16019 SELECT JSON_OBJECT( '"' , 1 ), JSON_OBJECTAGG( '"' , 1 ); JSON_OBJECT( '"' , 1 ) JSON_OBJECTAGG( '"' , 1 ) { "\"" : 1 } { "" ": 1 } main.json_test [ pass ] -------------------------------------------------------------------------- The servers were restarted 0 times Spent 0.000 of 7 seconds executing testcases   Completed: All 1 tests were successful.
            danblack Daniel Black added a comment -

            Thanks to Weijun / Alex Huang

            danblack Daniel Black added a comment - Thanks to Weijun / Alex Huang
            danblack Daniel Black made changes -
            issue.field.resolutiondate 2023-02-14 01:03:02.0 2023-02-14 01:03:02.626
            danblack Daniel Black made changes -
            Fix Version/s 10.5.20 [ 28512 ]
            Fix Version/s 10.6.13 [ 28514 ]
            Fix Version/s 10.8.8 [ 28518 ]
            Fix Version/s 10.9.6 [ 28520 ]
            Fix Version/s 10.10.4 [ 28522 ]
            Fix Version/s 10.11.3 [ 28524 ]
            Fix Version/s 11.0.1 [ 28548 ]
            Fix Version/s 10.5 [ 23123 ]
            Fix Version/s 10.6 [ 24028 ]
            Fix Version/s 10.7 [ 24805 ]
            Fix Version/s 10.8 [ 26121 ]
            Fix Version/s 10.9 [ 26905 ]
            Fix Version/s 10.10 [ 27530 ]
            Assignee Rucha Deodhar [ rucha174 ] Daniel Black [ danblack ]
            Resolution Fixed [ 1 ]
            Status Confirmed [ 10101 ] Closed [ 6 ]

            People

              danblack Daniel Black
              libertyit Rogers
              Votes:
              0 Vote for this issue
              Watchers:
              4 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.