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