diff options
| author | gbichot@quadita2.mysql.com <> | 2005-03-24 16:43:50 +0100 |
|---|---|---|
| committer | gbichot@quadita2.mysql.com <> | 2005-03-24 16:43:50 +0100 |
| commit | 7b0e872695674dd0383976df994dd971c99449a6 (patch) | |
| tree | 1b0c1d334514edadd0a643720a9ac690f9a9d80b | |
| parent | 62fc95b985c5cd247c9836cea59f05c00d1cef28 (diff) | |
| download | mariadb-git-7b0e872695674dd0383976df994dd971c99449a6.tar.gz | |
testing repl of timezone with LOAD DATA INFILE (hourra!)
| -rw-r--r-- | mysql-test/r/rpl_timezone.result | 16 | ||||
| -rw-r--r-- | mysql-test/std_data/rpl_timezone.dat | 2 | ||||
| -rw-r--r-- | mysql-test/t/rpl_timezone.test | 18 |
3 files changed, 36 insertions, 0 deletions
diff --git a/mysql-test/r/rpl_timezone.result b/mysql-test/r/rpl_timezone.result index 8975333d1db..85637638f99 100644 --- a/mysql-test/r/rpl_timezone.result +++ b/mysql-test/r/rpl_timezone.result @@ -65,6 +65,22 @@ SET @@session.time_zone='Europe/Moscow'; insert into t1 values ('20040101000000'), ('20040611093902'); ROLLBACK; /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/; +delete from t1; +set time_zone='UTC'; +load data infile '../../std_data/rpl_timezone.dat' into table t1; +select * from t1; +t +2004-01-01 00:00:00 +2004-06-11 09:39:02 +set time_zone='UTC'; +select * from t1; +t +2004-01-01 00:00:00 +2004-06-11 09:39:02 +set time_zone='Europe/Moscow'; +set time_zone='Europe/Moscow'; +delete from t1; +insert into t1 values ('20040101000000'), ('20040611093902'); set time_zone='MET'; insert into t2 (select t from t1); select * from t1; diff --git a/mysql-test/std_data/rpl_timezone.dat b/mysql-test/std_data/rpl_timezone.dat new file mode 100644 index 00000000000..2df8a39f1e3 --- /dev/null +++ b/mysql-test/std_data/rpl_timezone.dat @@ -0,0 +1,2 @@ +20040101000000 +20040611093902 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 |