summaryrefslogtreecommitdiffstats
path: root/mysql-test/suite/optimizer_unfixed_bugs/r/bug40992.result
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/suite/optimizer_unfixed_bugs/r/bug40992.result')
-rw-r--r--mysql-test/suite/optimizer_unfixed_bugs/r/bug40992.result17
1 files changed, 17 insertions, 0 deletions
diff --git a/mysql-test/suite/optimizer_unfixed_bugs/r/bug40992.result b/mysql-test/suite/optimizer_unfixed_bugs/r/bug40992.result
new file mode 100644
index 00000000..59ab7607
--- /dev/null
+++ b/mysql-test/suite/optimizer_unfixed_bugs/r/bug40992.result
@@ -0,0 +1,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;