summaryrefslogtreecommitdiff
path: root/mysql-test/r
diff options
context:
space:
mode:
authorSergei Golubchik <serg@mariadb.org>2017-10-14 15:59:54 +0200
committerSergei Golubchik <serg@mariadb.org>2017-10-17 07:37:39 +0200
commit19a702a85c69d241e360d1d5a040378928a3fdca (patch)
tree5f9e875c542c38e0aa06464bd7631934d3d081b2 /mysql-test/r
parent421716391b8bafe9af853b1ee3f83d521b69db6e (diff)
downloadmariadb-git-19a702a85c69d241e360d1d5a040378928a3fdca.tar.gz
MDEV-14056 DROP TEMPORARY TABLE IF EXISTS causes error 1290 with read_only option
if it's a DROP TABLE, we cannot detect whether a table is temporary by looking in thd->temporary_tables - because the table might simply not exist at all.
Diffstat (limited to 'mysql-test/r')
-rw-r--r--mysql-test/r/read_only.result3
1 files changed, 3 insertions, 0 deletions
diff --git a/mysql-test/r/read_only.result b/mysql-test/r/read_only.result
index 807dc426696..2d0f9d730fd 100644
--- a/mysql-test/r/read_only.result
+++ b/mysql-test/r/read_only.result
@@ -47,6 +47,9 @@ delete t1 from t1,t3 where t1.a=t3.a;
drop table t1;
insert into t1 values(1);
ERROR HY000: The MariaDB server is running with the --read-only option so it cannot execute this statement
+drop temporary table if exists t1;
+Warnings:
+Note 1051 Unknown table 't1'
connection default;
set global read_only=0;
lock table t1 write;