summaryrefslogtreecommitdiff
path: root/mysql-test/t/rpl000006.test
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/t/rpl000006.test')
-rw-r--r--mysql-test/t/rpl000006.test39
1 files changed, 26 insertions, 13 deletions
diff --git a/mysql-test/t/rpl000006.test b/mysql-test/t/rpl000006.test
index b8ee690837e..495f34bd5e7 100644
--- a/mysql-test/t/rpl000006.test
+++ b/mysql-test/t/rpl000006.test
@@ -1,33 +1,46 @@
+#
+# Test forced timestamp
+#
source include/master-slave.inc;
connection master;
-set SQL_LOG_BIN=0;
-set timestamp=200006;
-drop table if exists foo;
-create table foo(t timestamp not null,a char(1));
-insert into foo ( a) values ('F');
-select unix_timestamp(t) from foo;
+
+# Don't log table creating to the slave as we want to test LOAD TABLE
+set SQL_LOG_BIN=0,timestamp=200006;
+drop table if exists t1;
+create table t1(t timestamp not null,a char(1));
+insert into t1 ( a) values ('F');
+select unix_timestamp(t) from t1;
connection slave;
-drop table if exists foo;
-load table foo from master;
-select unix_timestamp(t) from foo;
+drop table if exists t1;
+load table t1 from master;
+select unix_timestamp(t) from t1;
+
+# Delete the created table on master and slave
connection master;
-drop table foo;
+set SQL_LOG_BIN=1,timestamp=default;
+drop table t1;
save_master_pos;
connection slave;
sync_with_master;
connection master;
-set SQL_LOG_BIN=1;
+
+#
+# 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;
+
CREATE TABLE t1 (
a int not null
) TYPE=MyISAM MAX_ROWS=4000 CHECKSUM=1;
-
INSERT INTO t1 VALUES (1);
save_master_pos;
connection slave;
sync_with_master;
-drop table t1;
load table t1 from master;
check table t1;
+drop table t1;
connection master;
drop table t1;
save_master_pos;