summaryrefslogtreecommitdiff
path: root/mysql-test/suite/binlog/r/binlog_unsafe.result
diff options
context:
space:
mode:
authorunknown <knielsen@knielsen-hq.org>2010-01-19 11:36:52 +0100
committerunknown <knielsen@knielsen-hq.org>2010-01-19 11:36:52 +0100
commit80ac8858d5967f525d9b1b798d43146ae0303b53 (patch)
treee423f62e75e1af5c1df4f94dd13c2f1196493d61 /mysql-test/suite/binlog/r/binlog_unsafe.result
parent159ff4c12c339ccd6c6d9386a2486a535b1e0932 (diff)
downloadmariadb-git-80ac8858d5967f525d9b1b798d43146ae0303b53.tar.gz
Fix Windows test failures in binlog tests in certain time zones.
On Unix systems TZ can be set to change the time zone for specific processes only. But on Windows this does not fully work. It changes some aspects of time zones in the system but not others (notably localtime() vs. file system time stamps). This causes test failures in Windows in certain time zones (but not all), where PURGE BEFORE DATE statements get the wrong files when TZ is set to +03:00 by default. Fix by only setting TZ in the small number of tests that really need it, and leave it untouched in the rest. Thanks to Alex Budovski for helping with this. mysql-test/include/ps_conv.inc: Explicitly set TIME_ZONE, as mysql-test-run.pl now does not set it. mysql-test/mysql-test-run.pl: Do not set TZ by default, as it causes problems on Windows. mysql-test/suite/binlog/r/binlog_unsafe.result: Explicitly set TIME_ZONE, as mysql-test-run.pl now does not set it. mysql-test/suite/binlog/t/binlog_unsafe.test: Explicitly set TIME_ZONE, as mysql-test-run.pl now does not set it. mysql-test/suite/rpl/r/rpl_mixed_ddl_dml.result: Explicitly set TIME_ZONE, as mysql-test-run.pl now does not set it. mysql-test/suite/rpl/t/rpl_mixed_ddl_dml.test: Explicitly set TIME_ZONE, as mysql-test-run.pl now does not set it. mysql-test/t/mysqlbinlog2-master.opt: mysql-test-run.pl no longer sets TZ by default, so set it explicitly for this particular test.
Diffstat (limited to 'mysql-test/suite/binlog/r/binlog_unsafe.result')
-rw-r--r--mysql-test/suite/binlog/r/binlog_unsafe.result1
1 files changed, 1 insertions, 0 deletions
diff --git a/mysql-test/suite/binlog/r/binlog_unsafe.result b/mysql-test/suite/binlog/r/binlog_unsafe.result
index 8bbf993a727..6ef322be67a 100644
--- a/mysql-test/suite/binlog/r/binlog_unsafe.result
+++ b/mysql-test/suite/binlog/r/binlog_unsafe.result
@@ -380,6 +380,7 @@ INSERT INTO t1 VALUES (VERSION());
Warnings:
Note 1592 Statement may not be safe to log in statement format.
DELETE FROM t1;
+SET TIME_ZONE= '+03:00';
SET TIMESTAMP=1000000;
INSERT INTO t1 VALUES
(CURDATE()),