| Bug #99044 | JSON_SEARCH not support numeric | ||
|---|---|---|---|
| Submitted: | 24 Mar 2020 3:12 | Modified: | 7 Apr 2020 13:01 |
| Reporter: | wulin jia jia | Email Updates: | |
| Status: | Duplicate | Impact on me: | |
| Category: | MySQL Server: JSON | Severity: | S4 (Feature request) |
| Version: | 5.7.19 | OS: | Any |
| Assigned to: | CPU Architecture: | Any | |
| Tags: | json_search | ||
[7 Apr 2020 13:01]
MySQL Verification Team
Hi, Thank you for your feature request. However, this feature request has already being submitted. Hence, this request is a duplicate of the following one: https://bugs.mysql.com/bug.php?id=90085
Description: JSON_SEARCH([{id: 0,value: "test1"},{id: 1,value: "test2"}],'all','0',null,'$[*].id'); The above code cannot get the correct result,only suppor "0" How to repeat: JSON_SEARCH([{id: 0,value: "test1"},{id: 1,value: "test2"}],'all','0',null,'$[*].id'); Suggested fix: Support numeric