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