Debian Codegraph @

mysql-test/suite/sys_vars/t/super_read_only_func.test

raw
1 ############ mysql-test\t\super_read_only_func.test ############################
2 # #
3 #Variable Name: super_read_only #
4 #Scope: GLOBAL #
5 #Access Type: Dynamic #
6 #Data Type: BOOLEAN #
7 #Default Value: OFF #
8 #Values: ON, OFF #
9 # #
10 # #
11 #Creation Date: 2015-05-20 #
12 #Author: Todd Farmer #
13 # #
14 #Description: Test Cases of Dynamic System Variable "super_read_only" #
15 # that checks behavior of this variable in the following ways #
16 # * Functionality based on different values #
17 # #
18 #Reference: http://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html#
19 # option_mysqld_super_read_only #
20 # #
21 ################################################################################
22
23 --echo ** Setup **
24 --echo
25 #
26 # Setup
27 #
28
29
30 SET @default_read_only = @@global.read_only;
31 SET @default_super_read_only = @@global.super_read_only;
32
33 SET @@global.read_only = OFF;
34 SET @@global.super_read_only = OFF;
35
36 CREATE TABLE t1
37 (
38 id INT NOT NULL auto_increment,
39 PRIMARY KEY (id),
40 name BLOB
41 );
42
43 INSERT INTO t1 VALUES (1, 'good');
44
45 ########################################
46 # Checking super_read_only interaction #
47 # with read_only. #
48 ########################################
49
50 SET @@global.super_read_only = OFF;
51 SET @@global.read_only = OFF;
52
53 SELECT IF(@@global.super_read_only, 'FAIL', 'OK') AS sro, IF(@@global.read_only, 'FAIL', 'OK') AS ro;
54
55 SET @@global.super_read_only = ON;
56
57 SELECT IF(@@global.super_read_only, 'OK', 'FAIL') AS sro, IF(@@global.read_only, 'OK', 'FAIL') AS ro;
58
59 SET @@global.super_read_only = OFF;
60
61 SELECT IF(@@global.super_read_only, 'FAIL', 'OK') AS sro, IF(@@global.read_only, 'OK', 'FAIL') AS ro;
62
63 SET @@global.super_read_only = ON;
64
65 SELECT IF(@@global.super_read_only, 'OK', 'FAIL') AS sro, IF(@@global.read_only, 'OK', 'FAIL') AS ro;
66
67 SET @@global.read_only = OFF;
68
69 SELECT IF(@@global.super_read_only, 'FAIL', 'OK') AS sro, IF(@@global.read_only, 'FAIL', 'OK') AS ro;
70
71 --echo ** Creating new user with explicit super privilege**
72 CREATE user sameea;
73 GRANT SUPER ON *.* TO sameea;
74
75 SET @@global.super_read_only = ON;
76
77 --echo ** Connecting connn using username 'sameea' **
78 CONNECT (connn,localhost,sameea,,);
79
80 --Error ER_OPTION_PREVENTS_STATEMENT
81 CREATE TABLE t2
82 (
83 id INT NOT NULL auto_increment,
84 PRIMARY KEY (id),
85 name BLOB
86 );
87
88 # With ps-protocol the error is ER_NO_SUCH_TABLE
89 --echo not updating values
90 --Error ER_OPTION_PREVENTS_STATEMENT,ER_NO_SUCH_TABLE
91 INSERT into t1(name) values("aaassssssssddddddddffffff");
92
93
94 --Error ER_OPTION_PREVENTS_STATEMENT,ER_NO_SUCH_TABLE
95 UPDATE t1 SET name="samia" where id=1;
96
97 SELECT * FROM t1;
98
99 --echo '#--------------------FN_DYNVARS_140_03-------------------------#'
100
101 ###########################
102 # Testing temporary table #
103 ###########################
104 CREATE TEMPORARY TABLE t3(a int);
105
106 --echo '#--------------------FN_DYNVARS_140_04-------------------------#'
107 ###########################
108 # Turning super_read_only OFF #
109 ###########################
110 --echo ** Connection default **
111 connection default;
112
113 SET Global super_read_only=OFF;
114 --echo ** Connection connn **
115 connection connn;
116
117 CREATE TABLE t2
118 (
119 id INT NOT NULL auto_increment,
120 PRIMARY KEY (id),
121 name BLOB
122 );
123 --echo updating values
124 INSERT into t2(name) values("aaassssssssdddddddd");
125
126 UPDATE t2 SET name="samia" where id=1;
127
128 #
129 # Cleanup
130 #
131 --echo ** Connection default **
132 connection default;
133
134 --echo ** Disconnecting connn **
135 DISCONNECT connn;
136
137 DROP USER sameea;
138
139 DROP TABLE t1;
140 DROP TABLE t2;
141 SET global super_read_only = @default_super_read_only;
142 SET global read_only = @default_read_only;
143
144 --disable_info