# # misc binlogging tests that do not require a slave running # -- source include/not_embedded.inc -- source include/have_innodb.inc -- source include/have_debug.inc --disable_warnings drop table if exists t1, t2; --enable_warnings reset master; create table t1 (a int) engine=innodb; create table t2 (a int) engine=innodb; begin; insert t1 values (5); commit; begin; insert t2 values (5); commit; # first COMMIT must be Query_log_event, second - Xid_log_event --replace_column 2 # 5 # --replace_regex /table_id: [0-9]+/table_id: #/ /\/\* xid=.* \*\//\/* xid= *\// show binlog events from 102; drop table t1,t2; # # binlog rotation after one big transaction # reset master; let $1=100; create table t1 (n int) engine=innodb; begin; --disable_query_log while ($1) { eval insert into t1 values($1 + 4); dec $1; } --enable_query_log commit; drop table t1; --replace_column 2 # 5 # --replace_regex /table_id: [0-9]+/table_id: #/ /\/\* xid=.* \*\//\/* xid= *\// show binlog events in 'master-bin.000001' from 102; --replace_column 2 # 5 # --replace_regex /table_id: [0-9]+/table_id: #/ /\/\* xid=.* \*\//\/* xid= *\// show binlog events in 'master-bin.000002' from 102; # Test of a too big SET INSERT_ID: see if the truncated value goes # into binlog (right), or the too big value (wrong); we look at the # binlog further down with SHOW BINLOG EVENTS. reset master; create table t1 (id tinyint auto_increment primary key); set insert_id=128; insert into t1 values(null); select * from t1; drop table t1; # bug#22027 create table t1 (a int); create table if not exists t2 select * from t1; # bug#22762 create temporary table tt1 (a int); create table if not exists t3 like tt1; # BUG#25091 (A DELETE statement to mysql database is not logged with # ROW mode format): Checking that some basic operations on tables in # the mysql database is replicated even when the current database is # 'mysql'. --disable_warnings USE mysql; INSERT INTO user SET host='localhost', user='@#@', password=password('Just a test'); UPDATE user SET password=password('Another password') WHERE host='localhost' AND user='@#@'; DELETE FROM user WHERE host='localhost' AND user='@#@'; --enable_warnings use test; --replace_column 2 # 5 # --replace_regex /table_id: [0-9]+/table_id: #/ /\/\* xid=.* \*\//\/* xid= *\// show binlog events from 102; drop table t1,t2,t3,tt1; -- source extra/binlog_tests/binlog_insert_delayed.test