bzr commit into mysql-6.0-codebase-bugfixing branch (guilhem:3655) Bug#43249

[Guilhem Bichot]

#At file:///home/mysql_src/bzrrepos/mysql-6.0-codebase-bugfixing/ based on revid:guilhem@stripped

 3655 Guilhem Bichot	2009-10-19
      BUG#43249 "Innodb returns zero time for the time column with <=> NULL order by limit"
      is now repeatable, updating its testcase.

    modified:
      mysql-test/suite/optimizer_unfixed_bugs/r/bug43249.result
      mysql-test/suite/optimizer_unfixed_bugs/t/bug43249.test
=== modified file 'mysql-test/suite/optimizer_unfixed_bugs/r/bug43249.result'
--- a/mysql-test/suite/optimizer_unfixed_bugs/r/bug43249.result	2009-10-09 19:45:32 +0000
+++ b/mysql-test/suite/optimizer_unfixed_bugs/r/bug43249.result	2009-10-19 12:20:48 +0000
@@ -1,8 +1,11 @@
-set session debug="+d,optimizer_innodb_icp:+d,optimizer_innodb_ds_mrr";
+set session debug="+d,optimizer_innodb_icp";
 CREATE TABLE t1(c1 TIME NOT NULL, c2 TIME NULL, c3 DATE, PRIMARY
 KEY(c1), UNIQUE INDEX(c2)) engine=innodb;
 INSERT INTO t1 VALUES('8:29:45',NULL,'2009-02-01');
 SELECT * FROM t1 WHERE c2 <=> NULL ORDER BY c2 LIMIT 2;
 c1	c2	c3
 08:29:45	NULL	2009-02-01
+SELECT * FROM t1 WHERE c2 <=> NULL ORDER BY c2 LIMIT 2;
+c1	c2	c3
+08:29:45	NULL	2009-02-01
 drop table `t1`;

=== modified file 'mysql-test/suite/optimizer_unfixed_bugs/t/bug43249.test'
--- a/mysql-test/suite/optimizer_unfixed_bugs/t/bug43249.test	2009-10-09 19:45:32 +0000
+++ b/mysql-test/suite/optimizer_unfixed_bugs/t/bug43249.test	2009-10-19 12:20:48 +0000
@@ -4,13 +4,14 @@
 --source include/have_debug.inc
 --source include/have_innodb.inc
 
-# The problem is that this bug cannot be reproduced: even with
-set session debug="+d,optimizer_innodb_icp:+d,optimizer_innodb_ds_mrr";
-# we don't see the bug report's claim that 0 is returned for c2.
+set session debug="+d,optimizer_innodb_icp";
 
 CREATE TABLE t1(c1 TIME NOT NULL, c2 TIME NULL, c3 DATE, PRIMARY
 KEY(c1), UNIQUE INDEX(c2)) engine=innodb;
 INSERT INTO t1 VALUES('8:29:45',NULL,'2009-02-01');
+# first time, good results:
+SELECT * FROM t1 WHERE c2 <=> NULL ORDER BY c2 LIMIT 2;
+# second time, bad results:
 SELECT * FROM t1 WHERE c2 <=> NULL ORDER BY c2 LIMIT 2;
 
 drop table `t1`;


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