diff options
Diffstat (limited to 'mysql-test/suite/rpl/r/rpl_auto_increment_bug45679.result')
| -rw-r--r-- | mysql-test/suite/rpl/r/rpl_auto_increment_bug45679.result | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/mysql-test/suite/rpl/r/rpl_auto_increment_bug45679.result b/mysql-test/suite/rpl/r/rpl_auto_increment_bug45679.result index 198ecfb6724..3e633d11927 100644 --- a/mysql-test/suite/rpl/r/rpl_auto_increment_bug45679.result +++ b/mysql-test/suite/rpl/r/rpl_auto_increment_bug45679.result @@ -1,6 +1,7 @@ include/master-slave.inc [connection master] call mtr.add_suppression('Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT.'); +connection master; create table tm (b int auto_increment, a int, primary key (a,b)) engine= myisam; create table ti (b int auto_increment, a int, primary key (a,b)) engine= innodb; ERROR 42000: Incorrect table definition; there can be only one auto column and it must be defined as a key @@ -36,6 +37,9 @@ Note 1592 Unsafe statement written to the binary log using statement format sinc Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. INSERT into autoincrement field which is not the first part in the composed primary key is unsafe. set @@binlog_format=mixed; insert into tm set b=null, a=2; +connection slave; +connection master; drop table tm, ti; drop function multi_part_pk_with_autoinc; +connection slave; include/rpl_end.inc |