diff options
author | Oleksandr Byelkin <sanja@mariadb.com> | 2016-02-25 14:55:04 +0100 |
---|---|---|
committer | Oleksandr Byelkin <sanja@mariadb.com> | 2016-05-28 14:44:21 +0200 |
commit | 7166069537a4e18d4c0848655fcbc0c8ee568fd4 (patch) | |
tree | d07e24b3ce97d2b70583f3273eb1dfc4f438936e /mysql-test/r/cte_nonrecursive.result | |
parent | 1f89ea8ea049909228c441d125a2b13348ec56af (diff) | |
download | mariadb-git-7166069537a4e18d4c0848655fcbc0c8ee568fd4.tar.gz |
MDEV-3944: Allow derived tables in VIEWS
Diffstat (limited to 'mysql-test/r/cte_nonrecursive.result')
-rw-r--r-- | mysql-test/r/cte_nonrecursive.result | 15 |
1 files changed, 6 insertions, 9 deletions
diff --git a/mysql-test/r/cte_nonrecursive.result b/mysql-test/r/cte_nonrecursive.result index c1f2739bd97..dbfcf4ed7c9 100644 --- a/mysql-test/r/cte_nonrecursive.result +++ b/mysql-test/r/cte_nonrecursive.result @@ -543,9 +543,8 @@ c a explain select * from v1; id select_type table type possible_keys key key_len ref rows Extra -1 PRIMARY <derived2> ALL NULL NULL NULL NULL 32 -2 DERIVED t2 ALL NULL NULL NULL NULL 4 -2 DERIVED t1 ALL NULL NULL NULL NULL 8 Using where; Using join buffer (flat, BNL join) +1 SIMPLE t2 ALL NULL NULL NULL NULL 4 +1 SIMPLE t1 ALL NULL NULL NULL NULL 8 Using where; Using join buffer (flat, BNL join) # with claused in the specification of a materialized view create view v2 as with t as (select a, count(*) from t1 where b >= 'c' group by a) @@ -560,9 +559,8 @@ c a count(*) explain select * from v2; id select_type table type possible_keys key key_len ref rows Extra -1 PRIMARY <derived2> ALL NULL NULL NULL NULL 8 -2 DERIVED t2 ALL NULL NULL NULL NULL 4 Using where -2 DERIVED <derived3> ref key0 key0 5 test.t2.c 2 +1 PRIMARY t2 ALL NULL NULL NULL NULL 4 Using where +1 PRIMARY <derived3> ref key0 key0 5 test.t2.c 2 3 SUBQUERY t1 ALL NULL NULL NULL NULL 8 Using where; Using temporary; Using filesort # with clause in the specification of a view that whose definition # table alias for a with table @@ -593,9 +591,8 @@ c d explain select * from v4; id select_type table type possible_keys key key_len ref rows Extra -1 PRIMARY <derived2> ALL NULL NULL NULL NULL 64 -2 DERIVED t1 ALL NULL NULL NULL NULL 8 Using where -2 DERIVED t1 ALL NULL NULL NULL NULL 8 Using where; Using join buffer (flat, BNL join) +1 SIMPLE t1 ALL NULL NULL NULL NULL 8 Using where +1 SIMPLE t1 ALL NULL NULL NULL NULL 8 Using where; Using join buffer (flat, BNL join) drop view v1,v2,v3,v4; # currently any views containing with clause are not updatable create view v1(a) as |