diff options
| author | igor@rurik.mysql.com <> | 2005-07-28 17:53:51 -0700 |
|---|---|---|
| committer | igor@rurik.mysql.com <> | 2005-07-28 17:53:51 -0700 |
| commit | f503c4152de0b45d6780d1c669988810055c0fa9 (patch) | |
| tree | 07e4e8d57aebc9e6c6520599676596d5f07c3417 /mysql-test/r/null_key.result | |
| parent | dbec0c6e95458ab063f1aaec577ef2d962355567 (diff) | |
| download | mariadb-git-f503c4152de0b45d6780d1c669988810055c0fa9.tar.gz | |
null_key.test, null_key.result:
Made the test case for bug #12144 independent on other tests.
Diffstat (limited to 'mysql-test/r/null_key.result')
| -rw-r--r-- | mysql-test/r/null_key.result | 17 |
1 files changed, 5 insertions, 12 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 |