diff options
| author | unknown <tnurnberg@mysql.com> | 2006-06-22 20:50:38 +0200 |
|---|---|---|
| committer | unknown <tnurnberg@mysql.com> | 2006-06-22 20:50:38 +0200 |
| commit | 0271faa8c2c56d4a589980927bb91c657e28fbfe (patch) | |
| tree | 560a974824d26c0812daa94a4f2bcb4303825c9f /mysql-test/r/func_timestamp.result | |
| parent | 41af8b9e3bcf8bd7862156576c1fb46cd00f1c21 (diff) | |
| download | mariadb-git-0271faa8c2c56d4a589980927bb91c657e28fbfe.tar.gz | |
#19409: Test 'func_timestamp' fails on Windows x64
- The setting of "ENV{'TZ'}" doesn't affect the timezone
used by MySQL Server on Windows.
- Explicitly set timezone in test cases before doing UTC/localtime
conversions so tests produce deterministic results
mysql-test/r/func_timestamp.result:
Update test results
mysql-test/r/type_timestamp.result:
Update test results
mysql-test/t/func_timestamp.test:
Specifically set timezone to make tests that do localtime/UTC conversions deterministic
mysql-test/t/type_timestamp.test:
Specifically set timezone to make tests that do localtime/UTC conversions deterministic
Diffstat (limited to 'mysql-test/r/func_timestamp.result')
| -rw-r--r-- | mysql-test/r/func_timestamp.result | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/mysql-test/r/func_timestamp.result b/mysql-test/r/func_timestamp.result index d9912f08b72..495fedea9e6 100644 --- a/mysql-test/r/func_timestamp.result +++ b/mysql-test/r/func_timestamp.result @@ -1,4 +1,5 @@ drop table if exists t1; +set time_zone="+03:00"; create table t1 (Zeit time, Tag tinyint not null, Monat tinyint not null, Jahr smallint not null, index(Tag), index(Monat), index(Jahr) ); insert into t1 values ("09:26:00",16,9,1998),("09:26:00",16,9,1998); @@ -9,3 +10,4 @@ Date Unix 1998-9-16 09:26:00 905927160 1998-9-16 09:26:00 905927160 drop table t1; +set time_zone= @@global.time_zone; |