diff options
| author | unknown <gbichot@quadita2.mysql.com> | 2005-03-24 16:43:50 +0100 |
|---|---|---|
| committer | unknown <gbichot@quadita2.mysql.com> | 2005-03-24 16:43:50 +0100 |
| commit | fa4a075b6cb7ba7e71c842e6649bf7e7c516bef2 (patch) | |
| tree | 1b0c1d334514edadd0a643720a9ac690f9a9d80b /mysql-test/t/rpl_timezone.test | |
| parent | e56418c56a76270cccd4ae6cc4c8343143dd5c0e (diff) | |
| download | mariadb-git-fa4a075b6cb7ba7e71c842e6649bf7e7c516bef2.tar.gz | |
testing repl of timezone with LOAD DATA INFILE (hourra!)
mysql-test/r/rpl_timezone.result:
result update
Diffstat (limited to 'mysql-test/t/rpl_timezone.test')
| -rw-r--r-- | mysql-test/t/rpl_timezone.test | 18 |
1 files changed, 18 insertions, 0 deletions
diff --git a/mysql-test/t/rpl_timezone.test b/mysql-test/t/rpl_timezone.test index cc8dcb6ce26..a7547f7afc6 100644 --- a/mysql-test/t/rpl_timezone.test +++ b/mysql-test/t/rpl_timezone.test @@ -49,6 +49,24 @@ connection master; --replace_result $MYSQL_TEST_DIR MYSQL_TEST_DIR --exec $MYSQL_BINLOG --short-form $MYSQL_TEST_DIR/var/log/master-bin.000001 +# Let us check with LOAD DATA INFILE +# (we do it after mysqlbinlog because the temp files names are not constant) +connection master; +delete from t1; +set time_zone='UTC'; +load data infile '../../std_data/rpl_timezone.dat' into table t1; +select * from t1; +sync_slave_with_master; +set time_zone='UTC'; +select * from t1; +set time_zone='Europe/Moscow'; + +# Put back values of before the LOAD +connection master; +set time_zone='Europe/Moscow'; +delete from t1; +insert into t1 values ('20040101000000'), ('20040611093902'); + # # Now let us check how well we replicate statments reading TIMESTAMP fields # (We should see the same data on master and on slave but it should differ |