unary not with json argument is not compatible with MySQL #40683
Description
CREATE TABLE t0(c0 JSON );
INSERT INTO t0(c0) VALUES ('1895038629'), ('[]');
SELECT * FROM t0 WHERE NOT t0.c0;In MySQL, it gives nothing. In TiDB, it gives '[]'.
{{ message }}