diff options
Diffstat (limited to 'mysql-test/suite/innodb/r/innodb-isolation.result')
-rw-r--r-- | mysql-test/suite/innodb/r/innodb-isolation.result | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/mysql-test/suite/innodb/r/innodb-isolation.result b/mysql-test/suite/innodb/r/innodb-isolation.result index ce9c530ff44..a308f10a8a9 100644 --- a/mysql-test/suite/innodb/r/innodb-isolation.result +++ b/mysql-test/suite/innodb/r/innodb-isolation.result @@ -963,15 +963,15 @@ id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE t1 ALL NULL NULL NULL NULL 12 # EXPLAIN SELECT c1, c2 FROM t1 WHERE c1 > ((SELECT COUNT(*) FROM t1) / 2); id select_type table type possible_keys key key_len ref rows Extra -1 PRIMARY t1 range PRIMARY PRIMARY 4 NULL 8 # +1 PRIMARY t1 index PRIMARY k2 5 NULL 12 # 2 SUBQUERY t1 index NULL k2 5 NULL 12 # EXPLAIN SELECT COUNT(c2) FROM t1 WHERE c1 > ((SELECT COUNT(*) FROM t1) / 2); id select_type table type possible_keys key key_len ref rows Extra -1 PRIMARY t1 range PRIMARY PRIMARY 4 NULL 8 # +1 PRIMARY t1 index PRIMARY k2 5 NULL 12 # 2 SUBQUERY t1 index NULL k2 5 NULL 12 # EXPLAIN SELECT COUNT(*) FROM t1 WHERE c1 > (SELECT AVG(c1) FROM t1); id select_type table type possible_keys key key_len ref rows Extra -1 PRIMARY t1 range PRIMARY PRIMARY 4 NULL 7 # +1 PRIMARY t1 index PRIMARY k2 5 NULL 12 # 2 SUBQUERY t1 index NULL k2 5 NULL 12 # # # Make all indexes in t2 obsolete to the active repeatable read transaction |