diff options
Diffstat (limited to 'mysql-test/r/myisam.result')
| -rw-r--r-- | mysql-test/r/myisam.result | 27 |
1 files changed, 27 insertions, 0 deletions
diff --git a/mysql-test/r/myisam.result b/mysql-test/r/myisam.result index 448c1b37592..efcc610cbd4 100644 --- a/mysql-test/r/myisam.result +++ b/mysql-test/r/myisam.result @@ -48,3 +48,30 @@ Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_par t1 0 PRIMARY 1 a A 5 NULL NULL t1 1 b 1 b A 1 NULL NULL drop table t1; +create table t1 (a int not null, b int not null, c int not null, primary key (a),key(b)) type=myisam; +insert into t1 values (3,3,3),(1,1,1),(2,2,2),(4,4,4); +explain select * from t1 order by a; +table type possible_keys key key_len ref rows Extra +t1 ALL NULL NULL NULL NULL 4 Using filesort +explain select * from t1 order by b; +table type possible_keys key key_len ref rows Extra +t1 ALL NULL NULL NULL NULL 4 Using filesort +explain select * from t1 order by c; +table type possible_keys key key_len ref rows Extra +t1 ALL NULL NULL NULL NULL 4 Using filesort +explain select a from t1 order by a; +table type possible_keys key key_len ref rows Extra +t1 index NULL PRIMARY 4 NULL 4 Using index +explain select b from t1 order by b; +table type possible_keys key key_len ref rows Extra +t1 index NULL b 4 NULL 4 Using index +explain select a,b from t1 order by b; +table type possible_keys key key_len ref rows Extra +t1 ALL NULL NULL NULL NULL 4 Using filesort +explain select a,b from t1; +table type possible_keys key key_len ref rows Extra +t1 ALL NULL NULL NULL NULL 4 +explain select a,b,c from t1; +table type possible_keys key key_len ref rows Extra +t1 ALL NULL NULL NULL NULL 4 +drop table t1; |