MySQL Lists are EOL. Please join:

List:Commits« Previous MessageNext Message »
From:Vladislav Vaintroub Date:April 6 2009 11:49am
Subject:bzr commit into mysql-6.0-falcon-team branch (vvaintroub:3098)
Bug#42405
View as plain text  
#At file:///G:/bzr/mysql-6.0-falcon-team/ based on revid:vvaintroub@stripped

 3098 Vladislav Vaintroub	2009-04-06
      Bug#42405 Missing/Wrong rows on Falcon's ORDER BY ..LIMIT with range access on pk/index
      
      The bug is no more reproducible. It is not known what exact change fixed the test.

    added:
      mysql-test/suite/falcon/r/falcon_bug_42405.result
      mysql-test/suite/falcon/t/falcon_bug_42405.test
=== added file 'mysql-test/suite/falcon/r/falcon_bug_42405.result'
--- a/mysql-test/suite/falcon/r/falcon_bug_42405.result	1970-01-01 00:00:00 +0000
+++ b/mysql-test/suite/falcon/r/falcon_bug_42405.result	2009-04-06 11:49:05 +0000
@@ -0,0 +1,34 @@
+*** Bug #42405 ***
+SET @@storage_engine = 'Falcon';
+DROP TABLE IF EXISTS t2;
+CREATE TABLE t2(c1 TINYINT UNSIGNED NOT NULL, 
+c2 TINYINT NULL, 
+c3 SMALLINT, 
+c4 MEDIUMINT, 
+c5 INT,
+c6 INTEGER,
+c7 BIGINT,
+PRIMARY KEY(c1,c6));
+INSERT INTO t2 VALUES
+(101,102,103,104,105,106,107),
+(108,109,110,111,112,113,114),
+(115,116,117,118,119,120,121),
+(122,123,124,125,126,127,128);
+SELECT * FROM t2 WHERE c1 <> 108 ORDER BY c1,c6 LIMIT 2;
+c1	c2	c3	c4	c5	c6	c7
+101	102	103	104	105	106	107
+115	116	117	118	119	120	121
+SELECT * FROM t2 WHERE c1 <> 115 ORDER BY c1,c6 LIMIT 2;
+c1	c2	c3	c4	c5	c6	c7
+101	102	103	104	105	106	107
+108	109	110	111	112	113	114
+SELECT * FROM t2 WHERE c1 IN (101,115) ORDER BY c1,c6 LIMIT 2;
+c1	c2	c3	c4	c5	c6	c7
+101	102	103	104	105	106	107
+115	116	117	118	119	120	121
+SELECT * FROM t2 WHERE c1 IN (101, 115, 122) ORDER BY c1,c6 LIMIT 5;
+c1	c2	c3	c4	c5	c6	c7
+101	102	103	104	105	106	107
+115	116	117	118	119	120	121
+122	123	124	125	126	127	128
+DROP TABLE t2;

=== added file 'mysql-test/suite/falcon/t/falcon_bug_42405.test'
--- a/mysql-test/suite/falcon/t/falcon_bug_42405.test	1970-01-01 00:00:00 +0000
+++ b/mysql-test/suite/falcon/t/falcon_bug_42405.test	2009-04-06 11:49:05 +0000
@@ -0,0 +1,46 @@
+--source include/have_falcon.inc
+
+#
+# Bug #42405: Missing/Wrong rows on Falcon's ORDER BY ..LIMIT with range access on pk/index
+#
+--echo *** Bug #42405 ***
+
+# ----------------------------------------------------- #
+# --- Initialisation                                --- #
+# ----------------------------------------------------- #
+let $engine = 'Falcon';
+eval SET @@storage_engine = $engine;
+
+--disable_warnings
+DROP TABLE IF EXISTS t2;
+--enable_warnings
+
+CREATE TABLE t2(c1 TINYINT UNSIGNED NOT NULL, 
+c2 TINYINT NULL, 
+c3 SMALLINT, 
+c4 MEDIUMINT, 
+c5 INT,
+c6 INTEGER,
+c7 BIGINT,
+PRIMARY KEY(c1,c6));
+
+INSERT INTO t2 VALUES
+(101,102,103,104,105,106,107),
+(108,109,110,111,112,113,114),
+(115,116,117,118,119,120,121),
+(122,123,124,125,126,127,128);
+
+
+SELECT * FROM t2 WHERE c1 <> 108 ORDER BY c1,c6 LIMIT 2;
+
+SELECT * FROM t2 WHERE c1 <> 115 ORDER BY c1,c6 LIMIT 2;
+
+SELECT * FROM t2 WHERE c1 IN (101,115) ORDER BY c1,c6 LIMIT 2;
+
+SELECT * FROM t2 WHERE c1 IN (101, 115, 122) ORDER BY c1,c6 LIMIT 5;
+
+
+# ----------------------------------------------------- #
+# --- Final cleanup                                 --- #
+# ----------------------------------------------------- #
+DROP TABLE t2;


Attachment: [text/bzr-bundle] bzr/vvaintroub@mysql.com-20090406114905-nmvmlz0jr6ky1bss.bundle
Thread
bzr commit into mysql-6.0-falcon-team branch (vvaintroub:3098)Bug#42405Vladislav Vaintroub6 Apr