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/cte_nonrecursive.test | |
parent | d5a2bc6a0f24f2a9ec73a0d18bb7e6fba3496bed (diff) | |
parent | 867617a97684cdf2c8df326d9a986c2cae779796 (diff) | |
download | mariadb-git-cc492bfd4ff2d15cc5803a7d80f1559ceeb003c1.tar.gz |
Merge 10.2 into 10.3
Diffstat (limited to 'mysql-test/main/cte_nonrecursive.test')
-rw-r--r-- | mysql-test/main/cte_nonrecursive.test | 12 |
1 files changed, 12 insertions, 0 deletions
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; |