diff options
| -rw-r--r-- | mysql-test/r/null_key.result | 17 | ||||
| -rw-r--r-- | mysql-test/t/null_key.test | 6 |
2 files changed, 6 insertions, 17 deletions
diff --git a/mysql-test/r/null_key.result b/mysql-test/r/null_key.result index 89f9663f527..516894edb88 100644 --- a/mysql-test/r/null_key.result +++ b/mysql-test/r/null_key.result @@ -404,14 +404,7 @@ id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE t1 ALL NULL NULL NULL NULL 4 1 SIMPLE t2 ref idx idx 5 test.t1.a 1 1 SIMPLE t3 ref idx idx 5 test.t2.b 1 Using index -SHOW STATUS LIKE "handler_read%"; -Variable_name Value -Handler_read_first 25 -Handler_read_key 63 -Handler_read_next 25979 -Handler_read_prev 0 -Handler_read_rnd 0 -Handler_read_rnd_next 147 +FLUSH STATUS ; SELECT SQL_CALC_FOUND_ROWS * FROM t1 LEFT JOIN t2 ON t1.a=t2.a LEFT JOIN t3 ON t2.b=t3.b; a a b b @@ -421,12 +414,12 @@ a a b b 4 NULL NULL NULL SHOW STATUS LIKE "handler_read%"; Variable_name Value -Handler_read_first 25 -Handler_read_key 69 -Handler_read_next 25981 +Handler_read_first 0 +Handler_read_key 6 +Handler_read_next 2 Handler_read_prev 0 Handler_read_rnd 0 -Handler_read_rnd_next 152 +Handler_read_rnd_next 5 SELECT FOUND_ROWS(); FOUND_ROWS() 4 diff --git a/mysql-test/t/null_key.test b/mysql-test/t/null_key.test index 228b00d528a..bd37a031745 100644 --- a/mysql-test/t/null_key.test +++ b/mysql-test/t/null_key.test @@ -230,14 +230,10 @@ SELECT COUNT(*) FROM t3; EXPLAIN SELECT SQL_CALC_FOUND_ROWS * FROM t1 LEFT JOIN t2 ON t1.a=t2.a LEFT JOIN t3 ON t2.b=t3.b; -SHOW STATUS LIKE "handler_read%"; - - +FLUSH STATUS ; SELECT SQL_CALC_FOUND_ROWS * FROM t1 LEFT JOIN t2 ON t1.a=t2.a LEFT JOIN t3 ON t2.b=t3.b; - SHOW STATUS LIKE "handler_read%"; - SELECT FOUND_ROWS(); DROP TABLE t1,t2,t3,t4; |