[MDEV-12774] JSON_EXTRACT fails with some escaped unicode as key - Jira

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Done
Affects Version/s: 10.2.5
Fix Version/s: 10.2.8
Component/s: JSON
Labels:
- JSON
Environment:
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

Ascending order - Click to sort in descending order

Elena Stepanova added a comment - 2017-05-12 16:36

MariaDB 10.2
MariaDB [(none)]> select @str, @path, JSON_EXTRACT(@str, @path);
+------------------------+------------------+---------------------------+
\| @str \| @path \| JSON_EXTRACT(@str, @path) \|
+------------------------+------------------+---------------------------+
\| {"\u00e4\u00f6":"yes"} \| $."\u00e4\u00f6" \| NULL \|
+------------------------+------------------+---------------------------+
1 row in set, 1 warning (0.00 sec)

MariaDB [(none)]> SHOW WARNINGS;
+---------+------+-----------------------------------------------------------------------------------+
\| Level \| Code \| Message \|
+---------+------+-----------------------------------------------------------------------------------+
\| Warning \| 4042 \| Syntax error in JSON path in argument 2 to function 'json_extract' at position 14 \|
+---------+------+-----------------------------------------------------------------------------------+
1 row in set (0.00 sec)

MariaDB [(none)]> SELECT JSON_VALID(@str);
+------------------+
\| JSON_VALID(@str) \|
+------------------+
\| 0 \|
+------------------+
1 row in set (0.00 sec)

MySQL 5.7
MySQL [test]> select @str, @path, JSON_EXTRACT(@str, @path);
+------------------------+------------------+---------------------------+
\| @str \| @path \| JSON_EXTRACT(@str, @path) \|
+------------------------+------------------+---------------------------+
\| {"\u00e4\u00f6":"yes"} \| $."\u00e4\u00f6" \| "yes" \|
+------------------------+------------------+---------------------------+
1 row in set (0.00 sec)

MySQL [test]> SELECT JSON_VALID(@str);
+------------------+
\| JSON_VALID(@str) \|
+------------------+
\| 1 \|
+------------------+
1 row in set (0.00 sec)

Elena Stepanova added a comment - 2017-05-12 16:36 MariaDB 10.2 MariaDB [(none)]> select @str, @path, JSON_EXTRACT(@str, @path); + ------------------------+------------------+---------------------------+ | @str | @path | JSON_EXTRACT(@str, @path) | + ------------------------+------------------+---------------------------+ | { "\u00e4\u00f6" : "yes" } | $. "\u00e4\u00f6" | NULL | + ------------------------+------------------+---------------------------+ 1 row in set , 1 warning (0.00 sec) MariaDB [(none)]> SHOW WARNINGS; + ---------+------+-----------------------------------------------------------------------------------+ | Level | Code | Message | + ---------+------+-----------------------------------------------------------------------------------+ | Warning | 4042 | Syntax error in JSON path in argument 2 to function 'json_extract' at position 14 | + ---------+------+-----------------------------------------------------------------------------------+ 1 row in set (0.00 sec) MariaDB [(none)]> SELECT JSON_VALID(@str); + ------------------+ | JSON_VALID(@str) | + ------------------+ | 0 | + ------------------+ 1 row in set (0.00 sec) MySQL 5.7 MySQL [test]> select @str, @path, JSON_EXTRACT(@str, @path); + ------------------------+------------------+---------------------------+ | @str | @path | JSON_EXTRACT(@str, @path) | + ------------------------+------------------+---------------------------+ | { "\u00e4\u00f6" : "yes" } | $. "\u00e4\u00f6" | "yes" | + ------------------------+------------------+---------------------------+ 1 row in set (0.00 sec) MySQL [test]> SELECT JSON_VALID(@str); + ------------------+ | JSON_VALID(@str) | + ------------------+ | 1 | + ------------------+ 1 row in set (0.00 sec)

Alexey Botchkov added a comment - 2017-09-12 13:55

The bug was fixed by an older commit.

Alexey Botchkov added a comment - 2017-09-12 13:55 The bug was fixed by an older commit.

People

Assignee:: Alexey Botchkov

Reporter:: Armin Preiml

Votes:: 1 Vote for this issue

Watchers:: 3 Start watching this issue

Dates

Created:: 2017-05-10 09:16

Updated:: 2017-09-12 13:55

Resolved:: 2017-09-12 13:55

Git Integration

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

MariaDB Server