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

JSON_EXTRACT fails with some escaped unicode as key

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Done
    • 10.2.5
    • 10.2.8
    • JSON
    • Ubuntu 17.04

    Description

      JSON_EXTRACT fails to handle specific escaped unicode sequence. Here is a example:

      SET @str = "{\"\\u00e4\\u00f6\":\"yes\"}";
      SET @path = "$.\"\\u00e4\\u00f6\"";
      select @str, @path, JSON_EXTRACT(@str, @path);
      

      Here JSON extract returns null. I've testet the same code on mysql and it works fine. The next example, containing only the first unicode character runs fine on mariadb and mysql.

      SET @str = "{\"\\u00e4\":\"yes\"}";
      SET @path = "$.\"\\u00e4\"";
      select @str, @path, JSON_EXTRACT(@str, @path);
      

      Attachments

        Activity

          Transition Time In Source Status Execution Times
          Elena Stepanova made transition -
          Open Confirmed
          2d 7h 17m 1
          Alexey Botchkov made transition -
          Confirmed In Progress
          122d 21h 19m 1
          Alexey Botchkov made transition -
          In Progress Closed
          1m 6s 1

          People

            holyfoot Alexey Botchkov
            apreiml Armin Preiml
            Votes:
            1 Vote for this issue
            Watchers:
            3 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.