| 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; |