diff options
Diffstat (limited to 'mysql-test/suite/s3/replication.inc')
-rw-r--r-- | mysql-test/suite/s3/replication.inc | 10 |
1 files changed, 9 insertions, 1 deletions
diff --git a/mysql-test/suite/s3/replication.inc b/mysql-test/suite/s3/replication.inc index 26dd9a5da25..d790c70f221 100644 --- a/mysql-test/suite/s3/replication.inc +++ b/mysql-test/suite/s3/replication.inc @@ -20,6 +20,8 @@ connection master; create table t1 (a int, b int) engine=aria; insert into t1 select seq,seq+10 from seq_1_to_10; +sync_slave_with_master; +connection master; alter table t1 engine=s3; show create table t1; @@ -116,12 +118,18 @@ connection slave; stop slave; connection master; rename table t1 to t2; -create table t1 (a int, b int) engine=aria; +# Check the different create options with the table +create table t1 (a int) engine=aria; +drop table t1; +create table if not exists t1 (a int, b int) engine=aria; +drop table t1; +create or replace table t1 (a int, b int, c int) engine=aria; alter table t1 engine=s3; connection slave; start slave; connection master; sync_slave_with_master; +show create table t1; select * from t1 limit 2; select * from t2 limit 2; connection master; |