diff options
Diffstat (limited to 'mysql-test/r/myisam.result')
| -rw-r--r-- | mysql-test/r/myisam.result | 12 |
1 files changed, 6 insertions, 6 deletions
diff --git a/mysql-test/r/myisam.result b/mysql-test/r/myisam.result index 5dc4803137e..d210048a5c7 100644 --- a/mysql-test/r/myisam.result +++ b/mysql-test/r/myisam.result @@ -474,13 +474,13 @@ select sql_big_result distinct t1.a from t1,t2; a 1 explain select sql_big_result distinct t1.a from t1,t2 order by t2.a; -table type possible_keys key key_len ref rows Extra -t1 system NULL NULL NULL NULL 1 Using temporary -t2 index NULL PRIMARY 4 NULL 2 Using index; Distinct +id select_type table type possible_keys key key_len ref rows Extra +1 SIMPLE t1 system NULL NULL NULL NULL 1 Using temporary +1 SIMPLE t2 index NULL PRIMARY 4 NULL 2 Using index; Distinct explain select distinct t1.a from t1,t2 order by t2.a; -table type possible_keys key key_len ref rows Extra -t1 system NULL NULL NULL NULL 1 Using temporary -t2 index NULL PRIMARY 4 NULL 2 Using index; Distinct +id select_type table type possible_keys key key_len ref rows Extra +1 SIMPLE t1 system NULL NULL NULL NULL 1 Using temporary +1 SIMPLE t2 index NULL PRIMARY 4 NULL 2 Using index; Distinct drop table t1,t2; CREATE TABLE t1 (`a` int(11) NOT NULL default '0', `b` int(11) NOT NULL default '0', UNIQUE KEY `a` USING RTREE (`a`,`b`)) ENGINE=MyISAM; ERROR 42000: This version of MySQL doesn't yet support 'RTREE INDEX' |