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; |