1# 2# Start of 10.5 tests 3# 4# 5# Test that @@read_only is not ignored without READ_ONLY ADMIN or SUPER 6# 7CREATE TABLE t1 (a INT); 8CREATE USER user1@localhost IDENTIFIED BY ''; 9GRANT ALL PRIVILEGES ON *.* TO user1@localhost; 10REVOKE READ_ONLY ADMIN, SUPER ON *.* FROM user1@localhost; 11SET @@GLOBAL.read_only=1; 12connect con1,localhost,user1,,; 13connection con1; 14UPDATE t1 SET a=11 WHERE a=10; 15ERROR HY000: The MariaDB server is running with the --read-only option so it cannot execute this statement 16DELETE FROM t1 WHERE a=11; 17ERROR HY000: The MariaDB server is running with the --read-only option so it cannot execute this statement 18INSERT INTO t1 VALUES (20); 19ERROR HY000: The MariaDB server is running with the --read-only option so it cannot execute this statement 20disconnect con1; 21connection default; 22SET @@GLOBAL.read_only=0; 23DROP USER user1@localhost; 24DROP TABLE t1; 25# 26# Test that @@read_only is ignored with READ_ONLY ADMIN 27# 28CREATE TABLE t1 (a INT); 29CREATE USER user1@localhost IDENTIFIED BY ''; 30GRANT INSERT, UPDATE, DELETE, READ_ONLY ADMIN ON *.* TO user1@localhost; 31SHOW GRANTS FOR user1@localhost; 32Grants for user1@localhost 33GRANT INSERT, UPDATE, DELETE, READ_ONLY ADMIN ON *.* TO `user1`@`localhost` 34SET @@GLOBAL.read_only=1; 35connect con1,localhost,user1,,; 36connection con1; 37SELECT @@read_only; 38@@read_only 391 40UPDATE t1 SET a=11 WHERE a=10; 41DELETE FROM t1 WHERE a=11; 42INSERT INTO t1 VALUES (20); 43disconnect con1; 44connection default; 45SET @@GLOBAL.read_only=0; 46DROP USER user1@localhost; 47DROP TABLE t1; 48# 49# Test that @@read_only is ignored with SUPER 50# 51CREATE TABLE t1 (a INT); 52CREATE USER user1@localhost IDENTIFIED BY ''; 53GRANT INSERT, UPDATE, DELETE, SUPER ON *.* TO user1@localhost; 54SHOW GRANTS FOR user1@localhost; 55Grants for user1@localhost 56GRANT INSERT, UPDATE, DELETE, SUPER ON *.* TO `user1`@`localhost` 57SET @@GLOBAL.read_only=1; 58connect con1,localhost,user1,,; 59connection con1; 60SELECT @@read_only; 61@@read_only 621 63UPDATE t1 SET a=11 WHERE a=10; 64DELETE FROM t1 WHERE a=11; 65INSERT INTO t1 VALUES (20); 66disconnect con1; 67connection default; 68SET @@GLOBAL.read_only=0; 69DROP USER user1@localhost; 70DROP TABLE t1; 71# 72# End of 10.5 tests 73# 74