1
############# mysql-test\t\sql_low_priority_updates_func.test ###########################
3
# Variable Name: sql_low_priority_updates #
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
#########################################################################################
28
--source include/not_embedded.inc
30
--echo Creating connection con0
31
connect (con0,localhost,root,,);
32
--echo Creating connection con1
33
connect (con1,localhost,root,,);
37
SET @global_delayed_insert_limit = @@GLOBAL.delayed_insert_limit;
43
CREATE TABLE t1 (a varchar(100));
45
--echo '#--------------------FN_DYNVARS_25_01-------------------------#'
47
# Value less than the provided INSERTS (9)
50
SET GLOBAL delayed_insert_limit = 9;
52
--echo ** Connection con0 **
54
SET GLOBAL delayed_insert_limit = 9;
55
--echo ** Connection con1 **
57
SET GLOBAL delayed_insert_limit = 9;
58
--echo ** Connection default **
60
SET GLOBAL delayed_insert_limit = 9;
62
INSERT INTO t1 VALUES('1');
63
INSERT INTO t1 VALUES('2');
64
INSERT INTO t1 VALUES('3');
65
INSERT INTO t1 VALUES('4');
66
INSERT INTO t1 VALUES('5');
67
INSERT INTO t1 VALUES('6');
71
--echo ** Connection con1 **
77
INSERT DELAYED INTO t1 VALUES('7');
78
INSERT DELAYED INTO t1 VALUES('8');
79
INSERT DELAYED INTO t1 VALUES('9');
80
INSERT DELAYED INTO t1 VALUES('10');
81
INSERT DELAYED INTO t1 VALUES('11');
82
INSERT DELAYED INTO t1 VALUES('12');
83
INSERT DELAYED INTO t1 VALUES('13');
84
INSERT DELAYED INTO t1 VALUES('14');
85
INSERT DELAYED INTO t1 VALUES('15');
86
INSERT DELAYED INTO t1 VALUES('16');
87
INSERT DELAYED INTO t1 VALUES('17');
88
INSERT DELAYED INTO t1 VALUES('18');
89
INSERT DELAYED INTO t1 VALUES('19');
90
INSERT DELAYED INTO t1 VALUES('20');
91
INSERT DELAYED INTO t1 VALUES('21');
92
INSERT DELAYED INTO t1 VALUES('22');|
96
--echo ** Connection con0 **
106
--echo ** Connection default **
109
--echo Waiting for 1 sec
114
--echo ** Connection con0 **
117
--echo 'Bug#35386: insert delayed inserts 1 + limit rows instead of just limit rows'
119
--echo ** Connection default **
122
--echo Waiting for 1 sec
124
--echo Checking if the delayed insert continued afterwards
130
--echo '#--------------------FN_DYNVARS_25_02-------------------------#'
135
SET GLOBAL delayed_insert_limit = 20;
137
--echo ** Connection con0 **
139
SET GLOBAL delayed_insert_limit = 20;
140
--echo ** Connection con1 **
142
SET GLOBAL delayed_insert_limit = 20;
143
--echo ** Connection default **
145
SET GLOBAL delayed_insert_limit = 20;
147
INSERT INTO t1 VALUES('1');
148
INSERT INTO t1 VALUES('2');
149
INSERT INTO t1 VALUES('3');
150
INSERT INTO t1 VALUES('4');
151
INSERT INTO t1 VALUES('5');
152
INSERT INTO t1 VALUES('6');
156
--echo ** Connection con1 **
159
--echo Asynchronous execute
163
INSERT DELAYED INTO t1 VALUES('7');
164
INSERT DELAYED INTO t1 VALUES('8');
165
INSERT DELAYED INTO t1 VALUES('9');
166
INSERT DELAYED INTO t1 VALUES('10');
167
INSERT DELAYED INTO t1 VALUES('11');
168
INSERT DELAYED INTO t1 VALUES('12');
169
INSERT DELAYED INTO t1 VALUES('13');
170
INSERT DELAYED INTO t1 VALUES('14');
171
INSERT DELAYED INTO t1 VALUES('15');
172
INSERT DELAYED INTO t1 VALUES('16');
173
INSERT DELAYED INTO t1 VALUES('17');
174
INSERT DELAYED INTO t1 VALUES('18');
175
INSERT DELAYED INTO t1 VALUES('19');
176
INSERT DELAYED INTO t1 VALUES('20');
177
INSERT DELAYED INTO t1 VALUES('21');
178
INSERT DELAYED INTO t1 VALUES('22');|
182
--echo ** Connection con0 **
185
--echo Asynchronous execute
193
--echo ** Connection default **
196
--echo Waiting for 1 sec
201
--echo ** Connection con0 **
203
--echo Asynchronous execute result
206
--echo ** Connection default**
209
--echo Waiting for 1 sec
211
--echo Checking if the delayed insert gives the same result afterwards
220
--echo Switching to default
223
--echo Disconnecting from con1, con0
229
SET @@GLOBAL.delayed_insert_limit = @global_delayed_insert_limit;