summaryrefslogtreecommitdiff
path: root/mysql-test/main/cte_nonrecursive.result
diff options
context:
space:
mode:
authorMarko Mäkelä <marko.makela@mariadb.com>2019-04-08 08:22:34 +0300
committerMarko Mäkelä <marko.makela@mariadb.com>2019-04-08 08:22:34 +0300
commitd8303c3ee7750f4003e3561c3e60ee6e636bf9ad (patch)
treee4e8bb9a850836859974be09bf8cf524ea21491c /mysql-test/main/cte_nonrecursive.result
parenta2afba8b01c249971f600a82f1a9b0a119374b9a (diff)
parentcc492bfd4ff2d15cc5803a7d80f1559ceeb003c1 (diff)
downloadmariadb-git-d8303c3ee7750f4003e3561c3e60ee6e636bf9ad.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.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 eeae6d02476..4fea05f79b4 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;