Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.2(EOL)
-
None
-
10.2.5-1
Description
E.g. while searching for values with single quote character - everything works as expected:
SELECT JSON_search( '{"x": "\'a\'"}', "one", '\'a\''); |
| "$.x" | |
SELECT JSON_search( '{"x": "\'"}', "one", '\''); |
| "$.x" | |
But "the same" search for double quotes returns no result:
SELECT JSON_search( '{"x": "\\"a\\""}', "one", '"a"'); |
| NULL | |
SELECT JSON_search( '{"x": "\\""}', "one", '"'); |
| NULL | |
In MySQL 5.7:
SELECT JSON_search( '{"x": "\\""}', "one", '"'); |
| "$.x" | |