diff options
Diffstat (limited to 'mysql-test/main/invisible_field_debug.result')
| -rw-r--r-- | mysql-test/main/invisible_field_debug.result | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/mysql-test/main/invisible_field_debug.result b/mysql-test/main/invisible_field_debug.result index 344a0b86..8cc1ee4d 100644 --- a/mysql-test/main/invisible_field_debug.result +++ b/mysql-test/main/invisible_field_debug.result @@ -346,7 +346,7 @@ invisible a b 9 7 7 explain select * from t1 where invisible =9; id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 ALL invisible NULL NULL NULL 7 Using where +1 SIMPLE t1 ref invisible invisible 5 const 7 alter table t1 add x int default 3; select invisible, a ,b from t1; invisible a b @@ -368,11 +368,11 @@ drop index invisible on t1; ERROR 42000: Can't DROP INDEX `invisible`; check that it exists explain select * from t1 where invisible =9; id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 ALL invisible NULL NULL NULL 7 Using where +1 SIMPLE t1 ref invisible invisible 5 const 7 create index invisible on t1(c); explain select * from t1 where invisible =9; id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 ALL invisible_2 NULL NULL NULL 7 Using where +1 SIMPLE t1 ref invisible_2 invisible_2 5 const 7 show indexes in t1; Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_comment Ignored t1 1 b 1 b A NULL NULL NULL YES BTREE NO |