2
# BUG#42749: infinite loop writing to row based binlog - processlist shows
8
# This bug would make table map event to report data_written one byte less
9
# than what would actually be written in its body. This would cause one byte shorter
10
# event end_log_pos. The ultimate impact was that it would make fixing the
11
# position in MYSQL_BIN_LOG::write_cache bogus or end up in an infinite loop.
16
# Checking that the patch fixes the problem is done as follows:
17
# i) a table with several fields is created;
18
# ii) an insert is performed;
19
# iii) the logs are flushed;
20
# iv) mysqlbinlog is used to check if it succeeds.
22
# In step iv), before the bug was fixed, the test case would fail with
23
# mysqlbinlog reporting that it was unable to succeed in reading the event.
29
DROP TABLE IF EXISTS `t1`;
32
`c1` int(11) NOT NULL AUTO_INCREMENT,
33
`c2` varchar(30) NOT NULL,
34
`c3` varchar(30) DEFAULT NULL,
35
`c4` varchar(30) DEFAULT NULL,
36
`c5` varchar(30) DEFAULT NULL,
37
`c6` varchar(30) DEFAULT NULL,
38
`c7` varchar(30) DEFAULT NULL,
39
`c8` varchar(30) DEFAULT NULL,
40
`c9` varchar(30) DEFAULT NULL,
41
`c10` varchar(30) DEFAULT NULL,
42
`c11` varchar(30) DEFAULT NULL,
43
`c12` varchar(30) DEFAULT NULL,
44
`c13` varchar(30) DEFAULT NULL,
45
`c14` varchar(30) DEFAULT NULL,
46
`c15` varchar(30) DEFAULT NULL,
47
`c16` varchar(30) DEFAULT NULL,
48
`c17` varchar(30) DEFAULT NULL,
49
`c18` varchar(30) DEFAULT NULL,
50
`c19` varchar(30) DEFAULT NULL,
51
`c20` varchar(30) DEFAULT NULL,
52
`c21` varchar(30) DEFAULT NULL,
53
`c22` varchar(30) DEFAULT NULL,
54
`c23` varchar(30) DEFAULT NULL,
55
`c24` varchar(30) DEFAULT NULL,
56
`c25` varchar(30) DEFAULT NULL,
57
`c26` varchar(30) DEFAULT NULL,
58
`c27` varchar(30) DEFAULT NULL,
59
`c28` varchar(30) DEFAULT NULL,
60
`c29` varchar(30) DEFAULT NULL,
61
`c30` varchar(30) DEFAULT NULL,
62
`c31` varchar(30) DEFAULT NULL,
63
`c32` varchar(30) DEFAULT NULL,
64
`c33` varchar(30) DEFAULT NULL,
65
`c34` varchar(30) DEFAULT NULL,
66
`c35` varchar(30) DEFAULT NULL,
67
`c36` varchar(30) DEFAULT NULL,
68
`c37` varchar(30) DEFAULT NULL,
69
`c38` varchar(30) DEFAULT NULL,
70
`c39` varchar(30) DEFAULT NULL,
71
`c40` varchar(30) DEFAULT NULL,
72
`c41` varchar(30) DEFAULT NULL,
73
`c42` varchar(30) DEFAULT NULL,
74
`c43` varchar(30) DEFAULT NULL,
75
`c44` varchar(30) DEFAULT NULL,
76
`c45` varchar(30) DEFAULT NULL,
77
`c46` varchar(30) DEFAULT NULL,
78
`c47` varchar(30) DEFAULT NULL,
79
`c48` varchar(30) DEFAULT NULL,
80
`c49` varchar(30) DEFAULT NULL,
81
`c50` varchar(30) DEFAULT NULL,
82
`c51` varchar(30) DEFAULT NULL,
83
`c52` varchar(30) DEFAULT NULL,
84
`c53` varchar(30) DEFAULT NULL,
85
`c54` varchar(30) DEFAULT NULL,
86
`c55` varchar(30) DEFAULT NULL,
87
`c56` varchar(30) DEFAULT NULL,
88
`c57` varchar(30) DEFAULT NULL,
89
`c58` varchar(30) DEFAULT NULL,
90
`c59` varchar(30) DEFAULT NULL,
91
`c60` varchar(30) DEFAULT NULL,
92
`c61` varchar(30) DEFAULT NULL,
93
`c62` varchar(30) DEFAULT NULL,
94
`c63` varchar(30) DEFAULT NULL,
95
`c64` varchar(30) DEFAULT NULL,
96
`c65` varchar(30) DEFAULT NULL,
97
`c66` varchar(30) DEFAULT NULL,
98
`c67` varchar(30) DEFAULT NULL,
99
`c68` varchar(30) DEFAULT NULL,
100
`c69` varchar(30) DEFAULT NULL,
101
`c70` varchar(30) DEFAULT NULL,
102
`c71` varchar(30) DEFAULT NULL,
103
`c72` varchar(30) DEFAULT NULL,
104
`c73` varchar(30) DEFAULT NULL,
105
`c74` varchar(30) DEFAULT NULL,
106
`c75` varchar(30) DEFAULT NULL,
107
`c76` varchar(30) DEFAULT NULL,
108
`c77` varchar(30) DEFAULT NULL,
109
`c78` varchar(30) DEFAULT NULL,
110
`c79` varchar(30) DEFAULT NULL,
111
`c80` varchar(30) DEFAULT NULL,
112
`c81` varchar(30) DEFAULT NULL,
113
`c82` varchar(30) DEFAULT NULL,
114
`c83` varchar(30) DEFAULT NULL,
115
`c84` varchar(30) DEFAULT NULL,
116
`c85` varchar(30) DEFAULT NULL,
117
`c86` varchar(30) DEFAULT NULL,
118
`c87` varchar(30) DEFAULT NULL,
119
`c88` varchar(30) DEFAULT NULL,
120
`c89` varchar(30) DEFAULT NULL,
121
`c90` varchar(30) DEFAULT NULL,
122
`c91` varchar(30) DEFAULT NULL,
123
`c92` varchar(30) DEFAULT NULL,
124
`c93` varchar(30) DEFAULT NULL,
125
`c94` varchar(30) DEFAULT NULL,
126
`c95` varchar(30) DEFAULT NULL,
127
`c96` varchar(30) DEFAULT NULL,
128
`c97` varchar(30) DEFAULT NULL,
129
`c98` varchar(30) DEFAULT NULL,
130
`c99` varchar(30) DEFAULT NULL,
131
`c100` varchar(30) DEFAULT NULL,
132
`c101` varchar(30) DEFAULT NULL,
133
`c102` varchar(30) DEFAULT NULL,
134
`c103` varchar(30) DEFAULT NULL,
135
`c104` varchar(30) DEFAULT NULL,
136
`c105` varchar(30) DEFAULT NULL,
137
`c106` varchar(30) DEFAULT NULL,
138
`c107` varchar(30) DEFAULT NULL,
139
`c108` varchar(30) DEFAULT NULL,
140
`c109` varchar(30) DEFAULT NULL,
141
`c110` varchar(30) DEFAULT NULL,
142
`c111` varchar(30) DEFAULT NULL,
143
`c112` varchar(30) DEFAULT NULL,
144
`c113` varchar(30) DEFAULT NULL,
145
`c114` varchar(30) DEFAULT NULL,
146
`c115` varchar(30) DEFAULT NULL,
147
`c116` varchar(30) DEFAULT NULL,
148
`c117` varchar(30) DEFAULT NULL,
149
`c118` varchar(30) DEFAULT NULL,
150
`c119` varchar(30) DEFAULT NULL,
151
`c120` varchar(30) DEFAULT NULL,
152
`c121` varchar(30) DEFAULT NULL,
153
`c122` varchar(30) DEFAULT NULL,
154
`c123` varchar(30) DEFAULT NULL,
155
`c124` varchar(30) DEFAULT NULL,
156
`c125` varchar(30) DEFAULT NULL,
157
`c126` varchar(30) DEFAULT NULL,
158
`c127` varchar(30) DEFAULT NULL,
159
`c128` varchar(30) DEFAULT NULL,
160
`c129` varchar(30) DEFAULT NULL,
161
`c130` varchar(30) DEFAULT NULL,
162
`c131` varchar(30) DEFAULT NULL,
163
`c132` varchar(30) DEFAULT NULL,
164
`c133` varchar(30) DEFAULT NULL,
165
`c134` varchar(30) DEFAULT NULL,
166
`c135` varchar(30) DEFAULT NULL,
167
`c136` varchar(30) DEFAULT NULL,
168
`c137` varchar(30) DEFAULT NULL,
169
`c138` varchar(30) DEFAULT NULL,
170
`c139` varchar(30) DEFAULT NULL,
171
`c140` varchar(30) DEFAULT NULL,
172
`c141` varchar(30) DEFAULT NULL,
173
`c142` varchar(30) DEFAULT NULL,
174
`c143` varchar(30) DEFAULT NULL,
175
`c144` varchar(30) DEFAULT NULL,
176
`c145` varchar(30) DEFAULT NULL,
177
`c146` varchar(30) DEFAULT NULL,
181
LOCK TABLES `t1` WRITE;
183
INSERT INTO `t1` VALUES ('1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1');