| 1 |
==== Read binlog with v2 row events ==== |
| 2 |
SELECT * FROM t1 ORDER BY a; |
| 3 |
a b |
| 4 |
0 last_insert_id |
| 5 |
1 one |
| 6 |
3 last stm in trx: next event should be xid |
| 7 |
4 four |
| 8 |
62046 random |
| 9 |
SELECT * FROM t2 ORDER BY a; |
| 10 |
a b |
| 11 |
3 first stm in trx |
| 12 |
SELECT COUNT(*) FROM t3; |
| 13 |
COUNT(*) |
| 14 |
17920 |
| 15 |
DROP TABLE t1, t2, t3; |
| 16 |
==== Read modern binlog (version 5.1.23) ==== |
| 17 |
SELECT * FROM t1 ORDER BY a; |
| 18 |
a b |
| 19 |
0 last_insert_id |
| 20 |
1 one |
| 21 |
3 last stm in trx: next event should be xid |
| 22 |
4 four |
| 23 |
674568 random |
| 24 |
SELECT * FROM t2 ORDER BY a; |
| 25 |
a b |
| 26 |
3 first stm in trx |
| 27 |
SELECT COUNT(*) FROM t3; |
| 28 |
COUNT(*) |
| 29 |
17920 |
| 30 |
DROP TABLE t1, t2, t3; |
| 31 |
*** wl#2540 Replication events checksum is not yet defined |
| 32 |
*** its born-version. One that is temporarily chosen conflicts with |
| 33 |
*** the version in the following pre-recorded binlogs |
| 34 |
*** TODO: uncomment this snippet when the WL patches will be about to push |
| 35 |
==== Read binlog from alcatel tree (mysql-5.1-wl2325-5.0-drop6) ==== |