Debian Codegraph @

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

raw
1 ################################################################################
2 # #
3 # Variable Name: sql_low_priority_updates #
4 # Scope: GLOBAL & SESSION #
5 # Access Type: Dynamic #
6 # Data Type: BOOLEAN #
7 # Default Value: 1 TRUE #
8 # Values: 1 TRUE, 0 FALSE #
9 # #
10 # #
11 # Creation Date: 2008-02-25 #
12 # Author: Sharique Abdullah #
13 # #
14 # Description: Test Cases of Dynamic System Variable sql_low_priority_updates #
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/set-option.html #
19 # #
20 ################################################################################
21
22 --source include/not_embedded.inc
23
24 ################################################################
25 # sql_low_priority_updates was renamed to low_priority_updates #
26 ################################################################
27
28 --echo ** Setup **
29 --echo
30 #
31 # Setup
32 #
33 connect (con0,localhost,root,,);
34 connect (con1,localhost,root,,);
35
36 connection default;
37
38 SET @global_low_priority_updates = @@GLOBAL.low_priority_updates;
39 SET @session_low_priority_updates = @@SESSION.low_priority_updates;
40
41 #
42 # Create Table
43 #
44
45 CREATE TABLE t1 (a varchar(100));
46 create view v1 as select * from t1;
47
48 --echo '#--------------------FN_DYNVARS_160_01-------------------------#'
49 #
50 # Value ON
51 #
52
53 connection con0;
54 SET SESSION low_priority_updates = ON;
55 connection con1;
56 SET SESSION low_priority_updates = ON;
57 connection default;
58 SET SESSION low_priority_updates = ON;
59
60 INSERT INTO t1 VALUES('1');
61 INSERT INTO t1 VALUES('2');
62 INSERT INTO t1 VALUES('3');
63 INSERT INTO t1 VALUES('4');
64 INSERT INTO t1 VALUES('5');
65 INSERT INTO t1 VALUES('6');
66
67 LOCK TABLE v1 WRITE CONCURRENT;
68
69 connection con1;
70
71 --echo ** Asynchronous Execution **
72 delimiter |;
73
74 send
75 UPDATE t1 SET a = CONCAT(a,"-updated");|
76
77 delimiter ;|
78
79 connection con0;
80
81 let $wait_condition = SELECT COUNT(*) > 0 FROM information_schema.processlist
82 WHERE state='Waiting for table level lock' AND
83 info LIKE 'UPDATE t1 SET a = CONCAT(a,"-updated")';
84 --source include/wait_condition.inc
85
86 --echo ** Asynchronous Execution **
87 delimiter |;
88
89 send
90 LOCK TABLE t1 READ;
91 SELECT * FROM t1;
92 UNLOCK TABLES;|
93
94 delimiter ;|
95
96 connection default;
97
98 let $wait_condition= SELECT count(*) = 2 FROM information_schema.processlist
99 WHERE state LIKE 'Waiting for table level lock';
100 --source include/wait_condition.inc
101 UNLOCK TABLES;
102
103 connection con0;
104 --echo ** Asynchronous Result **
105 reap;
106
107 --echo Expected values of a without -updated;
108
109 connection default;
110
111 DELETE FROM t1;
112
113 --echo '#--------------------FN_DYNVARS_160_02-------------------------#'
114 #
115 # Value ON
116 #
117
118 connection con0;
119 SET SESSION low_priority_updates = OFF;
120 connection con1;
121 reap;
122 SET SESSION low_priority_updates = OFF;
123 connection default;
124 SET SESSION low_priority_updates = OFF;
125
126 INSERT INTO t1 VALUES('1');
127 INSERT INTO t1 VALUES('2');
128 INSERT INTO t1 VALUES('3');
129 INSERT INTO t1 VALUES('4');
130 INSERT INTO t1 VALUES('5');
131 INSERT INTO t1 VALUES('6');
132
133 LOCK TABLE v1 READ;
134
135 connection con1;
136
137 --echo ** Asynchronous Execution **
138 delimiter |;
139
140 send
141 UPDATE t1 SET a = CONCAT(a,"-updated");|
142
143 delimiter ;|
144
145 connection con0;
146
147 let $wait_condition = SELECT COUNT(*) > 0 FROM information_schema.processlist
148 WHERE state='Waiting for table level lock' AND
149 info LIKE 'UPDATE t1 SET a = CONCAT(a,"-updated")';
150 --source include/wait_condition.inc
151
152 --echo ** Asynchronous Execution **
153 delimiter |;
154
155 send
156 LOCK TABLE t1 READ;
157 SELECT * FROM t1;
158 UNLOCK TABLES;|
159
160 delimiter ;|
161
162 connection default;
163
164 let $wait_condition= SELECT count(*) = 2 FROM information_schema.processlist
165 WHERE state LIKE 'Waiting for table level lock';
166 --source include/wait_condition.inc
167 UNLOCK TABLES;
168
169 connection con0;
170 --echo ** Asynchronous Result **
171 reap;
172 --echo Expected values of a with -updated;
173
174 connection default;
175
176 DELETE FROM t1;
177
178 --echo '#--------------------FN_DYNVARS_160_03-------------------------#'
179 #
180 # Session data integrity check & GLOBAL Value check
181 #
182
183 connect (con_int1,localhost,root,,);
184
185 connection con_int1;
186 SELECT @@SESSION.low_priority_updates;
187 --echo 1 / TRUE Expected
188
189 SET SESSION low_priority_updates = FALSE;
190
191 connect (con_int2,localhost,root,,);
192
193 connection con_int2;
194 SELECT @@SESSION.low_priority_updates;
195 --echo 1 / TRUE Expected
196
197 SET SESSION low_priority_updates = TRUE;
198
199 connection con_int1;
200 SELECT @@SESSION.low_priority_updates;
201 --echo 0 / FALSE Expected
202
203 connection con_int2;
204 SELECT @@SESSION.low_priority_updates;
205 --echo 1 / TRUE Expected
206
207 connection default;
208
209 disconnect con_int1;
210 disconnect con_int2;
211
212 #
213 # Cleanup
214 #
215
216 connection default;
217 disconnect con0;
218 disconnect con1;
219
220 drop view v1;
221 DROP TABLE t1;
222
223 SET @@GLOBAL.low_priority_updates = @global_low_priority_updates;
224 SET @@SESSION.low_priority_updates = @session_low_priority_updates;