diff options
Diffstat (limited to 'mysql-test/r/rpl000002.result')
-rw-r--r-- | mysql-test/r/rpl000002.result | 23 |
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; |