1# 2# Check on condition on different length keys. 3 4--disable_warnings 5drop table if exists t1; 6--enable_warnings 7 8CREATE TABLE t1 ( 9 a char(5) NOT NULL, 10 b char(4) NOT NULL, 11 KEY (a), 12 KEY (b) 13); 14 15INSERT INTO t1 VALUES ('A','B'),('b','A'),('C','c'),('D','E'),('a','a'); 16 17select * from t1,t1 as t2; 18explain select t1.*,t2.* from t1,t1 as t2 where t1.A=t2.B; 19#select t1.*,t2.* from t1,t1 as t2 where t1.A=t2.B; 20select t1.*,t2.* from t1,t1 as t2 where t1.A=t2.B order by binary t1.a,t2.a; 21select * from t1 where a='a'; 22drop table t1; 23 24# End of 4.1 tests 25