Debian Codegraph @

mysql-test/suite/optimizer_unfixed_bugs/r/bug43249.result

raw
1 SET @saved_dbug = @@SESSION.debug_dbug;
2 set session debug_dbug="+d,optimizer_innodb_icp";
3 CREATE TABLE t1(c1 TIME NOT NULL, c2 TIME NULL, c3 DATE, PRIMARY
4 KEY(c1), UNIQUE INDEX(c2)) engine=innodb;
5 INSERT INTO t1 VALUES('8:29:45',NULL,'2009-02-01');
6 SELECT * FROM t1 WHERE c2 <=> NULL ORDER BY c2 LIMIT 2;
7 c1 c2 c3
8 08:29:45 NULL 2009-02-01
9 SELECT * FROM t1 WHERE c2 <=> NULL ORDER BY c2 LIMIT 2;
10 c1 c2 c3
11 08:29:45 NULL 2009-02-01
12 drop table `t1`;
13 SET debug_dbug= @saved_dbug;