summaryrefslogtreecommitdiffstats
path: root/mysql-test/main/read_only.result
diff options
context:
space:
mode:
authorDaniel Baumann <daniel.baumann@progress-linux.org>2024-05-04 18:00:34 +0000
committerDaniel Baumann <daniel.baumann@progress-linux.org>2024-05-04 18:00:34 +0000
commit3f619478f796eddbba6e39502fe941b285dd97b1 (patch)
treee2c7b5777f728320e5b5542b6213fd3591ba51e2 /mysql-test/main/read_only.result
parentInitial commit. (diff)
downloadmariadb-upstream.tar.xz
mariadb-upstream.zip
Adding upstream version 1:10.11.6.upstream/1%10.11.6upstream
Signed-off-by: Daniel Baumann <daniel.baumann@progress-linux.org>
Diffstat (limited to 'mysql-test/main/read_only.result')
-rw-r--r--mysql-test/main/read_only.result230
1 files changed, 230 insertions, 0 deletions
diff --git a/mysql-test/main/read_only.result b/mysql-test/main/read_only.result
new file mode 100644
index 00000000..65cc12ff
--- /dev/null
+++ b/mysql-test/main/read_only.result
@@ -0,0 +1,230 @@
+set @start_read_only= @@global.read_only;
+DROP TABLE IF EXISTS t1,t2,t3;
+create user test@localhost;
+grant CREATE, SELECT, DROP on *.* to test@localhost;
+grant ALL on test.* to test@localhost;
+connect con1,localhost,test,,test;
+connection default;
+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);
+create table t2 select * from t1;
+connection default;
+set global read_only=1;
+create table t3 (a int);
+drop table t3;
+connection con1;
+select @@global.read_only;
+@@global.read_only
+1
+create table t3 (a int);
+ERROR HY000: The MariaDB server is running with the --read-only option so it cannot execute this statement
+insert into t1 values(1);
+ERROR HY000: The MariaDB server is running with the --read-only option so it cannot execute this statement
+drop trigger trg1;
+ERROR HY000: The MariaDB server is running with the --read-only option so it cannot execute this statement
+update t1 set a=1 where 1=0;
+ERROR HY000: The MariaDB server is running with the --read-only option so it cannot execute this statement
+update t1,t2 set t1.a=t2.a+1 where t1.a=t2.a;
+ERROR HY000: The MariaDB server is running with the --read-only option so it cannot execute this statement
+delete t1,t2 from t1,t2 where t1.a=t2.a;
+ERROR HY000: The MariaDB server is running with the --read-only option so it cannot execute this statement
+create temporary table t3 (a int);
+create temporary table t4 (a int) select * from t3;
+insert into t3 values(1);
+insert into t4 select * from t3;
+create table t3 (a int);
+ERROR HY000: The MariaDB server is running with the --read-only option so it cannot execute this statement
+update t1,t3 set t1.a=t3.a+1 where t1.a=t3.a;
+ERROR HY000: The MariaDB server is running with the --read-only option so it cannot execute this statement
+update t1,t3 set t3.a=t1.a+1 where t1.a=t3.a;
+update t4,t3 set t4.a=t3.a+1 where t4.a=t3.a;
+delete t1 from t1,t3 where t1.a=t3.a;
+ERROR HY000: The MariaDB server is running with the --read-only option so it cannot execute this statement
+delete t3 from t1,t3 where t1.a=t3.a;
+delete t4 from t3,t4 where t4.a=t3.a;
+create temporary table t1 (a int);
+insert into t1 values(1);
+update t1,t3 set t1.a=t3.a+1 where t1.a=t3.a;
+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 'test.t1'
+connection default;
+set global read_only=0;
+lock table t1 write;
+connection con1;
+lock table t2 write;
+connection default;
+set global read_only=1;
+ERROR HY000: Can't execute the given command because you have active locked tables or an active transaction
+unlock tables ;
+send set global read_only=1;
+set global read_only=1;
+connection con1;
+select @@global.read_only;
+@@global.read_only
+0
+unlock tables ;
+select @@global.read_only;
+@@global.read_only
+1
+connection default;
+reap;
+connection default;
+set global read_only=0;
+lock table t1 read;
+connection con1;
+lock table t2 read;
+connection default;
+set global read_only=1;
+ERROR HY000: Can't execute the given command because you have active locked tables or an active transaction
+unlock tables ;
+set global read_only=1;
+select @@global.read_only;
+@@global.read_only
+1
+connection con1;
+select @@global.read_only;
+@@global.read_only
+1
+unlock tables ;
+connection default;
+connection default;
+set global read_only=0;
+BEGIN;
+connection con1;
+BEGIN;
+connection default;
+set global read_only=1;
+ERROR HY000: Can't execute the given command because you have active locked tables or an active transaction
+ROLLBACK;
+set global read_only=1;
+connection con1;
+select @@global.read_only;
+@@global.read_only
+1
+ROLLBACK;
+connection default;
+set global read_only=0;
+flush tables with read lock;
+set global read_only=1;
+unlock tables;
+connect root2,localhost,root,,test;
+connection default;
+set global read_only=0;
+flush tables with read lock;
+connection root2;
+set global read_only=1;
+connection default;
+select @@global.read_only;
+@@global.read_only
+1
+unlock tables;
+disconnect root2;
+drop temporary table ttt;
+ERROR 42S02: Unknown table 'test.ttt'
+drop temporary table if exists ttt;
+Warnings:
+Note 1051 Unknown table 'test.ttt'
+connection default;
+set global read_only=0;
+disconnect con1;
+drop table t1,t2;
+drop user test@localhost;
+#
+# Bug#27440 read_only allows create and drop database
+#
+set global read_only= 1;
+drop database if exists mysqltest_db1;
+drop database if exists mysqltest_db2;
+delete from mysql.user where User like 'mysqltest_%';
+delete from mysql.db where User like 'mysqltest_%';
+delete from mysql.tables_priv where User like 'mysqltest_%';
+delete from mysql.columns_priv where User like 'mysqltest_%';
+flush privileges;
+create user `mysqltest_u1`@`%`;
+grant all on mysqltest_db2.* to `mysqltest_u1`@`%`;
+create database mysqltest_db1;
+grant all on mysqltest_db1.* to `mysqltest_u1`@`%`;
+grant select on test.* to `mysqltest_u1`@`%`;
+flush privileges;
+connect con_bug27440,127.0.0.1,mysqltest_u1,,test,$MASTER_MYPORT,;
+connection con_bug27440;
+create database mysqltest_db2;
+ERROR HY000: The MariaDB server is running with the --read-only option so it cannot execute this statement
+show databases like '%mysqltest_db2%';
+Database (%mysqltest_db2%)
+drop database mysqltest_db1;
+ERROR HY000: The MariaDB server is running with the --read-only option so it cannot execute this statement
+disconnect con_bug27440;
+connection default;
+delete from mysql.user where User like 'mysqltest_%';
+delete from mysql.db where User like 'mysqltest_%';
+delete from mysql.tables_priv where User like 'mysqltest_%';
+delete from mysql.columns_priv where User like 'mysqltest_%';
+flush privileges;
+drop database mysqltest_db1;
+set global read_only= @start_read_only;
+#
+# MDEV-16987 - ALTER DATABASE possible in read-only mode
+#
+CREATE USER user1@localhost;
+GRANT ALTER ON test1.* TO user1@localhost;
+CREATE DATABASE test1;
+SET GLOBAL read_only=1;
+ALTER DATABASE test1 CHARACTER SET utf8;
+ERROR HY000: The MariaDB server is running with the --read-only option so it cannot execute this statement
+SET GLOBAL read_only=0;
+DROP DATABASE test1;
+DROP USER user1@localhost;
+USE test;
+# End of 5.5 tests
+#
+# WL#5968 Implement START TRANSACTION READ (WRITE|ONLY);
+#
+#
+# Test interaction with read_only system variable.
+CREATE TABLE t1(a INT);
+INSERT INTO t1 VALUES (1), (2);
+CREATE USER user1;
+GRANT ALL on test.* to user1;
+connect con1, localhost, user1;
+connection default;
+SET GLOBAL read_only= 1;
+# All allowed with super privilege
+START TRANSACTION;
+COMMIT;
+START TRANSACTION READ ONLY;
+COMMIT;
+START TRANSACTION READ WRITE;
+COMMIT;
+# We allow implicit RW transaction without super privilege
+# for compatibility reasons
+connection con1;
+START TRANSACTION;
+# Check that table updates are still disallowed.
+INSERT INTO t1 VALUES (3);
+ERROR HY000: The MariaDB server is running with the --read-only option so it cannot execute this statement
+UPDATE t1 SET a= 1;
+ERROR HY000: The MariaDB server is running with the --read-only option so it cannot execute this statement
+DELETE FROM t1;
+ERROR HY000: The MariaDB server is running with the --read-only option so it cannot execute this statement
+COMMIT;
+START TRANSACTION READ ONLY;
+COMMIT;
+# Explicit RW trans is not allowed without super privilege
+START TRANSACTION READ WRITE;
+ERROR HY000: The MariaDB server is running with the --read-only option so it cannot execute this statement
+COMMIT;
+disconnect con1;
+connection default;
+DROP USER user1;
+SET GLOBAL read_only= 0;
+DROP TABLE t1;
+# End of 10.0 tests