diff options
| author | tnurnberg@mysql.com <> | 2006-06-22 20:23:22 +0200 |
|---|---|---|
| committer | tnurnberg@mysql.com <> | 2006-06-22 20:23:22 +0200 |
| commit | 8fd6830478d492bc868a150c6143085ced848076 (patch) | |
| tree | bc9d2508ef9dcadbb3eb878e33347effa2df838e /mysql-test/r/func_time.result | |
| parent | 0f4e09a81a9c3f577356677fd45ce21b0a0ae676 (diff) | |
| download | mariadb-git-8fd6830478d492bc868a150c6143085ced848076.tar.gz | |
Bug#19408 Test 'func_time' fails on Windows x64
- The setting of "ENV{'TZ'}" doesn't affect the timezone
used by MySQL Server on Windows.
- Explicitly set timezone to "+03:00" in test case before
doing the calculatiosn to check that there is three hours
difference between utc and local time.
(Magnus' fix)
Diffstat (limited to 'mysql-test/r/func_time.result')
| -rw-r--r-- | mysql-test/r/func_time.result | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/mysql-test/r/func_time.result b/mysql-test/r/func_time.result index 593ce7b26c8..aaa86378626 100644 --- a/mysql-test/r/func_time.result +++ b/mysql-test/r/func_time.result @@ -1,4 +1,5 @@ drop table if exists t1,t2,t3; +set time_zone="+03:00"; select from_days(to_days("960101")),to_days(960201)-to_days("19960101"),to_days(date_add(curdate(), interval 1 day))-to_days(curdate()),weekday("1997-11-29"); from_days(to_days("960101")) to_days(960201)-to_days("19960101") to_days(date_add(curdate(), interval 1 day))-to_days(curdate()) weekday("1997-11-29") 1996-01-01 31 1 5 @@ -945,3 +946,4 @@ id day id day 1 2005-06-01 3 2005-07-15 3 2005-07-01 3 2005-07-15 DROP TABLE t1,t2; +set time_zone= @@global.time_zone; |