Debian Codegraph @

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

raw
1 ############ mysql-test\t\read_only_func.test ##################################
2 # #
3 #Variable Name: read_only #
4 #Scope: SESSION #
5 #Access Type: Dynamic #
6 #Data Type: BOOLEAN #
7 #Default Value: OFF #
8 #Values: ON, OFF #
9 # #
10 # #
11 #Creation Date: 2008-03-02 #
12 #Author: Sharique Abdullah #
13 # #
14 #Description: Test Cases of Dynamic System Variable "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.1/en/server-system-variables.html#
19 # option_mysqld_read_only #
20 # #
21 ################################################################################
22
23 --echo ** Setup **
24 --echo
25 #
26 # Setup
27 #
28
29 --source include/not_embedded.inc
30
31 SET @default_read_only = @@read_only;
32
33 --echo '#--------------------FN_DYNVARS_140_01-------------------------#'
34 ###################################
35 #Setting Read only value ON #
36 ###################################
37
38 SET Global read_only=ON;
39
40 --disable_warnings
41 DROP TABLE IF EXISTS t1;
42 --enable_warnings
43
44 ##################################
45 # Creating table #
46 ##################################
47
48
49 # creating table
50 CREATE TABLE t1
51 (
52 id INT NOT NULL auto_increment,
53 PRIMARY KEY (id),
54 name BLOB
55 );
56
57 ##################################
58 # Inserting values #
59 ##################################
60
61
62 INSERT into t1(name) values("aaassssssssddddddddffffff");
63
64 ###################################
65 # Updating values #
66 ###################################
67
68 update t1 set name="jfjdf" where id=1;
69
70 ###############################################
71 # Select to see wether value is updated or not#
72 ###############################################
73
74 select * from t1 where id=1;
75
76 --echo '#--------------------FN_DYNVARS_140_02-------------------------#'
77 #########################################
78 #Creating user without Super privilege #
79 #########################################
80
81
82 --echo ** Creating new user with out super privilege**
83 CREATE user sameea;
84 grant all on test.* to sameea;
85 CONNECT (connn,localhost,sameea,,);
86
87 --Error ER_SPECIFIC_ACCESS_DENIED_ERROR
88 SET Global read_ONLY=ON;
89 --Error ER_OPTION_PREVENTS_STATEMENT
90 CREATE TABLE t2
91 (
92 id INT NOT NULL auto_increment,
93 PRIMARY KEY (id),
94 name BLOB
95 );
96
97 # With ps-protocol the error is ER_NO_SUCH_TABLE
98 --echo not updating values
99 --Error ER_OPTION_PREVENTS_STATEMENT,ER_NO_SUCH_TABLE
100 INSERT into t2(name) values("aaassssssssddddddddffffff");
101
102
103 --Error ER_OPTION_PREVENTS_STATEMENT,ER_NO_SUCH_TABLE
104 UPDATE t2 SET name="samia" where id=1;
105
106 --echo '#--------------------FN_DYNVARS_140_03-------------------------#'
107
108 ###########################
109 # Testing temporary table #
110 ###########################
111 CREATE TEMPORARY TABLE t3(a int);
112
113 --echo '#--------------------FN_DYNVARS_140_04-------------------------#'
114 ###########################
115 # Turning read_only OFF #
116 ###########################
117 connection default;
118
119 SET Global read_only=OFF;
120 connection connn;
121
122 CREATE TABLE t2
123 (
124 id INT NOT NULL auto_increment,
125 PRIMARY KEY (id),
126 name BLOB
127 );
128 --echo updating values
129 INSERT into t2(name) values("aaassssssssdddddddd");
130
131 UPDATE t2 SET name="samia" where id=1;
132
133 #
134 # Cleanup
135 #
136 connection default;
137
138 DISCONNECT connn;
139
140 DROP USER sameea;
141
142 DROP TABLE t1;
143 DROP TABLE t2;
144 SET global read_only = @default_read_only;
145
146 --disable_info
147 --enable_warnings