diff options
| author | unknown <igor@rurik.mysql.com> | 2005-07-28 17:53:51 -0700 |
|---|---|---|
| committer | unknown <igor@rurik.mysql.com> | 2005-07-28 17:53:51 -0700 |
| commit | 0ad1836d23d67e13c88b2c45d253844303503cc0 (patch) | |
| tree | 07e4e8d57aebc9e6c6520599676596d5f07c3417 /mysql-test | |
| parent | a54ddda4c826a4142f9fb779a58577528f525d73 (diff) | |
| download | mariadb-git-0ad1836d23d67e13c88b2c45d253844303503cc0.tar.gz | |
null_key.test, null_key.result:
Made the test case for bug #12144 independent on other tests.
mysql-test/r/null_key.result:
Made the test case for bug #12144 independent on other tests.
mysql-test/t/null_key.test:
Made the test case for bug #12144 independent on other tests.
Diffstat (limited to 'mysql-test')
| -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; |