bzr commit into mysql-6.0-codebase-bugfixing branch (olav:3686) Bug#40992

[Olav Sandstaa]

#At file:///home/os136802/mysql/develop/repo/opt-bug40992/ based on revid:jon.hauglid@stripped

 3686 Olav Sandstaa	2009-10-29
      Test case for Bug#40992 InnoDB: Crash when engine_condition_pushdown is on
      
      Converted original test case for Bug#40992 to MTR and simplified the test.
      Adding this test to the optimizer_unfixed_bugs test suite.
     @ mysql-test/suite/optimizer_unfixed_bugs/r/bug40992.result
        Test case for Bug#40992 InnoDB: Crash when engine_condition_pushdown is on
     @ mysql-test/suite/optimizer_unfixed_bugs/t/bug40992.test
        Test case for Bug#40992 InnoDB: Crash when engine_condition_pushdown is on

    added:
      mysql-test/suite/optimizer_unfixed_bugs/r/bug40992.result
      mysql-test/suite/optimizer_unfixed_bugs/t/bug40992.test
=== added file 'mysql-test/suite/optimizer_unfixed_bugs/r/bug40992.result'
--- a/mysql-test/suite/optimizer_unfixed_bugs/r/bug40992.result	1970-01-01 00:00:00 +0000
+++ b/mysql-test/suite/optimizer_unfixed_bugs/r/bug40992.result	2009-10-29 13:02:56 +0000
@@ -0,0 +1,14 @@
+#
+# Bug#40992 - InnoDB: Crash when engine_condition_pushdown is on
+#
+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;

=== added file 'mysql-test/suite/optimizer_unfixed_bugs/t/bug40992.test'
--- a/mysql-test/suite/optimizer_unfixed_bugs/t/bug40992.test	1970-01-01 00:00:00 +0000
+++ b/mysql-test/suite/optimizer_unfixed_bugs/t/bug40992.test	2009-10-29 13:02:56 +0000
@@ -0,0 +1,21 @@
+--echo #
+--echo # Bug#40992 - InnoDB: Crash when engine_condition_pushdown is on
+--echo #
+
+--source include/have_debug.inc
+--source include/have_innodb.inc
+
+# Crash requires that we enable Index Condition Pushdown in InnoDB
+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;
+
+DROP TABLE t;


Attachment: [text/bzr-bundle] bzr/[e-mail]