summaryrefslogtreecommitdiff
path: root/mysql-test/main/view.result
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/main/view.result')
-rw-r--r--mysql-test/main/view.result8
1 files changed, 4 insertions, 4 deletions
diff --git a/mysql-test/main/view.result b/mysql-test/main/view.result
index 712b8629c09..d14b43687cf 100644
--- a/mysql-test/main/view.result
+++ b/mysql-test/main/view.result
@@ -4215,14 +4215,14 @@ a c
SHOW STATUS LIKE 'Handler_read_%';
Variable_name Value
Handler_read_first 0
-Handler_read_key 1
+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 17
+Handler_read_rnd_next 0
CREATE VIEW v AS SELECT * FROM t2;
EXPLAIN EXTENDED
SELECT t1.a,v.c FROM t1,v WHERE v.pk = t1.a AND v.pk > 8;
@@ -4239,14 +4239,14 @@ a c
SHOW STATUS LIKE 'Handler_read_%';
Variable_name Value
Handler_read_first 0
-Handler_read_key 1
+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 17
+Handler_read_rnd_next 0
DROP VIEW v;
DROP TABLE t1, t2;
#