[Commits] Rev 2877: Testcase backport: Bug#43249 in file:///home/psergey/dev2/5.3-fix-subq/

Sergey Petrunya psergey at askmonty.org
Fri Jan 14 13:13:12 EET 2011


At file:///home/psergey/dev2/5.3-fix-subq/

------------------------------------------------------------
revno: 2877
revision-id: psergey at askmonty.org-20110114111311-2nf700zwq2sxrmiq
parent: psergey at askmonty.org-20110114105130-2yj5mvupx3fs1pkb
committer: Sergey Petrunya <psergey at askmonty.org>
branch nick: 5.3-fix-subq
timestamp: Fri 2011-01-14 14:13:11 +0300
message:
  Testcase backport: Bug#43249
=== modified file 'mysql-test/r/innodb_mrr.result'
--- a/mysql-test/r/innodb_mrr.result	2011-01-13 21:47:03 +0000
+++ b/mysql-test/r/innodb_mrr.result	2011-01-14 11:13:11 +0000
@@ -703,3 +703,15 @@
 MS	United States of Ame
 JA	USA
 DROP TABLE t1,t2;
+#
+# Testcase backport: Bug#43249
+#
+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/t/innodb_mrr.test'
--- a/mysql-test/t/innodb_mrr.test	2011-01-13 21:47:03 +0000
+++ b/mysql-test/t/innodb_mrr.test	2011-01-14 11:13:11 +0000
@@ -401,3 +401,14 @@
 
 DROP TABLE t1,t2;
 
+--echo #
+--echo # Testcase backport: Bug#43249
+--echo #
+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`;
+



More information about the commits mailing list