diff options
| author | Sergei Golubchik <serg@mariadb.org> | 2020-06-16 09:34:38 +0200 |
|---|---|---|
| committer | Sergei Golubchik <serg@mariadb.org> | 2020-07-04 01:44:47 +0200 |
| commit | 79a3f96166c1c6b46bea859a357ec5c2a11d6b63 (patch) | |
| tree | 33aeb9e27aa5f858c819e40969b08a04f413c93b /mysql-test/main/drop.result | |
| parent | 529b6dffe9e620d7cb1da30e1df6eebda66f01ee (diff) | |
| download | mariadb-git-79a3f96166c1c6b46bea859a357ec5c2a11d6b63.tar.gz | |
rewrite bug#26704 test case
drop-no_root needs DROP DATABASE to fail.
But `chmod 000` is not reliable after drop table force anymore.
Make DROP DATABASE to fail by creating an extra file in the db dir
Diffstat (limited to 'mysql-test/main/drop.result')
| -rw-r--r-- | mysql-test/main/drop.result | 13 |
1 files changed, 13 insertions, 0 deletions
diff --git a/mysql-test/main/drop.result b/mysql-test/main/drop.result index 4755965cbb2..d50ffabc9fa 100644 --- a/mysql-test/main/drop.result +++ b/mysql-test/main/drop.result @@ -131,6 +131,19 @@ create table mysql_test.`#sql-347f_7` (f1 int); create table mysql_test.`#sql-347f_8` (f1 int); drop table mysql_test.`#sql-347f_8`; drop database mysql_test; +create database mysql_test; +use mysql_test; +create table t1(c int); +drop database mysql_test; +ERROR HY000: Error dropping database (can't rmdir './mysql_test', errno: 39 "Directory not empty") +select database(); +database() +mysql_test +drop database mysql_test; +select database(); +database() +NULL +use test; # -- # -- Bug#29958: Weird message on DROP DATABASE if mysql.proc does not |