1 files changed, 17 insertions, 1 deletions
diff --git a/mysql-test/r/read_only_innodb.result b/mysql-test/r/read_only_innodb.result
index a276e6cbc19..abfc5322ed0 100644
--- a/mysql-test/r/read_only_innodb.result
+++ b/mysql-test/r/read_only_innodb.result
@@ -1,11 +1,16 @@
 DROP TABLE IF EXISTS table_11733 ;
 create user test@localhost;
 grant CREATE, SELECT, DROP on *.* to test@localhost;
+connect  con1,localhost,test,,test;
+connection default;
 set global read_only=0;
 create table table_11733 (a int) engine=InnoDb;
+connection con1;
 BEGIN;
 insert into table_11733 values(11733);
+connection default;
 set global read_only=1;
+connection con1;
 select @@global.read_only;
 @@global.read_only
 1
@@ -14,14 +19,19 @@ a
 11733
 COMMIT;
 ERROR HY000: The MariaDB server is running with the --read-only option so it cannot execute this statement
+connection default;
 set global read_only=0;
 drop table table_11733 ;
 drop user test@localhost;
+disconnect con1;
 create user test@localhost;
 GRANT CREATE, SELECT, DROP ON *.* TO test@localhost;
+connect con1, localhost, test, , test;
+connection default;
 CREATE TABLE t1(a INT) ENGINE=INNODB;
 INSERT INTO t1 VALUES (0), (1);
 SET GLOBAL read_only=1;
+connection con1;
 SELECT * FROM t1;
 a
 0
@@ -32,8 +42,10 @@ a
 0
 1
 COMMIT;
+connection default;
 SET GLOBAL read_only=0;
 FLUSH TABLES WITH READ LOCK;
+connection con1;
 SELECT * FROM t1;
 a
 0
@@ -44,6 +56,7 @@ a
 0
 1
 COMMIT;
+connection default;
 UNLOCK TABLES;
 connection con1;
 lock table t1 read;
@@ -56,6 +69,7 @@ SET GLOBAL read_only=0;
 UNLOCK TABLES;
 DROP TABLE t1;
 DROP USER test@localhost;
+disconnect con1;
 echo End of 5.1 tests 
 #
 # Bug#33669: Transactional temporary tables do not work under --read-only
@@ -71,7 +85,7 @@ INSERT INTO db1.t2 VALUES (2);
 GRANT CREATE TEMPORARY TABLES, DROP, INSERT, DELETE, UPDATE,
 SELECT, LOCK TABLES ON db1.* TO bug33669@localhost;
 SET GLOBAL READ_ONLY = ON;
-# Connection con1 (user bug33669):
+connect con1,localhost,bug33669,,db1;
 
 # Create, insert and drop temporary table:
 
@@ -225,6 +239,8 @@ DROP TABLE temp1, temp2;
 
 # Disconnect and cleanup
 
+disconnect con1;
+connection default;
 SET GLOBAL READ_ONLY = OFF;
 DROP USER bug33669@localhost;
 DROP DATABASE db1;