add a test for drop trigger under --read-only

1 files changed, 4 insertions, 0 deletions

diff --git a/mysql-test/t/read_only.test b/mysql-test/t/read_only.test
index 8ea0f2db9b7..d0f397697d5 100644
--- a/mysql-test/t/read_only.test
+++ b/mysql-test/t/read_only.test
@@ -30,6 +30,7 @@ set global read_only=0;
 connection con1;
 
 create table t1 (a int);
+create trigger trg1 before insert on t1 for each row set @a:=1;
 
 insert into t1 values(1);
 
@@ -56,6 +57,9 @@ create table t3 (a int);
 --error ER_OPTION_PREVENTS_STATEMENT
 insert into t1 values(1);
 
+--error ER_OPTION_PREVENTS_STATEMENT
+drop trigger trg1;
+
 # if a statement, after parse stage, looks like it will update a
 # non-temp table, it will be rejected, even if at execution it would
 # have turned out that 0 rows would be updated