diff options
author | unknown <sasha@mysql.sashanet.com> | 2001-02-14 21:23:20 -0700 |
---|---|---|
committer | unknown <sasha@mysql.sashanet.com> | 2001-02-14 21:23:20 -0700 |
commit | 9a17a41ed8b2778db19878e58bdbe3dc36534d9a (patch) | |
tree | 8c9fde5b17283d8c928db454a2edb39c8a20c79e /mysql-test/t/rpl000002.test | |
parent | 0a4ce964b49214ce0acf9353bf58d9c7380eb83d (diff) | |
download | mariadb-git-9a17a41ed8b2778db19878e58bdbe3dc36534d9a.tar.gz |
fixed bug in timestamp replication
mysql-test/r/rpl000002.result:
test timestamp replication
mysql-test/t/rpl000002.test:
test timestamp replication
Diffstat (limited to 'mysql-test/t/rpl000002.test')
-rw-r--r-- | mysql-test/t/rpl000002.test | 19 |
1 files changed, 18 insertions, 1 deletions
diff --git a/mysql-test/t/rpl000002.test b/mysql-test/t/rpl000002.test index c982bd54b8c..0c490e6316d 100644 --- a/mysql-test/t/rpl000002.test +++ b/mysql-test/t/rpl000002.test @@ -9,9 +9,26 @@ save_master_pos; connection slave; use test; sync_with_master; -@r/rpl000002.result select * from t1; +select * from t1; connection master; drop table t1; save_master_pos; connection slave; sync_with_master; +slave stop; +connection master; +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; +save_master_pos; +connection slave; +slave start; +sync_with_master; +select * from t2; +connection master; +drop table t2; +save_master_pos; +connection slave; +sync_with_master; |