diff options
| author | Marko Mäkelä <marko.makela@mariadb.com> | 2021-11-29 10:34:33 +0200 |
|---|---|---|
| committer | Marko Mäkelä <marko.makela@mariadb.com> | 2021-11-29 10:34:33 +0200 |
| commit | fafe60e7e2da72488ff3741367a962b45a23b8ee (patch) | |
| tree | 6faf3cfeb03d33da6a8cf5db31bc2754945103fe /mysql-test/main/cte_nonrecursive.test | |
| parent | 289721de9aca8cdf3bdef1a010477e2d38eebb8d (diff) | |
| download | mariadb-git-fafe60e7e2da72488ff3741367a962b45a23b8ee.tar.gz | |
MDEV-27134: Sporadic failure of DROP DATABASE test
Let us create and drop a separate database for getting rid of the
default database in the MDEV-22781 test.
Diffstat (limited to 'mysql-test/main/cte_nonrecursive.test')
| -rw-r--r-- | mysql-test/main/cte_nonrecursive.test | 5 |
1 files changed, 3 insertions, 2 deletions
diff --git a/mysql-test/main/cte_nonrecursive.test b/mysql-test/main/cte_nonrecursive.test index 41a0146e4d0..0a18ff3a333 100644 --- a/mysql-test/main/cte_nonrecursive.test +++ b/mysql-test/main/cte_nonrecursive.test @@ -1205,7 +1205,9 @@ DROP TABLE test.t; --echo # MDEV-22781: create view with CTE without default database --echo # -drop database test; +create database db; +use db; +drop database db; create database db1; create table db1.t1 (a int); insert into db1.t1 values (3),(7),(1); @@ -1227,7 +1229,6 @@ drop view db1.v1; drop table db1.t1; drop database db1; -create database test; use test; --echo # |