Description:
From my understanding, the first query below should return one row of data, but the result is empty.
mysql> SELECT TRUE FROM t2 WHERE ((FALSE) > (t2.c2)) LIKE CASE WHEN TRUE THEN TRUE ELSE 0.6094693825270517 END;
Empty set (0.00 sec)
mysql> SELECT (((FALSE)) > (t2.c2)) LIKE CASE WHEN TRUE THEN TRUE ELSE 0.6094693825270517 END FROM t2;
+---------------------------------------------------------------------------------+
| (((FALSE)) > (t2.c2)) LIKE CASE WHEN TRUE THEN TRUE ELSE 0.6094693825270517 END |
+---------------------------------------------------------------------------------+
| 1 |
+---------------------------------------------------------------------------------+
1 row in set (0.00 sec)
How to repeat:
DROP TABLE IF EXISTS t2;
CREATE TABLE IF NOT EXISTS t2(c2 LONGTEXT) ;
INSERT INTO t2(c2) VALUES("-401933063");
SELECT (((FALSE)) > (t2.c2)) LIKE CASE WHEN TRUE THEN TRUE ELSE 0.6094693825270517 END FROM t2; -- {1}
SELECT TRUE FROM t2 WHERE ((FALSE) > (t2.c2)) LIKE CASE WHEN TRUE THEN TRUE ELSE 0.6094693825270517 END; -- empty
Description: From my understanding, the first query below should return one row of data, but the result is empty. mysql> SELECT TRUE FROM t2 WHERE ((FALSE) > (t2.c2)) LIKE CASE WHEN TRUE THEN TRUE ELSE 0.6094693825270517 END; Empty set (0.00 sec) mysql> SELECT (((FALSE)) > (t2.c2)) LIKE CASE WHEN TRUE THEN TRUE ELSE 0.6094693825270517 END FROM t2; +---------------------------------------------------------------------------------+ | (((FALSE)) > (t2.c2)) LIKE CASE WHEN TRUE THEN TRUE ELSE 0.6094693825270517 END | +---------------------------------------------------------------------------------+ | 1 | +---------------------------------------------------------------------------------+ 1 row in set (0.00 sec) How to repeat: DROP TABLE IF EXISTS t2; CREATE TABLE IF NOT EXISTS t2(c2 LONGTEXT) ; INSERT INTO t2(c2) VALUES("-401933063"); SELECT (((FALSE)) > (t2.c2)) LIKE CASE WHEN TRUE THEN TRUE ELSE 0.6094693825270517 END FROM t2; -- {1} SELECT TRUE FROM t2 WHERE ((FALSE) > (t2.c2)) LIKE CASE WHEN TRUE THEN TRUE ELSE 0.6094693825270517 END; -- empty