Debian Codegraph @

mysql-test/suite/binlog/t/innodb_autoinc_lock_mode_binlog.test

raw
1 --source include/have_innodb.inc
2 --source include/have_binlog_format_mixed.inc
3 reset master; #clear up binlogs
4 call mtr.add_suppression("Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT");
5
6 select @@innodb_autoinc_lock_mode;
7 select @@binlog_format;
8
9 create table t1 (a int not null auto_increment,b int, primary key (a)) engine=InnoDB;
10 insert into t1 values (NULL,1);
11 --source include/show_binlog_events.inc
12
13 set global binlog_format=STATEMENT;
14 --connect (con1,localhost,root,,test,$MASTER_MYPORT,$MASTER_MYSOCK)
15 insert into t1 values (NULL,1);
16 insert into t1 values (NULL,1);
17 --disconnect con1
18 --connection default
19
20 set global binlog_format=MIXED;
21 DROP TABLE t1;