extra double quotes for result of json_search

[guo-shaoge]

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

select json_search('{"one potato": "food"}', "all", "food");

2. What did you expect to see? (Required)

mysql> select json_search('{"one potato": "food"}', "all", "food");
+------------------------------------------------------+
| json_search('{"one potato": "food"}', "all", "food") |
+------------------------------------------------------+
| "$.\"one potato\""                                   |
+------------------------------------------------------+
1 row in set (0.00 sec)

3. What did you see instead (Required)

mysql> select json_search('{"one potato": "food"}', "all", "food");
+------------------------------------------------------+
| json_search('{"one potato": "food"}', "all", "food") |
+------------------------------------------------------+
| "$.one potato"                                       |
+------------------------------------------------------+
1 row in set (0.00 sec)

4. What is your TiDB version? (Required)

master