summaryrefslogtreecommitdiff
path: root/mysql-test/suite/s3/replication.inc
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/suite/s3/replication.inc')
-rw-r--r--mysql-test/suite/s3/replication.inc10
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;