Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
11.0.3
-
None
-
Ubuntu 22.04LTS
Description
The following two cases return different results for the same query.
I construct case 2 by adding a not null constraint on case 1, which is expected to not change the query result.
Case 1:
DROP TABLE IF EXISTS t1; |
CREATE TABLE t1 (c0 double, c2 tinyint(1)) ENGINE=MyISAM; |
INSERT INTO t1 VALUES (-1, null); |
SELECT 1 HAVING ((1, NULL) NOT IN (SELECT `c2`, `c0` FROM t1)); -- {} |
Case 2:
DROP TABLE IF EXISTS t1; |
CREATE TABLE t1 (c0 double not null , c2 tinyint(1)) ENGINE=MyISAM; |
INSERT INTO t1 VALUES (-1, null); |
SELECT 1 HAVING ((1, NULL) NOT IN (SELECT `c2`, `c0` FROM t1)); -- {1} |