diff options
| author | Marko Mäkelä <marko.makela@mariadb.com> | 2018-10-18 12:22:48 +0300 |
|---|---|---|
| committer | Marko Mäkelä <marko.makela@mariadb.com> | 2018-10-18 12:22:48 +0300 |
| commit | 9b14e3771753c22480f2aa9c4b4f1df1e4776e6f (patch) | |
| tree | e9b8d4099b04f6840301b693e2942a8d3151f4b1 /mysql-test/main/cte_nonrecursive.result | |
| parent | d3745c385ea8d371a08ae7ec12fcc10aea1b0948 (diff) | |
| parent | 981a81090f1e57ad6b852cc69b353d1718f14a1e (diff) | |
| download | mariadb-git-9b14e3771753c22480f2aa9c4b4f1df1e4776e6f.tar.gz | |
Merge 10.3 into 10.4
Diffstat (limited to 'mysql-test/main/cte_nonrecursive.result')
| -rw-r--r-- | mysql-test/main/cte_nonrecursive.result | 18 |
1 files changed, 18 insertions, 0 deletions
diff --git a/mysql-test/main/cte_nonrecursive.result b/mysql-test/main/cte_nonrecursive.result index 05c47b42fc7..eeae6d02476 100644 --- a/mysql-test/main/cte_nonrecursive.result +++ b/mysql-test/main/cte_nonrecursive.result @@ -1641,3 +1641,21 @@ a b drop procedure p1; drop procedure p2; drop table t1; +# +# MDEV-17107: PS for CREATE OR REPLACE VIEW defined by SELECT with CTEs +# +create table t1(a int); +insert into t1 values (3), (1), (2); +create table t2 (b int); +insert into t2 values (2), (10); +prepare stmt from +"create or replace view v1 as + with t as (select s.a from (select t1.a from t1) s), + r as(select t.a from t2, t where t2.b=t.a) + select a from r;"; +execute stmt; +select * from v1; +a +2 +drop view v1; +drop table t1,t2; |