Debian Codegraph @

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

raw
1 #
2 # Bug#40992 - InnoDB: Crash when engine_condition_pushdown is on
3 #
4 SET @saved_dbug = @@SESSION.debug_dbug;
5 set session debug_dbug="+d,optimizer_innodb_icp";
6 CREATE TABLE t (
7 dummy INT PRIMARY KEY,
8 a INT UNIQUE,
9 b int
10 ) ENGINE=InnoDB;
11 INSERT INTO t VALUES (1,1,1),(3,3,3),(5,5,5);
12 SELECT * FROM t WHERE a > 2 FOR UPDATE;
13 dummy a b
14 3 3 3
15 5 5 5
16 DROP TABLE t;
17 SET debug_dbug= @saved_dbug;