diff options
Diffstat (limited to 'mysql-test/main/key.result')
-rw-r--r-- | mysql-test/main/key.result | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/mysql-test/main/key.result b/mysql-test/main/key.result index 8cc0ce204cb..005e0ea3350 100644 --- a/mysql-test/main/key.result +++ b/mysql-test/main/key.result @@ -632,19 +632,19 @@ id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE t1 ALL NULL NULL NULL NULL 6 Using temporary; Using filesort SHOW STATUS LIKE 'Last_query_cost'; Variable_name Value -Last_query_cost 8.506592 +Last_query_cost 0.014749 EXPLAIN SELECT a, SUM( b ) FROM t1 USE INDEX( a ) GROUP BY a; id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE t1 ALL NULL NULL NULL NULL 6 Using temporary; Using filesort SHOW STATUS LIKE 'Last_query_cost'; Variable_name Value -Last_query_cost 8.506592 +Last_query_cost 0.014749 EXPLAIN SELECT a, SUM( b ) FROM t1 FORCE INDEX( a ) GROUP BY a; id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE t1 index NULL a 5 NULL 6 SHOW STATUS LIKE 'Last_query_cost'; Variable_name Value -Last_query_cost 8.506592 +Last_query_cost 0.014749 DROP TABLE t1; # # MDEV-21480: Unique key using ref access though eq_ref access can be used |