1** Setup **
2
3SET @default_read_only = @@global.read_only;
4SET @default_super_read_only = @@global.super_read_only;
5SET @@global.read_only = OFF;
6SET @@global.super_read_only = OFF;
7CREATE TABLE t1
8(
9id INT NOT NULL auto_increment,
10PRIMARY KEY (id),
11name BLOB
12);
13INSERT INTO t1 VALUES (1, 'good');
14SET @@global.super_read_only = OFF;
15SET @@global.read_only = OFF;
16SELECT IF(@@global.super_read_only, 'FAIL', 'OK') AS sro, IF(@@global.read_only, 'FAIL', 'OK') AS ro;
17sro	ro
18OK	OK
19SET @@global.super_read_only = ON;
20SELECT IF(@@global.super_read_only, 'OK', 'FAIL') AS sro, IF(@@global.read_only, 'OK', 'FAIL') AS ro;
21sro	ro
22OK	OK
23SET @@global.super_read_only = OFF;
24SELECT IF(@@global.super_read_only, 'FAIL', 'OK') AS sro, IF(@@global.read_only, 'OK', 'FAIL') AS ro;
25sro	ro
26OK	OK
27SET @@global.super_read_only = ON;
28SELECT IF(@@global.super_read_only, 'OK', 'FAIL') AS sro, IF(@@global.read_only, 'OK', 'FAIL') AS ro;
29sro	ro
30OK	OK
31SET @@global.read_only = OFF;
32SELECT IF(@@global.super_read_only, 'FAIL', 'OK') AS sro, IF(@@global.read_only, 'FAIL', 'OK') AS ro;
33sro	ro
34OK	OK
35** Creating new user with explicit super privilege**
36CREATE user sameea;
37GRANT SUPER ON *.* TO sameea;
38SET @@global.super_read_only = ON;
39** Connecting connn using username 'sameea' **
40CREATE TABLE t2
41(
42id INT NOT NULL auto_increment,
43PRIMARY KEY (id),
44name BLOB
45);
46ERROR HY000: The MySQL server is running with the --super-read-only option so it cannot execute this statement
47not updating values
48INSERT into t1(name) values("aaassssssssddddddddffffff");
49Got one of the listed errors
50UPDATE t1 SET name="samia" where id=1;
51Got one of the listed errors
52SELECT * FROM t1;
53id	name
541	good
55'#--------------------FN_DYNVARS_140_03-------------------------#'
56CREATE TEMPORARY TABLE t3(a int);
57'#--------------------FN_DYNVARS_140_04-------------------------#'
58** Connection default **
59SET Global super_read_only=OFF;
60** Connection connn **
61CREATE TABLE t2
62(
63id INT NOT NULL auto_increment,
64PRIMARY KEY (id),
65name BLOB
66);
67updating values
68INSERT into t2(name) values("aaassssssssdddddddd");
69UPDATE t2 SET name="samia" where id=1;
70** Connection default **
71** Disconnecting connn **
72DROP USER sameea;
73DROP TABLE t1;
74DROP TABLE t2;
75SET global super_read_only = @default_super_read_only;
76SET global read_only = @default_read_only;
77