JSON_EXTRACT fails to cast as bool #12233
Description
Bug Report
Please answer these questions before submitting your issue. Thanks!
- What did you do?
in both MySQL and TiDB, run the following:
create database testjson;
use testjson;
create table testjson( id int auto_increment not null primary key, j json )default charset=utf8 engine=innodb;
insert into testjson set j='{"test":1}';
select id from testjson where json_extract(j, '$.test');
- What did you expect to see?
MySQL returns this:
+----+
| id |
+----+
| 1 |
+----+
1 row in set (0.001 sec)
- What did you see instead?
TiDB returns this:
ERROR 1105 (HY000): InvalidDataType("can\'t convert Json(1) to bool")
- What version of TiDB are you using (
tidb-server -Vor runselect tidb_version();on TiDB)?
v3.0.0-rc.1-256-g1ddb31720