1
############# mysql-test\t\sql_low_priority_updates_func.test #################
3
# Variable Name: sql_low_priority_updates #
4
# Scope: GLOBAL & SESSION #
5
# Access Type: Dynamic #
7
# Default Value: 1 TRUE #
8
# Values: 1 TRUE, 0 FALSE #
11
# Creation Date: 2008-02-25 #
12
# Author: Sharique Abdullah #
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 #
18
# Reference: http://dev.mysql.com/doc/refman/5.1/en/set-option.html #
20
###############################################################################
22
--source include/not_embedded.inc
24
################################################################
25
# sql_low_priority_updates was renamed to low_priority_updates #
26
################################################################
33
--echo ** Connecting con0 using root **
34
connect (con0,localhost,root,,);
35
--echo ** Connecting con1 using root **
36
connect (con1,localhost,root,,);
38
--echo ** Connection default **
41
SET @global_low_priority_updates = @@GLOBAL.low_priority_updates;
42
SET @session_low_priority_updates = @@SESSION.low_priority_updates;
48
CREATE TABLE t1 (a varchar(100));
50
--echo '#--------------------FN_DYNVARS_160_01-------------------------#'
55
--echo ** Connection con0 **
57
SET SESSION low_priority_updates = ON;
58
--echo ** Connection con1 **
60
SET SESSION low_priority_updates = ON;
61
--echo ** Connection default **
63
SET SESSION low_priority_updates = ON;
65
INSERT INTO t1 VALUES('1');
66
INSERT INTO t1 VALUES('2');
67
INSERT INTO t1 VALUES('3');
68
INSERT INTO t1 VALUES('4');
69
INSERT INTO t1 VALUES('5');
70
INSERT INTO t1 VALUES('6');
74
--echo ** Connection con1 **
77
--echo ** Asynchronous Execution **
81
UPDATE t1 SET a = CONCAT(a,"-updated");|
85
--echo ** Connection con0 **
88
--echo ** Asynchronous Execution **
98
--echo ** Connection default **
101
--echo Sleeping for 1 secs
106
--echo ** Connection con0 **
108
--echo ** Asynchronous Result **
111
--echo Expected values of a without -updated;
113
--echo ** Connection default **
118
--echo '#--------------------FN_DYNVARS_160_02-------------------------#'
123
--echo ** Connection con0 **
125
SET SESSION low_priority_updates = OFF;
126
--echo ** Connection con1 **
128
SET SESSION low_priority_updates = OFF;
129
--echo ** Connection default**
131
SET SESSION low_priority_updates = OFF;
133
INSERT INTO t1 VALUES('1');
134
INSERT INTO t1 VALUES('2');
135
INSERT INTO t1 VALUES('3');
136
INSERT INTO t1 VALUES('4');
137
INSERT INTO t1 VALUES('5');
138
INSERT INTO t1 VALUES('6');
142
--echo ** Connection con1 **
145
--echo ** Asynchronous Execution **
149
UPDATE t1 SET a = CONCAT(a,"-updated");|
153
--echo ** Connection con0 **
156
--echo ** Asynchronous Execution **
166
--echo ** Connection default **
169
--echo Sleeping for 1 secs
174
--echo ** Connection con0 **
176
--echo ** Asynchronous Result **
178
--echo Expected values of a with -updated;
180
--echo ** Connection default**
185
--echo '#--------------------FN_DYNVARS_160_03-------------------------#'
187
# Session data integrity check & GLOBAL Value check
190
--echo ** Connecting con_int1 using root **
191
connect (con_int1,localhost,root,,);
193
--echo ** Connection con_int1 **
195
SELECT @@SESSION.low_priority_updates;
196
--echo 1 / TRUE Expected
198
SET SESSION low_priority_updates = FALSE;
200
--echo ** Connecting con_int2 using root **
201
connect (con_int2,localhost,root,,);
203
--echo ** Connection con_int2 **
205
SELECT @@SESSION.low_priority_updates;
206
--echo 1 / TRUE Expected
208
SET SESSION low_priority_updates = TRUE;
210
--echo ** Connection con_int1 **
212
SELECT @@SESSION.low_priority_updates;
213
--echo 0 / FALSE Expected
215
--echo ** Connection con_int2 **
217
SELECT @@SESSION.low_priority_updates;
218
--echo 1 / TRUE Expected
220
--echo ** Connection default **
223
--echo Disconnecting Connections con_int1, con_int2
231
--echo ** Connection default **
233
--echo Disconnecting Connections con0, con1
239
SET @@GLOBAL.low_priority_updates = @global_low_priority_updates;
240
SET @@SESSION.low_priority_updates = @session_low_priority_updates;