Debian Codegraph @

mysql-test/suite/sys_vars/r/delayed_insert_limit_func.result

raw
1 ** Setup **
2
3 connect con0,localhost,root,,;
4 connect con1,localhost,root,,;
5 connection default;
6 SET @global_delayed_insert_limit = @@GLOBAL.delayed_insert_limit;
7 CREATE TABLE t1 (a VARCHAR(100),b VARCHAR(100),c VARCHAR(100));
8 CREATE VIEW v1 as select * from t1;
9 '#--------------------FN_DYNVARS_25_01-------------------------#'
10 SET GLOBAL delayed_insert_limit = 14;
11 INSERT INTO t1 VALUES('1','1','1');
12 INSERT INTO t1 VALUES('2','1','1');
13 INSERT INTO t1 VALUES('3','1','1');
14 INSERT INTO t1 VALUES('4','1','1');
15 INSERT INTO t1 VALUES('5','1','1');
16 INSERT INTO t1 VALUES('6','1','1');
17 LOCK TABLE v1 READ;
18 connection con1;
19 INSERT DELAYED INTO t1 VALUES('7','1','1');
20 INSERT DELAYED INTO t1 VALUES('8','1','1');
21 INSERT DELAYED INTO t1 VALUES('9','1','1');
22 INSERT DELAYED INTO t1 VALUES('10','1','1');
23 INSERT DELAYED INTO t1 VALUES('11','1','1');
24 INSERT DELAYED INTO t1 VALUES('12','1','1');
25 INSERT DELAYED INTO t1 VALUES('13','1','1');
26 INSERT DELAYED INTO t1 VALUES('14','1','1');
27 INSERT DELAYED INTO t1 VALUES('15','1','1');
28 INSERT DELAYED INTO t1 VALUES('16','1','1');
29 INSERT DELAYED INTO t1 VALUES('17','1','1');
30 INSERT DELAYED INTO t1 VALUES('18','1','1');
31 INSERT DELAYED INTO t1 VALUES('19','1','1');
32 INSERT DELAYED INTO t1 VALUES('20','1','1');
33 INSERT DELAYED INTO t1 VALUES('21','1','1');
34 INSERT DELAYED INTO t1 VALUES('22','1','1');
35 INSERT DELAYED INTO t1 VALUES('23','1','1');
36 INSERT DELAYED INTO t1 VALUES('24','1','1');
37 INSERT DELAYED INTO t1 VALUES('25','1','1');
38 INSERT DELAYED INTO t1 VALUES('26','1','1');
39 INSERT DELAYED INTO t1 VALUES('27','1','1');
40 INSERT DELAYED INTO t1 VALUES('28','1','1');
41 INSERT DELAYED INTO t1 VALUES('29','1','1');
42 INSERT DELAYED INTO t1 VALUES('30','1','1');
43 INSERT DELAYED INTO t1 VALUES('31','1','1');
44 INSERT DELAYED INTO t1 VALUES('32','1','1');
45 INSERT DELAYED INTO t1 VALUES('33','1','1');
46 INSERT DELAYED INTO t1 VALUES('34','1','1');
47 INSERT DELAYED INTO t1 VALUES('35','1','1');
48 INSERT DELAYED INTO t1 VALUES('36','1','1');
49 INSERT DELAYED INTO t1 VALUES('37','1','1');
50 INSERT DELAYED INTO t1 VALUES('38','1','1');
51 INSERT DELAYED INTO t1 VALUES('39','1','1');
52 INSERT DELAYED INTO t1 VALUES('40','1','1');
53 INSERT DELAYED INTO t1 VALUES('41','1','1');
54 INSERT DELAYED INTO t1 VALUES('42','1','1');
55 INSERT DELAYED INTO t1 VALUES('43','1','1');
56 connection con0;
57 SELECT COUNT(*) FROM t1;
58 connection default;
59 ** Wait till con0 is blocked **
60 UNLOCK TABLES;
61 connection con0;
62 Asynchronous "reap" result
63 The next result suffers from
64 '# Bug#35386 insert delayed inserts 1 + limit rows instead of just limit rows'
65 COUNT(*)
66 21
67 connection default;
68 Checking if the delayed insert continued afterwards
69 SELECT COUNT(*) FROM t1;
70 COUNT(*)
71 43
72 DROP TABLE t1;
73 DROP VIEW v1;
74 '#--------------------FN_DYNVARS_25_02-------------------------#'
75 CREATE TABLE t1 (a VARCHAR(100));
76 CREATE VIEW v1 AS SELECT * FROM t1;
77 SET GLOBAL delayed_insert_limit = 20;
78 INSERT INTO t1 VALUES('1');
79 INSERT INTO t1 VALUES('2');
80 INSERT INTO t1 VALUES('3');
81 INSERT INTO t1 VALUES('4');
82 INSERT INTO t1 VALUES('5');
83 INSERT INTO t1 VALUES('6');
84 LOCK TABLE v1 READ;
85 connection con1;
86 INSERT DELAYED INTO t1 VALUES('7');
87 INSERT DELAYED INTO t1 VALUES('8');
88 INSERT DELAYED INTO t1 VALUES('9');
89 INSERT DELAYED INTO t1 VALUES('10');
90 INSERT DELAYED INTO t1 VALUES('11');
91 INSERT DELAYED INTO t1 VALUES('12');
92 INSERT DELAYED INTO t1 VALUES('13');
93 INSERT DELAYED INTO t1 VALUES('14');
94 INSERT DELAYED INTO t1 VALUES('15');
95 INSERT DELAYED INTO t1 VALUES('16');
96 INSERT DELAYED INTO t1 VALUES('17');
97 INSERT DELAYED INTO t1 VALUES('18');
98 INSERT DELAYED INTO t1 VALUES('19');
99 INSERT DELAYED INTO t1 VALUES('20');
100 INSERT DELAYED INTO t1 VALUES('21');
101 INSERT DELAYED INTO t1 VALUES('22');
102 connection con0;
103 Asynchronous execute
104 SELECT COUNT(*) FROM t1;
105 connection default;
106 ** Wait till con0 is blocked **
107 UNLOCK TABLES;
108 connection con0;
109 Asynchronous "reap" result
110 COUNT(*)
111 22
112 connection default;
113 Checking if the delayed insert gives the same result afterwards
114 SELECT COUNT(*) FROM t1;
115 COUNT(*)
116 22
117 connection default;
118 DROP TABLE t1;
119 DROP VIEW v1;
120 SET @@GLOBAL.delayed_insert_limit = @global_delayed_insert_limit;
121 disconnect con0;
122 disconnect con1;