summaryrefslogtreecommitdiff
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.result15
1 files changed, 15 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 00000000000..9c30b32e1e5
--- /dev/null
+++ b/mysql-test/suite/optimizer_unfixed_bugs/r/bug40992.result
@@ -0,0 +1,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;