summaryrefslogtreecommitdiff
path: root/mysql-test/r/rpl000002.result
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/r/rpl000002.result')
-rw-r--r--mysql-test/r/rpl000002.result23
1 files changed, 23 insertions, 0 deletions
diff --git a/mysql-test/r/rpl000002.result b/mysql-test/r/rpl000002.result
index 7f518a7339e..d557c3f8171 100644
--- a/mysql-test/r/rpl000002.result
+++ b/mysql-test/r/rpl000002.result
@@ -1,10 +1,33 @@
+slave stop;
+reset master;
+reset slave;
+drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
+slave start;
+use test;
+drop table if exists t1;
+create table t1 (n int auto_increment primary key);
+set insert_id = 2000;
+insert into t1 values (NULL),(NULL),(NULL);
+use test;
+select * from t1;
n
2000
2001
2002
+show slave hosts;
Server_id Host Port
2 127.0.0.1 9307
+drop table t1;
+slave stop;
+drop table if exists t2;
+create table t2(id int auto_increment primary key, created datetime);
+set timestamp=12345;
+insert into t2 set created=now();
+select * from t2;
id created
1 1970-01-01 06:25:45
+slave start;
+select * from t2;
id created
1 1970-01-01 06:25:45
+drop table t2;