diff options
Diffstat (limited to 'mysql-test/main/derived_view.result')
-rw-r--r-- | mysql-test/main/derived_view.result | 50 |
1 files changed, 25 insertions, 25 deletions
diff --git a/mysql-test/main/derived_view.result b/mysql-test/main/derived_view.result index c73bc43a2a4..db29bbe3da3 100644 --- a/mysql-test/main/derived_view.result +++ b/mysql-test/main/derived_view.result @@ -98,7 +98,7 @@ Handler_read_prev 0 Handler_read_retry 0 Handler_read_rnd 0 Handler_read_rnd_deleted 0 -Handler_read_rnd_next 12 +Handler_read_rnd_next 0 for merged views create view v1 as select * from t1; create view v2 as select * from t1 join t2 on f1=f2; @@ -187,7 +187,7 @@ Handler_read_prev 0 Handler_read_retry 0 Handler_read_rnd 0 Handler_read_rnd_deleted 0 -Handler_read_rnd_next 12 +Handler_read_rnd_next 0 for materialized derived tables explain for simple derived explain extended select * from (select * from t1 group by f1) tt; @@ -250,14 +250,14 @@ f1 f11 f2 f22 show status like 'Handler_read%'; Variable_name Value Handler_read_first 0 -Handler_read_key 11 +Handler_read_key 0 Handler_read_last 0 -Handler_read_next 3 +Handler_read_next 0 Handler_read_prev 0 Handler_read_retry 0 -Handler_read_rnd 11 +Handler_read_rnd 0 Handler_read_rnd_deleted 0 -Handler_read_rnd_next 36 +Handler_read_rnd_next 0 for materialized views drop view v1,v2,v3; create view v1 as select * from t1 group by f1; @@ -326,14 +326,14 @@ f1 f11 f1 f11 f1 f11 show status like 'Handler_read%'; Variable_name Value Handler_read_first 0 -Handler_read_key 22 +Handler_read_key 0 Handler_read_last 0 -Handler_read_next 22 +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 60 +Handler_read_rnd_next 0 explain showing late materialization flush status; explain select * from t1 join v2 on f1=f2; @@ -361,14 +361,14 @@ f1 f11 f2 f22 show status like 'Handler_read%'; Variable_name Value Handler_read_first 0 -Handler_read_key 11 +Handler_read_key 0 Handler_read_last 0 -Handler_read_next 3 +Handler_read_next 0 Handler_read_prev 0 Handler_read_retry 0 -Handler_read_rnd 11 +Handler_read_rnd 0 Handler_read_rnd_deleted 0 -Handler_read_rnd_next 36 +Handler_read_rnd_next 0 explain extended select * from v1 join v4 on f1=f2; id select_type table type possible_keys key key_len ref rows filtered Extra 1 PRIMARY t2 ALL NULL NULL NULL NULL 11 100.00 Using where @@ -646,14 +646,14 @@ f1 f11 f1 f11 show status like 'Handler_read%'; Variable_name Value Handler_read_first 0 -Handler_read_key 2 +Handler_read_key 0 Handler_read_last 0 -Handler_read_next 2 +Handler_read_next 0 Handler_read_prev 0 Handler_read_retry 0 -Handler_read_rnd 4 +Handler_read_rnd 0 Handler_read_rnd_deleted 0 -Handler_read_rnd_next 33 +Handler_read_rnd_next 0 flush status; merged in merged derived join merged in merged derived explain extended select * from @@ -2963,14 +2963,14 @@ pla_id mat_id show status like '%Handler_read%'; Variable_name Value Handler_read_first 0 -Handler_read_key 21 +Handler_read_key 0 Handler_read_last 0 -Handler_read_next 6 +Handler_read_next 0 Handler_read_prev 0 Handler_read_retry 0 -Handler_read_rnd 6 +Handler_read_rnd 0 Handler_read_rnd_deleted 0 -Handler_read_rnd_next 27 +Handler_read_rnd_next 0 flush status; execute stmt1; pla_id mat_id @@ -2983,14 +2983,14 @@ pla_id mat_id show status like '%Handler_read%'; Variable_name Value Handler_read_first 0 -Handler_read_key 21 +Handler_read_key 0 Handler_read_last 0 -Handler_read_next 6 +Handler_read_next 0 Handler_read_prev 0 Handler_read_retry 0 -Handler_read_rnd 6 +Handler_read_rnd 0 Handler_read_rnd_deleted 0 -Handler_read_rnd_next 27 +Handler_read_rnd_next 0 deallocate prepare stmt1; drop table t1,t2; # |