Description:
innodb_mysql [ fail ]
Errors are (from /usersnfs/istruewing/autopush-76/mysql-5.1/mysql-test/var/log/mysqltest-time) :
mysqltest: Result length mismatch
(the last lines may be the most important ones)
Below are the diffs between actual and expected results:
-------------------------------------------------------
*** r/innodb_mysql.result 2006-09-15 21:37:14.000000000 +0300
--- r/innodb_mysql.reject 2006-09-15 21:55:25.000000000 +0300
***************
*** 271,276 ****
--- 271,295 ----
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE t1 range NULL PRIMARY 5 NULL 3 Using index for group-by; Using temporary
drop table t1;
+ CREATE TABLE t1 (id int(11) NOT NULL PRIMARY KEY, name varchar(20),
+ INDEX (name)) ENGINE=InnoDB;
+ CREATE TABLE t2 (id int(11) NOT NULL PRIMARY KEY, fkey int(11),
+ FOREIGN KEY (fkey) REFERENCES t2(id)) ENGINE=InnoDB;
+ INSERT INTO t1 VALUES (1,'A1'),(2,'A2'),(3,'B');
+ INSERT INTO t2 VALUES (1,1),(2,2),(3,2),(4,3),(5,3);
+ EXPLAIN
+ SELECT COUNT(*) FROM t2 LEFT JOIN t1 ON t2.fkey = t1.id
+ WHERE t1.name LIKE 'A%';
+ id select_type table type possible_keys key key_len ref rows Extra
+ 1 SIMPLE t1 index PRIMARY,name name 23 NULL 3 Using where; Using index
+ 1 SIMPLE t2 ref fkey fkey 5 test.t1.id 1 Using where; Using index
+ EXPLAIN
+ SELECT COUNT(*) FROM t2 LEFT JOIN t1 ON t2.fkey = t1.id
+ WHERE t1.name LIKE 'A%' OR FALSE;
+ id select_type table type possible_keys key key_len ref rows Extra
+ 1 SIMPLE t2 index NULL fkey 5 NULL 5 Using index
+ 1 SIMPLE t1 eq_ref PRIMARY PRIMARY 4 test.t2.fkey 1 Using where
+ DROP TABLE t1,t2;
CREATE TABLE t1 (a int, b int);
insert into t1 values (1,1),(1,2);
CREATE TABLE t2 (primary key (a)) select * from t1;
-------------------------------------------------------
Please follow the instructions outlined at
How to repeat:
Log in on 'production'.
Stay at your home directory to use the local disk.
Do not work on a nfs disk.
bk clone bk-internal:/home/bk/mysql-5.1-engines mysql-5.1-engines
cd mysql-5.1-engines
Pull bk-internal:/home/bk/mysql-5.1
BUILD/compile-pentium-debug-max
make test