Debian Codegraph @

mysql-test/suite/optimizer_unfixed_bugs/t/bug40992.test

raw
1 --echo #
2 --echo # Bug#40992 - InnoDB: Crash when engine_condition_pushdown is on
3 --echo #
4
5 --source include/have_debug.inc
6 --source include/have_innodb.inc
7
8 SET @saved_dbug = @@SESSION.debug_dbug;
9 # Crash requires that we enable Index Condition Pushdown in InnoDB
10 set session debug_dbug="+d,optimizer_innodb_icp";
11
12 CREATE TABLE t (
13 dummy INT PRIMARY KEY,
14 a INT UNIQUE,
15 b int
16 ) ENGINE=InnoDB;
17
18 INSERT INTO t VALUES (1,1,1),(3,3,3),(5,5,5);
19
20 SELECT * FROM t WHERE a > 2 FOR UPDATE;
21
22 DROP TABLE t;
23 SET debug_dbug= @saved_dbug;