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 ]
            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.