1#
2# Testcase for http://bugs.mysql.com/bug.php?id=72610 (high mem usage in RBR with large
3# transactions and slave type conversions)
4#
5--source include/have_binlog_format_row.inc
6--source include/master-slave.inc
7
8--connection master
9
10CREATE TABLE t1(a BIGINT AUTO_INCREMENT PRIMARY KEY, b INT DEFAULT NULL) ENGINE=InnoDB;
11
12--source include/sync_slave_sql_with_master.inc
13
14ALTER TABLE t1 MODIFY COLUMN b BIGINT DEFAULT NULL;
15
16--connection master
17
18BEGIN;
19INSERT INTO t1 VALUES (NULL, NULL);
20INSERT INTO t1 VALUES (NULL, NULL);
21INSERT INTO t1 VALUES (NULL, NULL);
22INSERT INTO t1 VALUES (NULL, NULL);
23INSERT INTO t1 VALUES (NULL, NULL);
24COMMIT;
25
26--source include/sync_slave_sql_with_master.inc
27
28SELECT COUNT(*) FROM t1;
29
30--connection master
31DROP TABLE t1;
32--source include/rpl_end.inc
33