diff options
| author | Marko Mäkelä <marko.makela@mariadb.com> | 2018-10-17 19:05:59 +0300 |
|---|---|---|
| committer | Marko Mäkelä <marko.makela@mariadb.com> | 2018-10-17 19:37:05 +0300 |
| commit | f454189c606b9ce7c401a3493c9b85c72651e220 (patch) | |
| tree | 14d529b74174aecf0603fde5bcc374ad1652e726 /mysql-test/main/cte_nonrecursive.result | |
| parent | 2fa4ed031ce6cc6370671058ccc3d119b8cb3d91 (diff) | |
| parent | 853a0a4368ec5268aac2e53e862ce4ad975ffd66 (diff) | |
| download | mariadb-git-f454189c606b9ce7c401a3493c9b85c72651e220.tar.gz | |
Merge 10.2 into 10.3
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 4711a540f99..9bce4f0a9bd 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; |