MOON
Server: Apache/2.2.21 (Unix) mod_ssl/2.2.21 OpenSSL/0.9.8e-fips-rhel5 mod_auth_passthrough/2.1 mod_bwlimited/1.4
System: Linux vps.panamaemb.org.sg 3.10.0-1160.80.1.vz7.191.4 #1 SMP Thu Dec 15 20:31:06 MSK 2022 x86_64
User: panama (500)
PHP: 5.2.17
Disabled: NONE
Upload Files
File: //proc/2/task/2/root/usr/share/mysql-test/suite/binlog/r/binlog_old_versions.result
==== Read binlog with v2 row events ====
SELECT * FROM t1 ORDER BY a;
a	b
0	last_insert_id
1	one
3	last stm in trx: next event should be xid
4	four
62046	random
SELECT * FROM t2 ORDER BY a;
a	b
3	first stm in trx
SELECT COUNT(*) FROM t3;
COUNT(*)
17920
DROP TABLE t1, t2, t3;
==== Read modern binlog (version 5.1.23) ====
SELECT * FROM t1 ORDER BY a;
a	b
0	last_insert_id
1	one
3	last stm in trx: next event should be xid
4	four
674568	random
SELECT * FROM t2 ORDER BY a;
a	b
3	first stm in trx
SELECT COUNT(*) FROM t3;
COUNT(*)
17920
DROP TABLE t1, t2, t3;
==== Read binlog from version 5.1.17 ====
SELECT * FROM t1 ORDER BY a;
a	b
0	last_insert_id
1	one
3	last stm in trx: next event should be xid
4	four
764247	random
SELECT * FROM t2 ORDER BY a;
a	b
3	first stm in trx
SELECT COUNT(*) FROM t3;
COUNT(*)
17920
DROP TABLE t1, t2, t3;
==== Read binlog from version 4.1 ====
SELECT * FROM t1 ORDER BY a;
a	b
0	last_insert_id
4	four
190243	random
SELECT COUNT(*) FROM t3;
COUNT(*)
17920
DROP TABLE t1, t3;
*** wl#2540 Replication events checksum is not yet defined 
*** its born-version. One that is temporarily chosen conflicts with 
*** the version in the following pre-recorded binlogs
*** TODO: uncomment this snippet when the WL patches will be about to push
==== Read binlog from alcatel tree (mysql-5.1-wl2325-5.0-drop6) ====
==== Read binlog from ndb tree (mysql-5.1-telco-6.1) ====
SELECT * FROM t1 ORDER BY a;
a	b
0	last_insert_id
1	one
3	last stm in trx: next event should be xid
4	four
703356	random
SELECT * FROM t2 ORDER BY a;
a	b
3	first stm in trx
SELECT COUNT(*) FROM t3;
COUNT(*)
17920
DROP TABLE t1, t2, t3;