diff options
Diffstat (limited to 'mysql-test/r/create.result')
| -rw-r--r-- | mysql-test/r/create.result | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/mysql-test/r/create.result b/mysql-test/r/create.result index f9a3ef487f0..41a977695a6 100644 --- a/mysql-test/r/create.result +++ b/mysql-test/r/create.result @@ -62,8 +62,8 @@ create table t1 (a int auto_increment not null primary key, B CHAR(20)); insert into t1 (b) values ("hello"),("my"),("world"); create table t2 (key (b)) select * from t1; explain select * from t2 where b="world"; -table type possible_keys key key_len ref rows Extra -t2 ref B B 21 const 1 where used +id select_type table type possible_keys key key_len ref rows Extra +1 FIRST t2 ref B B 21 const 1 where used select * from t2 where b="world"; a B 3 world |