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),b VARCHAR(100),c VARCHAR(100));
7
CREATE VIEW v1 as select * from t1;
8
'#--------------------FN_DYNVARS_25_01-------------------------#'
9
SET GLOBAL delayed_insert_limit = 14;
10
INSERT INTO t1 VALUES('1','1','1');
11
INSERT INTO t1 VALUES('2','1','1');
12
INSERT INTO t1 VALUES('3','1','1');
13
INSERT INTO t1 VALUES('4','1','1');
14
INSERT INTO t1 VALUES('5','1','1');
15
INSERT INTO t1 VALUES('6','1','1');
18
INSERT DELAYED INTO t1 VALUES('7','1','1');
19
INSERT DELAYED INTO t1 VALUES('8','1','1');
20
INSERT DELAYED INTO t1 VALUES('9','1','1');
21
INSERT DELAYED INTO t1 VALUES('10','1','1');
22
INSERT DELAYED INTO t1 VALUES('11','1','1');
23
INSERT DELAYED INTO t1 VALUES('12','1','1');
24
INSERT DELAYED INTO t1 VALUES('13','1','1');
25
INSERT DELAYED INTO t1 VALUES('14','1','1');
26
INSERT DELAYED INTO t1 VALUES('15','1','1');
27
INSERT DELAYED INTO t1 VALUES('16','1','1');
28
INSERT DELAYED INTO t1 VALUES('17','1','1');
29
INSERT DELAYED INTO t1 VALUES('18','1','1');
30
INSERT DELAYED INTO t1 VALUES('19','1','1');
31
INSERT DELAYED INTO t1 VALUES('20','1','1');
32
INSERT DELAYED INTO t1 VALUES('21','1','1');
33
INSERT DELAYED INTO t1 VALUES('22','1','1');
34
INSERT DELAYED INTO t1 VALUES('23','1','1');
35
INSERT DELAYED INTO t1 VALUES('24','1','1');
36
INSERT DELAYED INTO t1 VALUES('25','1','1');
37
INSERT DELAYED INTO t1 VALUES('26','1','1');
38
INSERT DELAYED INTO t1 VALUES('27','1','1');
39
INSERT DELAYED INTO t1 VALUES('28','1','1');
40
INSERT DELAYED INTO t1 VALUES('29','1','1');
41
INSERT DELAYED INTO t1 VALUES('30','1','1');
42
INSERT DELAYED INTO t1 VALUES('31','1','1');
43
INSERT DELAYED INTO t1 VALUES('32','1','1');
44
INSERT DELAYED INTO t1 VALUES('33','1','1');
45
INSERT DELAYED INTO t1 VALUES('34','1','1');
46
INSERT DELAYED INTO t1 VALUES('35','1','1');
47
INSERT DELAYED INTO t1 VALUES('36','1','1');
48
INSERT DELAYED INTO t1 VALUES('37','1','1');
49
INSERT DELAYED INTO t1 VALUES('38','1','1');
50
INSERT DELAYED INTO t1 VALUES('39','1','1');
51
INSERT DELAYED INTO t1 VALUES('40','1','1');
52
INSERT DELAYED INTO t1 VALUES('41','1','1');
53
INSERT DELAYED INTO t1 VALUES('42','1','1');
54
INSERT DELAYED INTO t1 VALUES('43','1','1');|
56
SELECT COUNT(*) FROM t1;
57
** Connection default **
58
** Wait till con0 is blocked **
61
Asynchronous "reap" result
63
Asynchronous "reap" result
64
The next result suffers from
65
'# Bug#35386 insert delayed inserts 1 + limit rows instead of just limit rows'
68
** Connection default **
69
Checking if the delayed insert continued afterwards
70
SELECT COUNT(*) FROM t1;
75
'#--------------------FN_DYNVARS_25_02-------------------------#'
76
CREATE TABLE t1 (a VARCHAR(100));
77
CREATE VIEW v1 AS SELECT * FROM t1;
78
SET GLOBAL delayed_insert_limit = 20;
79
INSERT INTO t1 VALUES('1');
80
INSERT INTO t1 VALUES('2');
81
INSERT INTO t1 VALUES('3');
82
INSERT INTO t1 VALUES('4');
83
INSERT INTO t1 VALUES('5');
84
INSERT INTO t1 VALUES('6');
88
INSERT DELAYED INTO t1 VALUES('7');
89
INSERT DELAYED INTO t1 VALUES('8');
90
INSERT DELAYED INTO t1 VALUES('9');
91
INSERT DELAYED INTO t1 VALUES('10');
92
INSERT DELAYED INTO t1 VALUES('11');
93
INSERT DELAYED INTO t1 VALUES('12');
94
INSERT DELAYED INTO t1 VALUES('13');
95
INSERT DELAYED INTO t1 VALUES('14');
96
INSERT DELAYED INTO t1 VALUES('15');
97
INSERT DELAYED INTO t1 VALUES('16');
98
INSERT DELAYED INTO t1 VALUES('17');
99
INSERT DELAYED INTO t1 VALUES('18');
100
INSERT DELAYED INTO t1 VALUES('19');
101
INSERT DELAYED INTO t1 VALUES('20');
102
INSERT DELAYED INTO t1 VALUES('21');
103
INSERT DELAYED INTO t1 VALUES('22');|
104
** Connection con0 **
106
SELECT COUNT(*) BETWEEN 6 AND 22 FROM t1;
107
** Connection default **
108
** Wait till con0 is blocked **
110
** Connection con1 **
111
** Connection con0 **
112
Asynchronous "reap" result
113
COUNT(*) BETWEEN 6 AND 22
115
** Connection default**
116
Checking if the delayed insert gives the same result afterwards
117
SELECT COUNT(*) BETWEEN 6 AND 22 FROM t1;
118
COUNT(*) BETWEEN 6 AND 22
120
** Connection default**
123
SET @@GLOBAL.delayed_insert_limit = @global_delayed_insert_limit;
124
Disconnecting from con1, con0