diff options
Diffstat (limited to 'mysql-test/extra/rpl_tests/rpl000006.test')
| -rw-r--r-- | mysql-test/extra/rpl_tests/rpl000006.test | 47 |
1 files changed, 47 insertions, 0 deletions
diff --git a/mysql-test/extra/rpl_tests/rpl000006.test b/mysql-test/extra/rpl_tests/rpl000006.test new file mode 100644 index 00000000000..272e5744d9c --- /dev/null +++ b/mysql-test/extra/rpl_tests/rpl000006.test @@ -0,0 +1,47 @@ +# +# Test forced timestamp +# +-- source include/master-slave.inc + +# Don't log table creating to the slave as we want to test LOAD TABLE +set SQL_LOG_BIN=0,timestamp=200006; +create table t1(t timestamp not null,a char(1)); +insert into t1 ( a) values ('F'); +select unix_timestamp(t) from t1; +connection slave; +load table t1 from master; +select unix_timestamp(t) from t1; + +# Delete the created table on master and slave +connection master; +set SQL_LOG_BIN=1,timestamp=default; +drop table t1; +save_master_pos; +connection slave; +sync_with_master; +connection master; + +# +# Test copying table with checksum +# + +# Don't log table creating to the slave as we want to test LOAD TABLE +set SQL_LOG_BIN=0; + +eval CREATE TABLE t1 ( + a int not null +) ENGINE=$engine_type MAX_ROWS=4000 CHECKSUM=1; +INSERT INTO t1 VALUES (1); +save_master_pos; +connection slave; +sync_with_master; +load table t1 from master; +check table t1; +drop table t1; +connection master; +drop table t1; +save_master_pos; +connection slave; +sync_with_master; + +# End of 4.1 tests |