Debian Codegraph @

mysql-test/suite/sys_vars/r/super_read_only_func.result

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