MOON
Server: Apache/2.2.34 (Unix) mod_ssl/2.2.34 OpenSSL/0.9.8e-fips-rhel5 mod_bwlimited/1.4 FrontPage/5.0.2.2635
System: Linux server.asjudinet.com 2.6.32-042stab141.3 #1 SMP Fri Nov 15 22:45:34 MSK 2019 i686
User: asjudine (504)
PHP: 5.2.17
Disabled: NONE
Upload Files
File: //usr/share/mysql-test/suite/binlog/r/binlog_old_versions.result
==== 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;
==== Read binlog from alcatel tree (mysql-5.1-wl2325-5.0-drop6) ====
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
781729	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 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;