diff options
| author | Marko Mäkelä <marko.makela@mariadb.com> | 2019-04-07 11:49:50 +0300 |
|---|---|---|
| committer | Marko Mäkelä <marko.makela@mariadb.com> | 2019-04-07 11:49:50 +0300 |
| commit | cc492bfd4ff2d15cc5803a7d80f1559ceeb003c1 (patch) | |
| tree | e5d3abbe5551d4f05a59cfcc0d629f8d4f50e98f /mysql-test/main | |
| parent | d5a2bc6a0f24f2a9ec73a0d18bb7e6fba3496bed (diff) | |
| parent | 867617a97684cdf2c8df326d9a986c2cae779796 (diff) | |
| download | mariadb-git-cc492bfd4ff2d15cc5803a7d80f1559ceeb003c1.tar.gz | |
Merge 10.2 into 10.3
Diffstat (limited to 'mysql-test/main')
| -rw-r--r-- | mysql-test/main/cte_nonrecursive.result | 14 | ||||
| -rw-r--r-- | mysql-test/main/cte_nonrecursive.test | 12 |
2 files changed, 26 insertions, 0 deletions
diff --git a/mysql-test/main/cte_nonrecursive.result b/mysql-test/main/cte_nonrecursive.result index 9bce4f0a9bd..b846ec2d8ac 100644 --- a/mysql-test/main/cte_nonrecursive.result +++ b/mysql-test/main/cte_nonrecursive.result @@ -1659,3 +1659,17 @@ a 2 drop view v1; drop table t1,t2; +# +# MDEV-19112: CTE usage when information_schema is set as default db +# +with t as (select 1 as t ) select * from t; +t +1 +use information_schema; +with t as (select 1 as t) select * from t; +t +1 +with columns as (select 1 as t) select * from columns; +t +1 +use test; diff --git a/mysql-test/main/cte_nonrecursive.test b/mysql-test/main/cte_nonrecursive.test index 920c27a70f9..c0c5c22bed0 100644 --- a/mysql-test/main/cte_nonrecursive.test +++ b/mysql-test/main/cte_nonrecursive.test @@ -1168,3 +1168,15 @@ select * from v1; drop view v1; drop table t1,t2; + +--echo # +--echo # MDEV-19112: CTE usage when information_schema is set as default db +--echo # + +with t as (select 1 as t ) select * from t; + +use information_schema; +with t as (select 1 as t) select * from t; +with columns as (select 1 as t) select * from columns; + +use test; |