diff options
Diffstat (limited to 'mysql-test/suite/binlog/r/binlog_stm_binlog.result')
| -rw-r--r-- | mysql-test/suite/binlog/r/binlog_stm_binlog.result | 512 |
1 files changed, 110 insertions, 402 deletions
diff --git a/mysql-test/suite/binlog/r/binlog_stm_binlog.result b/mysql-test/suite/binlog/r/binlog_stm_binlog.result index 1a05a930e2c..062f4f4e906 100644 --- a/mysql-test/suite/binlog/r/binlog_stm_binlog.result +++ b/mysql-test/suite/binlog/r/binlog_stm_binlog.result @@ -168,411 +168,119 @@ master-bin.000001 # Query # # use `test`; DROP TABLE `t1` /* generated by server set @bcs = @@binlog_cache_size; set global binlog_cache_size=4096; reset master; -create table t1 (a int) engine=innodb; +create table t1 (a int, b char(255)) engine=innodb; +flush status; +show status like "binlog_cache_use"; +Variable_name Value +Binlog_cache_use 0 +*** the following must show the counter value = 1 *** +Variable_name Value +Binlog_cache_use 1 show binlog events from <binlog_start>; Log_name Pos Event_type Server_id End_log_pos Info -master-bin.000001 # Query # # use `test`; create table t1 (a int) engine=innodb +master-bin.000001 # Query # # use `test`; create table t1 (a int, b char(255)) engine=innodb +master-bin.000001 # Query # # use `test`; flush status master-bin.000001 # Query # # BEGIN -master-bin.000001 # Query # # use `test`; insert into t1 values( 400 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 399 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 398 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 397 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 396 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 395 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 394 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 393 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 392 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 391 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 390 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 389 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 388 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 387 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 386 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 385 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 384 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 383 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 382 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 381 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 380 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 379 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 378 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 377 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 376 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 375 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 374 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 373 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 372 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 371 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 370 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 369 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 368 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 367 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 366 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 365 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 364 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 363 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 362 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 361 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 360 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 359 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 358 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 357 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 356 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 355 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 354 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 353 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 352 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 351 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 350 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 349 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 348 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 347 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 346 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 345 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 344 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 343 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 342 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 341 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 340 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 339 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 338 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 337 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 336 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 335 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 334 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 333 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 332 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 331 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 330 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 329 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 328 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 327 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 326 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 325 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 324 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 323 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 322 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 321 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 320 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 319 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 318 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 317 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 316 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 315 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 314 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 313 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 312 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 311 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 310 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 309 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 308 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 307 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 306 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 305 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 304 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 303 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 302 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 301 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 300 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 299 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 298 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 297 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 296 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 295 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 294 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 293 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 292 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 291 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 290 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 289 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 288 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 287 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 286 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 285 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 284 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 283 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 282 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 281 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 280 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 279 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 278 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 277 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 276 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 275 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 274 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 273 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 272 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 271 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 270 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 269 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 268 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 267 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 266 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 265 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 264 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 263 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 262 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 261 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 260 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 259 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 258 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 257 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 256 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 255 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 254 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 253 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 252 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 251 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 250 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 249 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 248 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 247 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 246 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 245 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 244 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 243 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 242 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 241 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 240 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 239 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 238 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 237 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 236 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 235 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 234 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 233 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 232 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 231 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 230 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 229 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 228 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 227 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 226 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 225 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 224 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 223 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 222 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 221 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 220 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 219 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 218 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 217 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 216 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 215 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 214 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 213 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 212 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 211 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 210 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 209 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 208 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 207 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 206 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 205 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 204 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 203 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 202 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 201 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 200 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 199 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 198 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 197 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 196 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 195 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 194 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 193 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 192 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 191 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 190 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 189 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 188 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 187 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 186 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 185 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 184 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 183 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 182 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 181 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 180 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 179 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 178 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 177 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 176 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 175 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 174 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 173 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 172 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 171 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 170 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 169 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 168 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 167 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 166 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 165 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 164 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 163 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 162 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 161 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 160 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 159 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 158 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 157 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 156 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 155 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 154 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 153 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 152 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 151 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 150 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 149 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 148 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 147 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 146 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 145 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 144 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 143 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 142 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 141 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 140 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 139 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 138 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 137 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 136 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 135 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 134 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 133 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 132 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 131 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 130 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 129 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 128 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 127 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 126 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 125 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 124 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 123 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 122 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 121 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 120 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 119 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 118 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 117 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 116 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 115 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 114 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 113 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 112 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 111 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 110 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 109 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 108 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( <binlog_start> ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 106 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 105 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 104 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 103 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 102 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 101 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 100 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 99 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 98 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 97 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 96 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 95 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 94 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 93 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 92 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 91 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 90 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 89 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 88 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 87 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 86 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 85 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 84 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 83 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 82 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 81 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 80 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 79 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 78 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 77 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 76 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 75 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 74 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 73 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 72 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 71 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 70 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 69 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 68 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 67 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 66 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 65 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 64 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 63 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 62 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 61 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 60 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 59 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 58 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 57 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 56 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 55 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 54 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 53 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 52 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 51 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 50 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 49 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 48 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 47 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 46 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 45 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 44 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 43 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 42 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 41 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 40 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 39 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 38 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 37 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 36 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 35 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 34 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 33 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 32 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 31 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 30 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 29 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 28 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 27 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 26 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 25 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 24 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 23 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 22 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 21 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 20 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 19 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 18 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 17 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 16 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 15 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 14 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 13 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 12 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 11 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 10 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 9 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 8 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 7 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 6 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 5 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 4 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 3 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 2 ) -master-bin.000001 # Query # # use `test`; insert into t1 values( 1 ) +master-bin.000001 # Query # # use `test`; insert into t1 values( 100, 'just to fill void to make transaction occupying at least two buffers of the trans cache' ) +master-bin.000001 # Query # # use `test`; insert into t1 values( 99, 'just to fill void to make transaction occupying at least two buffers of the trans cache' ) +master-bin.000001 # Query # # use `test`; insert into t1 values( 98, 'just to fill void to make transaction occupying at least two buffers of the trans cache' ) +master-bin.000001 # Query # # use `test`; insert into t1 values( 97, 'just to fill void to make transaction occupying at least two buffers of the trans cache' ) +master-bin.000001 # Query # # use `test`; insert into t1 values( 96, 'just to fill void to make transaction occupying at least two buffers of the trans cache' ) +master-bin.000001 # Query # # use `test`; insert into t1 values( 95, 'just to fill void to make transaction occupying at least two buffers of the trans cache' ) +master-bin.000001 # Query # # use `test`; insert into t1 values( 94, 'just to fill void to make transaction occupying at least two buffers of the trans cache' ) +master-bin.000001 # Query # # use `test`; insert into t1 values( 93, 'just to fill void to make transaction occupying at least two buffers of the trans cache' ) +master-bin.000001 # Query # # use `test`; insert into t1 values( 92, 'just to fill void to make transaction occupying at least two buffers of the trans cache' ) +master-bin.000001 # Query # # use `test`; insert into t1 values( 91, 'just to fill void to make transaction occupying at least two buffers of the trans cache' ) +master-bin.000001 # Query # # use `test`; insert into t1 values( 90, 'just to fill void to make transaction occupying at least two buffers of the trans cache' ) +master-bin.000001 # Query # # use `test`; insert into t1 values( 89, 'just to fill void to make transaction occupying at least two buffers of the trans cache' ) +master-bin.000001 # Query # # use `test`; insert into t1 values( 88, 'just to fill void to make transaction occupying at least two buffers of the trans cache' ) +master-bin.000001 # Query # # use `test`; insert into t1 values( 87, 'just to fill void to make transaction occupying at least two buffers of the trans cache' ) +master-bin.000001 # Query # # use `test`; insert into t1 values( 86, 'just to fill void to make transaction occupying at least two buffers of the trans cache' ) +master-bin.000001 # Query # # use `test`; insert into t1 values( 85, 'just to fill void to make transaction occupying at least two buffers of the trans cache' ) +master-bin.000001 # Query # # use `test`; insert into t1 values( 84, 'just to fill void to make transaction occupying at least two buffers of the trans cache' ) +master-bin.000001 # Query # # use `test`; insert into t1 values( 83, 'just to fill void to make transaction occupying at least two buffers of the trans cache' ) +master-bin.000001 # Query # # use `test`; insert into t1 values( 82, 'just to fill void to make transaction occupying at least two buffers of the trans cache' ) +master-bin.000001 # Query # # use `test`; insert into t1 values( 81, 'just to fill void to make transaction occupying at least two buffers of the trans cache' ) +master-bin.000001 # Query # # use `test`; insert into t1 values( 80, 'just to fill void to make transaction occupying at least two buffers of the trans cache' ) +master-bin.000001 # Query # # use `test`; insert into t1 values( 79, 'just to fill void to make transaction occupying at least two buffers of the trans cache' ) +master-bin.000001 # Query # # use `test`; insert into t1 values( 78, 'just to fill void to make transaction occupying at least two buffers of the trans cache' ) +master-bin.000001 # Query # # use `test`; insert into t1 values( 77, 'just to fill void to make transaction occupying at least two buffers of the trans cache' ) +master-bin.000001 # Query # # use `test`; insert into t1 values( 76, 'just to fill void to make transaction occupying at least two buffers of the trans cache' ) +master-bin.000001 # Query # # use `test`; insert into t1 values( 75, 'just to fill void to make transaction occupying at least two buffers of the trans cache' ) +master-bin.000001 # Query # # use `test`; insert into t1 values( 74, 'just to fill void to make transaction occupying at least two buffers of the trans cache' ) +master-bin.000001 # Query # # use `test`; insert into t1 values( 73, 'just to fill void to make transaction occupying at least two buffers of the trans cache' ) +master-bin.000001 # Query # # use `test`; insert into t1 values( 72, 'just to fill void to make transaction occupying at least two buffers of the trans cache' ) +master-bin.000001 # Query # # use `test`; insert into t1 values( 71, 'just to fill void to make transaction occupying at least two buffers of the trans cache' ) +master-bin.000001 # Query # # use `test`; insert into t1 values( 70, 'just to fill void to make transaction occupying at least two buffers of the trans cache' ) +master-bin.000001 # Query # # use `test`; insert into t1 values( 69, 'just to fill void to make transaction occupying at least two buffers of the trans cache' ) +master-bin.000001 # Query # # use `test`; insert into t1 values( 68, 'just to fill void to make transaction occupying at least two buffers of the trans cache' ) +master-bin.000001 # Query # # use `test`; insert into t1 values( 67, 'just to fill void to make transaction occupying at least two buffers of the trans cache' ) +master-bin.000001 # Query # # use `test`; insert into t1 values( 66, 'just to fill void to make transaction occupying at least two buffers of the trans cache' ) +master-bin.000001 # Query # # use `test`; insert into t1 values( 65, 'just to fill void to make transaction occupying at least two buffers of the trans cache' ) +master-bin.000001 # Query # # use `test`; insert into t1 values( 64, 'just to fill void to make transaction occupying at least two buffers of the trans cache' ) +master-bin.000001 # Query # # use `test`; insert into t1 values( 63, 'just to fill void to make transaction occupying at least two buffers of the trans cache' ) +master-bin.000001 # Query # # use `test`; insert into t1 values( 62, 'just to fill void to make transaction occupying at least two buffers of the trans cache' ) +master-bin.000001 # Query # # use `test`; insert into t1 values( 61, 'just to fill void to make transaction occupying at least two buffers of the trans cache' ) +master-bin.000001 # Query # # use `test`; insert into t1 values( 60, 'just to fill void to make transaction occupying at least two buffers of the trans cache' ) +master-bin.000001 # Query # # use `test`; insert into t1 values( 59, 'just to fill void to make transaction occupying at least two buffers of the trans cache' ) +master-bin.000001 # Query # # use `test`; insert into t1 values( 58, 'just to fill void to make transaction occupying at least two buffers of the trans cache' ) +master-bin.000001 # Query # # use `test`; insert into t1 values( 57, 'just to fill void to make transaction occupying at least two buffers of the trans cache' ) +master-bin.000001 # Query # # use `test`; insert into t1 values( 56, 'just to fill void to make transaction occupying at least two buffers of the trans cache' ) +master-bin.000001 # Query # # use `test`; insert into t1 values( 55, 'just to fill void to make transaction occupying at least two buffers of the trans cache' ) +master-bin.000001 # Query # # use `test`; insert into t1 values( 54, 'just to fill void to make transaction occupying at least two buffers of the trans cache' ) +master-bin.000001 # Query # # use `test`; insert into t1 values( 53, 'just to fill void to make transaction occupying at least two buffers of the trans cache' ) +master-bin.000001 # Query # # use `test`; insert into t1 values( 52, 'just to fill void to make transaction occupying at least two buffers of the trans cache' ) +master-bin.000001 # Query # # use `test`; insert into t1 values( 51, 'just to fill void to make transaction occupying at least two buffers of the trans cache' ) +master-bin.000001 # Query # # use `test`; insert into t1 values( 50, 'just to fill void to make transaction occupying at least two buffers of the trans cache' ) +master-bin.000001 # Query # # use `test`; insert into t1 values( 49, 'just to fill void to make transaction occupying at least two buffers of the trans cache' ) +master-bin.000001 # Query # # use `test`; insert into t1 values( 48, 'just to fill void to make transaction occupying at least two buffers of the trans cache' ) +master-bin.000001 # Query # # use `test`; insert into t1 values( 47, 'just to fill void to make transaction occupying at least two buffers of the trans cache' ) +master-bin.000001 # Query # # use `test`; insert into t1 values( 46, 'just to fill void to make transaction occupying at least two buffers of the trans cache' ) +master-bin.000001 # Query # # use `test`; insert into t1 values( 45, 'just to fill void to make transaction occupying at least two buffers of the trans cache' ) +master-bin.000001 # Query # # use `test`; insert into t1 values( 44, 'just to fill void to make transaction occupying at least two buffers of the trans cache' ) +master-bin.000001 # Query # # use `test`; insert into t1 values( 43, 'just to fill void to make transaction occupying at least two buffers of the trans cache' ) +master-bin.000001 # Query # # use `test`; insert into t1 values( 42, 'just to fill void to make transaction occupying at least two buffers of the trans cache' ) +master-bin.000001 # Query # # use `test`; insert into t1 values( 41, 'just to fill void to make transaction occupying at least two buffers of the trans cache' ) +master-bin.000001 # Query # # use `test`; insert into t1 values( 40, 'just to fill void to make transaction occupying at least two buffers of the trans cache' ) +master-bin.000001 # Query # # use `test`; insert into t1 values( 39, 'just to fill void to make transaction occupying at least two buffers of the trans cache' ) +master-bin.000001 # Query # # use `test`; insert into t1 values( 38, 'just to fill void to make transaction occupying at least two buffers of the trans cache' ) +master-bin.000001 # Query # # use `test`; insert into t1 values( 37, 'just to fill void to make transaction occupying at least two buffers of the trans cache' ) +master-bin.000001 # Query # # use `test`; insert into t1 values( 36, 'just to fill void to make transaction occupying at least two buffers of the trans cache' ) +master-bin.000001 # Query # # use `test`; insert into t1 values( 35, 'just to fill void to make transaction occupying at least two buffers of the trans cache' ) +master-bin.000001 # Query # # use `test`; insert into t1 values( 34, 'just to fill void to make transaction occupying at least two buffers of the trans cache' ) +master-bin.000001 # Query # # use `test`; insert into t1 values( 33, 'just to fill void to make transaction occupying at least two buffers of the trans cache' ) +master-bin.000001 # Query # # use `test`; insert into t1 values( 32, 'just to fill void to make transaction occupying at least two buffers of the trans cache' ) +master-bin.000001 # Query # # use `test`; insert into t1 values( 31, 'just to fill void to make transaction occupying at least two buffers of the trans cache' ) +master-bin.000001 # Query # # use `test`; insert into t1 values( 30, 'just to fill void to make transaction occupying at least two buffers of the trans cache' ) +master-bin.000001 # Query # # use `test`; insert into t1 values( 29, 'just to fill void to make transaction occupying at least two buffers of the trans cache' ) +master-bin.000001 # Query # # use `test`; insert into t1 values( 28, 'just to fill void to make transaction occupying at least two buffers of the trans cache' ) +master-bin.000001 # Query # # use `test`; insert into t1 values( 27, 'just to fill void to make transaction occupying at least two buffers of the trans cache' ) +master-bin.000001 # Query # # use `test`; insert into t1 values( 26, 'just to fill void to make transaction occupying at least two buffers of the trans cache' ) +master-bin.000001 # Query # # use `test`; insert into t1 values( 25, 'just to fill void to make transaction occupying at least two buffers of the trans cache' ) +master-bin.000001 # Query # # use `test`; insert into t1 values( 24, 'just to fill void to make transaction occupying at least two buffers of the trans cache' ) +master-bin.000001 # Query # # use `test`; insert into t1 values( 23, 'just to fill void to make transaction occupying at least two buffers of the trans cache' ) +master-bin.000001 # Query # # use `test`; insert into t1 values( 22, 'just to fill void to make transaction occupying at least two buffers of the trans cache' ) +master-bin.000001 # Query # # use `test`; insert into t1 values( 21, 'just to fill void to make transaction occupying at least two buffers of the trans cache' ) +master-bin.000001 # Query # # use `test`; insert into t1 values( 20, 'just to fill void to make transaction occupying at least two buffers of the trans cache' ) +master-bin.000001 # Query # # use `test`; insert into t1 values( 19, 'just to fill void to make transaction occupying at least two buffers of the trans cache' ) +master-bin.000001 # Query # # use `test`; insert into t1 values( 18, 'just to fill void to make transaction occupying at least two buffers of the trans cache' ) +master-bin.000001 # Query # # use `test`; insert into t1 values( 17, 'just to fill void to make transaction occupying at least two buffers of the trans cache' ) +master-bin.000001 # Query # # use `test`; insert into t1 values( 16, 'just to fill void to make transaction occupying at least two buffers of the trans cache' ) +master-bin.000001 # Query # # use `test`; insert into t1 values( 15, 'just to fill void to make transaction occupying at least two buffers of the trans cache' ) +master-bin.000001 # Query # # use `test`; insert into t1 values( 14, 'just to fill void to make transaction occupying at least two buffers of the trans cache' ) +master-bin.000001 # Query # # use `test`; insert into t1 values( 13, 'just to fill void to make transaction occupying at least two buffers of the trans cache' ) +master-bin.000001 # Query # # use `test`; insert into t1 values( 12, 'just to fill void to make transaction occupying at least two buffers of the trans cache' ) +master-bin.000001 # Query # # use `test`; insert into t1 values( 11, 'just to fill void to make transaction occupying at least two buffers of the trans cache' ) +master-bin.000001 # Query # # use `test`; insert into t1 values( 10, 'just to fill void to make transaction occupying at least two buffers of the trans cache' ) +master-bin.000001 # Query # # use `test`; insert into t1 values( 9, 'just to fill void to make transaction occupying at least two buffers of the trans cache' ) +master-bin.000001 # Query # # use `test`; insert into t1 values( 8, 'just to fill void to make transaction occupying at least two buffers of the trans cache' ) +master-bin.000001 # Query # # use `test`; insert into t1 values( 7, 'just to fill void to make transaction occupying at least two buffers of the trans cache' ) +master-bin.000001 # Query # # use `test`; insert into t1 values( 6, 'just to fill void to make transaction occupying at least two buffers of the trans cache' ) +master-bin.000001 # Query # # use `test`; insert into t1 values( 5, 'just to fill void to make transaction occupying at least two buffers of the trans cache' ) +master-bin.000001 # Query # # use `test`; insert into t1 values( 4, 'just to fill void to make transaction occupying at least two buffers of the trans cache' ) +master-bin.000001 # Query # # use `test`; insert into t1 values( 3, 'just to fill void to make transaction occupying at least two buffers of the trans cache' ) +master-bin.000001 # Query # # use `test`; insert into t1 values( 2, 'just to fill void to make transaction occupying at least two buffers of the trans cache' ) +master-bin.000001 # Query # # use `test`; insert into t1 values( 1, 'just to fill void to make transaction occupying at least two buffers of the trans cache' ) master-bin.000001 # Xid # # COMMIT /* XID */ master-bin.000001 # Rotate # # master-bin.000002;pos=4 drop table t1; |