Incorrect query result
sayJason opened this issue · 0 comments
sayJason commented
Bug Report
Please answer these questions before submitting your issue. Thanks!
1. Minimal reproduce step (Required)
CREATE TABLE t1 (c1 INT UNSIGNED NOT NULL );
INSERT INTO t1 VALUES (0);
SELECT c1 FROM t1 WHERE c1 > CAST(POW(-'0', 1) AS BINARY); -- actual: {0}, expected: {}
2. What did you expect to see? (Required)
SELECT returns empty
3. What did you see instead (Required)
SELECT returns the column c1's value
4. What is your TiDB version? (Required)
Release Version: v7.1.0
Edition: Community
Git Commit Hash: 635a436
Git Branch: heads/refs/tags/v7.1.0
UTC Build Time: 2023-05-30 10:58:57
GoVersion: go1.20.3
Race Enabled: false
TiKV Min Version: 6.2.0-alpha
Check Table Before Drop: false
Store: tikv