blob: 9c30b32e1e52c39c4dcce75c1716a557d6411b63 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
|
#
# Bug#40992 - InnoDB: Crash when engine_condition_pushdown is on
#
set session debug="+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;
|
