diff options
Diffstat (limited to 'mysql-test/t/read_only.test')
| -rw-r--r-- | mysql-test/t/read_only.test | 29 |
1 files changed, 0 insertions, 29 deletions
diff --git a/mysql-test/t/read_only.test b/mysql-test/t/read_only.test index 3e5d4fc8ce1..3e970fc6da7 100644 --- a/mysql-test/t/read_only.test +++ b/mysql-test/t/read_only.test @@ -18,15 +18,12 @@ DROP TABLE IF EXISTS t1,t2,t3; create user test@localhost; grant CREATE, SELECT, DROP on *.* to test@localhost; ---echo connect (con1,localhost,test,,test); connect (con1,localhost,test,,test); ---echo connection default; connection default; set global read_only=0; ---echo connection con1; connection con1; create table t1 (a int); @@ -36,7 +33,6 @@ insert into t1 values(1); create table t2 select * from t1; ---echo connection default; connection default; set global read_only=1; @@ -46,7 +42,6 @@ set global read_only=1; create table t3 (a int); drop table t3; ---echo connection con1; connection con1; select @@global.read_only; @@ -123,16 +118,13 @@ insert into t1 values(1); # - is an error in the same connection # - is ok in a different connection ---echo connection default; connection default; set global read_only=0; lock table t1 write; ---echo connection con1; connection con1; lock table t2 write; ---echo connection default; connection default; --error ER_LOCK_OR_ACTIVE_TRANSACTION set global read_only=1; @@ -142,7 +134,6 @@ unlock tables ; --echo send set global read_only=1; send set global read_only=1; ---echo connection con1; connection con1; select @@global.read_only; unlock tables ; @@ -150,7 +141,6 @@ let $wait_condition= SELECT @@global.read_only= 1; --source include/wait_condition.inc select @@global.read_only; ---echo connection default; connection default; --echo reap; reap; @@ -159,16 +149,13 @@ reap; # - is an error in the same connection # - is ok in a different connection ---echo connection default; connection default; set global read_only=0; lock table t1 read; ---echo connection con1; connection con1; lock table t2 read; ---echo connection default; connection default; --error ER_LOCK_OR_ACTIVE_TRANSACTION set global read_only=1; @@ -179,28 +166,23 @@ unlock tables ; set global read_only=1; select @@global.read_only; ---echo connection con1; connection con1; select @@global.read_only; unlock tables ; ---echo connection default; connection default; # pending transaction / READ_ONLY # - is an error in the same connection # - is ok in a different connection ---echo connection default; connection default; set global read_only=0; BEGIN; ---echo connection con1; connection con1; BEGIN; ---echo connection default; connection default; --error ER_LOCK_OR_ACTIVE_TRANSACTION set global read_only=1; @@ -208,7 +190,6 @@ ROLLBACK; set global read_only=1; ---echo connection con1; connection con1; select @@global.read_only; ROLLBACK; @@ -217,26 +198,21 @@ ROLLBACK; # - in the same SUPER connection # - in another SUPER connection ---echo connection default; connection default; set global read_only=0; flush tables with read lock; set global read_only=1; unlock tables; ---echo connect (root2,localhost,root,,test); connect (root2,localhost,root,,test); ---echo connection default; connection default; set global read_only=0; flush tables with read lock; ---echo connection root2; connection root2; set global read_only=1; ---echo connection default; connection default; select @@global.read_only; unlock tables; @@ -256,7 +232,6 @@ drop temporary table if exists ttt; # # Cleanup # ---echo connection default; connection default; set global read_only=0; disconnect con1; @@ -283,18 +258,14 @@ grant all on mysqltest_db2.* to `mysqltest_u1`@`%`; create database mysqltest_db1; grant all on mysqltest_db1.* to `mysqltest_u1`@`%`; flush privileges; ---echo connect (con_bug27440,127.0.0.1,mysqltest_u1,,test,MASTER_MYPORT,); connect (con_bug27440,127.0.0.1,mysqltest_u1,,test,$MASTER_MYPORT,); ---echo connection con_bug27440; connection con_bug27440; --error ER_OPTION_PREVENTS_STATEMENT create database mysqltest_db2; show databases like '%mysqltest_db2%'; --error ER_OPTION_PREVENTS_STATEMENT drop database mysqltest_db1; ---echo disconnect con_bug27440; disconnect con_bug27440; ---echo connection default; connection default; delete from mysql.user where User like 'mysqltest_%'; delete from mysql.db where User like 'mysqltest_%'; |