diff options
Diffstat (limited to 'mysql-test/r/key_diff.result')
| -rw-r--r-- | mysql-test/r/key_diff.result | 13 |
1 files changed, 13 insertions, 0 deletions
diff --git a/mysql-test/r/key_diff.result b/mysql-test/r/key_diff.result index ab5b9bcc0e7..0886850f38a 100644 --- a/mysql-test/r/key_diff.result +++ b/mysql-test/r/key_diff.result @@ -1,3 +1,12 @@ +drop table if exists t1; +CREATE TABLE t1 ( +a char(5) NOT NULL, +b char(4) NOT NULL, +KEY (a), +KEY (b) +); +INSERT INTO t1 VALUES ('A','B'),('b','A'),('C','c'),('D','E'),('a','a'); +select * from t1,t1 as t2; a b a b A B A B b A A B @@ -24,9 +33,11 @@ b A a a C c a a D E a a a a a a +explain select t1.*,t2.* from t1,t1 as t2 where t1.A=t2.B; table type possible_keys key key_len ref rows Extra t1 ALL a NULL NULL NULL 5 t2 ALL b NULL NULL NULL 5 where used +select t1.*,t2.* from t1,t1 as t2 where t1.A=t2.B order by binary t1.a,t2.a; a b a b A B a a A B b A @@ -34,6 +45,8 @@ C c C c a a a a a a b A b A A B +select * from t1 where a='a'; a b A B a a +drop table t1; |