1
# Mixed DDL-DML (CREATE ... SELECT ...) statements can only be
2
# replicated properly in statement-based replication.
3
# Currently statement based due to bug 12345
4
--source include/have_binlog_format_mixed_or_statement.inc
6
source include/master-slave.inc;
8
# Test replication of auto_increment
10
create table t1 (n int auto_increment primary key);
12
insert into t1 values (NULL),(NULL),(NULL);
13
sync_slave_with_master;
16
--replace_result $SLAVE_MYPORT 9999
19
sync_slave_with_master;
23
# Test replication of timestamp
25
create table t2(id int auto_increment primary key, created datetime);
27
insert into t2 set created=now();
30
# Test replication of CREATE .. LIKE (Bug #2557)
32
create table t3 like t2;
33
create temporary table t4 like t2;
34
create table t5 select * from t4;
44
sync_slave_with_master;