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