Description:
index_merge_myisam [ 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/index_merge_myisam.result 2006-09-12 19:38:54.000000000 +0300
--- r/index_merge_myisam.reject 2006-09-15 20:57:04.000000000 +0300
***************
*** 982,987 ****
--- 982,1027 ----
COUNT(*)
1
drop table t1;
+ create table t1
+ (
+ key1 int not null,
+ key2 int not null default 0,
+ key3 int not null default 0
+ );
+ insert into t1(key1) values (1),(2),(3),(4),(5),(6),(7),(8);
+ set @d=8;
+ insert into t1 (key1) select key1+@d from t1;
+ set @d=@d*2;
+ insert into t1 (key1) select key1+@d from t1;
+ set @d=@d*2;
+ insert into t1 (key1) select key1+@d from t1;
+ set @d=@d*2;
+ insert into t1 (key1) select key1+@d from t1;
+ set @d=@d*2;
+ insert into t1 (key1) select key1+@d from t1;
+ set @d=@d*2;
+ insert into t1 (key1) select key1+@d from t1;
+ set @d=@d*2;
+ insert into t1 (key1) select key1+@d from t1;
+ set @d=@d*2;
+ alter table t1 add index i2(key2);
+ alter table t1 add index i3(key3);
+ update t1 set key2=key1,key3=key1;
+ explain select * from t1 where (key3 > 30 and key3<35) or (key2 >32 and key2 < 40);
+ id select_type table type possible_keys key key_len ref rows Extra
+ 1 SIMPLE t1 index_merge i2,i3 i3,i2 4,4 NULL 11 Using sort_union(i3,i2); Using where
+ select * from t1 where (key3 > 30 and key3<35) or (key2 >32 and key2 < 40);
+ key1 key2 key3
+ 31 31 31
+ 32 32 32
+ 33 33 33
+ 34 34 34
+ 35 35 35
+ 36 36 36
+ 37 37 37
+ 38 38 38
+ 39 39 39
+ drop table t1;
#---------------- 2-sweeps read Index merge test 2 -------------------------------
SET SESSION STORAGE_ENGINE = MyISAM;
drop table if exists 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