3
Creating connection con0
4
Creating connection con1
5
SET @global_delayed_insert_limit = @@GLOBAL.delayed_insert_limit;
6
CREATE TABLE t1 (a varchar(100));
7
'#--------------------FN_DYNVARS_25_01-------------------------#'
8
SET GLOBAL delayed_insert_limit = 9;
10
SET GLOBAL delayed_insert_limit = 9;
12
SET GLOBAL delayed_insert_limit = 9;
13
** Connection default **
14
SET GLOBAL delayed_insert_limit = 9;
15
INSERT INTO t1 VALUES('1');
16
INSERT INTO t1 VALUES('2');
17
INSERT INTO t1 VALUES('3');
18
INSERT INTO t1 VALUES('4');
19
INSERT INTO t1 VALUES('5');
20
INSERT INTO t1 VALUES('6');
23
INSERT DELAYED INTO t1 VALUES('7');
24
INSERT DELAYED INTO t1 VALUES('8');
25
INSERT DELAYED INTO t1 VALUES('9');
26
INSERT DELAYED INTO t1 VALUES('10');
27
INSERT DELAYED INTO t1 VALUES('11');
28
INSERT DELAYED INTO t1 VALUES('12');
29
INSERT DELAYED INTO t1 VALUES('13');
30
INSERT DELAYED INTO t1 VALUES('14');
31
INSERT DELAYED INTO t1 VALUES('15');
32
INSERT DELAYED INTO t1 VALUES('16');
33
INSERT DELAYED INTO t1 VALUES('17');
34
INSERT DELAYED INTO t1 VALUES('18');
35
INSERT DELAYED INTO t1 VALUES('19');
36
INSERT DELAYED INTO t1 VALUES('20');
37
INSERT DELAYED INTO t1 VALUES('21');
38
INSERT DELAYED INTO t1 VALUES('22');|
41
** Connection default **
62
'Bug#35386: insert delayed inserts 1 + limit rows instead of just limit rows'
63
** Connection default **
65
Checking if the delayed insert continued afterwards
91
'#--------------------FN_DYNVARS_25_02-------------------------#'
92
SET GLOBAL delayed_insert_limit = 20;
94
SET GLOBAL delayed_insert_limit = 20;
96
SET GLOBAL delayed_insert_limit = 20;
97
** Connection default **
98
SET GLOBAL delayed_insert_limit = 20;
99
INSERT INTO t1 VALUES('1');
100
INSERT INTO t1 VALUES('2');
101
INSERT INTO t1 VALUES('3');
102
INSERT INTO t1 VALUES('4');
103
INSERT INTO t1 VALUES('5');
104
INSERT INTO t1 VALUES('6');
106
** Connection con1 **
108
INSERT DELAYED INTO t1 VALUES('7');
109
INSERT DELAYED INTO t1 VALUES('8');
110
INSERT DELAYED INTO t1 VALUES('9');
111
INSERT DELAYED INTO t1 VALUES('10');
112
INSERT DELAYED INTO t1 VALUES('11');
113
INSERT DELAYED INTO t1 VALUES('12');
114
INSERT DELAYED INTO t1 VALUES('13');
115
INSERT DELAYED INTO t1 VALUES('14');
116
INSERT DELAYED INTO t1 VALUES('15');
117
INSERT DELAYED INTO t1 VALUES('16');
118
INSERT DELAYED INTO t1 VALUES('17');
119
INSERT DELAYED INTO t1 VALUES('18');
120
INSERT DELAYED INTO t1 VALUES('19');
121
INSERT DELAYED INTO t1 VALUES('20');
122
INSERT DELAYED INTO t1 VALUES('21');
123
INSERT DELAYED INTO t1 VALUES('22');|
124
** Connection con0 **
127
** Connection default **
130
** Connection con0 **
131
Asynchronous execute result
155
** Connection default**
157
Checking if the delayed insert gives the same result afterwards
184
Disconnecting from con1, con0
186
SET @@GLOBAL.delayed_insert_limit = @global_delayed_insert_limit;