diff options
Diffstat (limited to 'mysql-test/main/join_outer.result')
| -rw-r--r-- | mysql-test/main/join_outer.result | 16 |
1 files changed, 8 insertions, 8 deletions
diff --git a/mysql-test/main/join_outer.result b/mysql-test/main/join_outer.result index 522b668e07b..b79070f50fc 100644 --- a/mysql-test/main/join_outer.result +++ b/mysql-test/main/join_outer.result @@ -1238,14 +1238,14 @@ id a show status like 'Handler_read%'; Variable_name Value Handler_read_first 0 -Handler_read_key 5 +Handler_read_key 0 Handler_read_last 0 Handler_read_next 0 Handler_read_prev 0 Handler_read_retry 0 Handler_read_rnd 0 Handler_read_rnd_deleted 0 -Handler_read_rnd_next 6 +Handler_read_rnd_next 0 DROP TABLE t1,t2; CREATE TABLE t1 (c int PRIMARY KEY, e int NOT NULL); INSERT INTO t1 VALUES (1,0), (2,1); @@ -1803,14 +1803,14 @@ sum(t3.b) show status like "handler_read%"; Variable_name Value Handler_read_first 0 -Handler_read_key 13 +Handler_read_key 0 Handler_read_last 0 -Handler_read_next 5 +Handler_read_next 0 Handler_read_prev 0 Handler_read_retry 0 Handler_read_rnd 0 Handler_read_rnd_deleted 0 -Handler_read_rnd_next 1048581 +Handler_read_rnd_next 0 flush status; select sum(t3.b) from t2 left join t3 on t3.a=t2.a and t2.a <> 10; sum(t3.b) @@ -1818,14 +1818,14 @@ sum(t3.b) show status like "handler_read%"; Variable_name Value Handler_read_first 0 -Handler_read_key 7 +Handler_read_key 0 Handler_read_last 0 -Handler_read_next 5 +Handler_read_next 0 Handler_read_prev 0 Handler_read_retry 0 Handler_read_rnd 0 Handler_read_rnd_deleted 0 -Handler_read_rnd_next 1048581 +Handler_read_rnd_next 0 drop table t1,t2,t3; # # Bug#57688 Assertion `!table || (!table->write_set || bitmap_is_set(table->write_set, field |