diff options
Diffstat (limited to 'mysql-test/main/view.result')
| -rw-r--r-- | mysql-test/main/view.result | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/mysql-test/main/view.result b/mysql-test/main/view.result index 12214ca8bc8..b7a4d84a992 100644 --- a/mysql-test/main/view.result +++ b/mysql-test/main/view.result @@ -2948,10 +2948,10 @@ CREATE TABLE t1 (s1 int); CREATE VIEW v1 AS SELECT * FROM t1; EXPLAIN SELECT * FROM t1; id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 system NULL NULL NULL NULL 0 Const row not found +1 SIMPLE NULL NULL NULL NULL NULL NULL NULL no matching row in const table EXPLAIN SELECT * FROM v1; id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 system NULL NULL NULL NULL 0 Const row not found +1 SIMPLE NULL NULL NULL NULL NULL NULL NULL no matching row in const table INSERT INTO t1 VALUES (1), (3), (2); EXPLAIN SELECT * FROM t1 t WHERE t.s1+1 < (SELECT MAX(t1.s1) FROM t1); id select_type table type possible_keys key key_len ref rows Extra @@ -5735,7 +5735,7 @@ LEFT JOIN v60 ON t36.f36 = v60.f60 ; id select_type table type possible_keys key key_len ref rows Extra -1 PRIMARY NULL NULL NULL NULL NULL NULL NULL Impossible WHERE noticed after reading const tables +1 PRIMARY NULL NULL NULL NULL NULL NULL NULL no matching row in const table 2 SUBQUERY NULL NULL NULL NULL NULL NULL NULL no matching row in const table drop table t0, t1, t2, t3, t4, t5, t6, t7, t8, t9, t10, t11, t12, t13, t14, t15, t16, t17, t18, |