Description:
From my understanding, the first query below should return empty, but it is actually return 1 row.
mysql> SELECT t0.c0 FROM t0 WHERE (t0.c0) = (IF(1122822918, 0.34987436284057793, NULL));
+----------------------+
| c0 |
+----------------------+
| 00000000000000000000 |
+----------------------+
1 row in set (0.00 sec)
mysql> SELECT SUM(((t0.c0) = (IF(1122822918, 0.34987436284057793, NULL))) IS TRUE) FROM t0;
+----------------------------------------------------------------------+
| SUM(((t0.c0) = (IF(1122822918, 0.34987436284057793, NULL))) IS TRUE) |
+----------------------------------------------------------------------+
| 0 |
+----------------------------------------------------------------------+
1 row in set (0.00 sec)
How to repeat:
The ZEROFILL attribute and index of a column can affect the results.
DROP TABLE IF EXISTS t0;
DROP TABLE IF EXISTS t1;
CREATE TABLE t0(c0 BIGINT ZEROFILL NOT NULL) ;
CREATE TABLE IF NOT EXISTS t1 LIKE t0;
CREATE INDEX i0 ON t0(c0 ASC) VISIBLE;
INSERT IGNORE INTO t0(c0) VALUES(-202718286);
SELECT t0.c0 FROM t0 WHERE (t0.c0) = (IF(1122822918, 0.34987436284057793, NULL));
SELECT SUM(((t0.c0) = (IF(1122822918, 0.34987436284057793, NULL))) IS TRUE) FROM t0;
