summaryrefslogtreecommitdiff
path: root/mysql-test/main/cte_nonrecursive.result
diff options
context:
space:
mode:
authorMarko Mäkelä <marko.makela@mariadb.com>2019-04-07 11:49:50 +0300
committerMarko Mäkelä <marko.makela@mariadb.com>2019-04-07 11:49:50 +0300
commitcc492bfd4ff2d15cc5803a7d80f1559ceeb003c1 (patch)
treee5d3abbe5551d4f05a59cfcc0d629f8d4f50e98f /mysql-test/main/cte_nonrecursive.result
parentd5a2bc6a0f24f2a9ec73a0d18bb7e6fba3496bed (diff)
parent867617a97684cdf2c8df326d9a986c2cae779796 (diff)
downloadmariadb-git-cc492bfd4ff2d15cc5803a7d80f1559ceeb003c1.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.result14
1 files changed, 14 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;