From 7166069537a4e18d4c0848655fcbc0c8ee568fd4 Mon Sep 17 00:00:00 2001 From: Oleksandr Byelkin Date: Thu, 25 Feb 2016 14:55:04 +0100 Subject: MDEV-3944: Allow derived tables in VIEWS --- mysql-test/r/cte_nonrecursive.result | 15 ++++++--------- 1 file changed, 6 insertions(+), 9 deletions(-) (limited to 'mysql-test/r/cte_nonrecursive.result') 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 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 ALL NULL NULL NULL NULL 8 -2 DERIVED t2 ALL NULL NULL NULL NULL 4 Using where -2 DERIVED ref key0 key0 5 test.t2.c 2 +1 PRIMARY t2 ALL NULL NULL NULL NULL 4 Using where +1 PRIMARY 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 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 -- cgit v1.2.1