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

JSON_EXTRACT fails with some escaped unicode as key

    XMLWordPrintable

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

          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.