diff options
| author | Bruce Momjian | 2001-06-18 16:14:44 +0000 |
|---|---|---|
| committer | Bruce Momjian | 2001-06-18 16:14:44 +0000 |
| commit | 7dac778561808267a064c0709e44a19057ab52f5 (patch) | |
| tree | 535dde59eab723ba6ea4f05f3b8cb66553dc791e /src/test | |
| parent | 49ce6fff1d3415257404899e30733aefdfee2a06 (diff) | |
Add GUC setting for Australian timezones. Uses new GUC boolean callback
functions to clear date cache. Allow regression tests to pass when
timezone set.
Diffstat (limited to 'src/test')
| -rw-r--r-- | src/test/regress/expected/horology-no-DST-before-1970.out | 2 | ||||
| -rw-r--r-- | src/test/regress/expected/horology-solaris-1947.out | 2 | ||||
| -rw-r--r-- | src/test/regress/expected/horology.out | 2 | ||||
| -rw-r--r-- | src/test/regress/expected/timestamp.out | 2 | ||||
| -rw-r--r-- | src/test/regress/sql/horology.sql | 3 | ||||
| -rw-r--r-- | src/test/regress/sql/timestamp.sql | 3 |
6 files changed, 12 insertions, 2 deletions
diff --git a/src/test/regress/expected/horology-no-DST-before-1970.out b/src/test/regress/expected/horology-no-DST-before-1970.out index 18ca744d78..f71b6a9821 100644 --- a/src/test/regress/expected/horology-no-DST-before-1970.out +++ b/src/test/regress/expected/horology-no-DST-before-1970.out @@ -4,6 +4,8 @@ -- -- date, time arithmetic -- +-- needed so tests pass +SET australian_timezones = 'off'; SELECT date '1981-02-03' + time '04:05:06' AS "Date + Time"; Date + Time ------------------------------ diff --git a/src/test/regress/expected/horology-solaris-1947.out b/src/test/regress/expected/horology-solaris-1947.out index 451c6a6c76..99313d4cb4 100644 --- a/src/test/regress/expected/horology-solaris-1947.out +++ b/src/test/regress/expected/horology-solaris-1947.out @@ -4,6 +4,8 @@ -- -- date, time arithmetic -- +-- needed so tests pass +SET australian_timezones = 'off'; SELECT date '1981-02-03' + time '04:05:06' AS "Date + Time"; Date + Time ------------------------------ diff --git a/src/test/regress/expected/horology.out b/src/test/regress/expected/horology.out index dc16d58dea..9e054d2209 100644 --- a/src/test/regress/expected/horology.out +++ b/src/test/regress/expected/horology.out @@ -4,6 +4,8 @@ -- -- date, time arithmetic -- +-- needed so tests pass +SET australian_timezones = 'off'; SELECT date '1981-02-03' + time '04:05:06' AS "Date + Time"; Date + Time ------------------------------ diff --git a/src/test/regress/expected/timestamp.out b/src/test/regress/expected/timestamp.out index 60d3673543..5bfaa459c7 100644 --- a/src/test/regress/expected/timestamp.out +++ b/src/test/regress/expected/timestamp.out @@ -4,6 +4,8 @@ -- Shorthand values -- Not directly usable for regression testing since these are not constants. -- So, just try to test parser and hope for the best - thomas 97/04/26 +-- needed so tests pass +SET australian_timezones = 'off'; SELECT (timestamp 'today' = (timestamp 'yesterday' + interval '1 day')) as "True"; True ------ diff --git a/src/test/regress/sql/horology.sql b/src/test/regress/sql/horology.sql index 2350064d83..8d228e0e4d 100644 --- a/src/test/regress/sql/horology.sql +++ b/src/test/regress/sql/horology.sql @@ -1,10 +1,11 @@ -- -- HOROLOGY -- - -- -- date, time arithmetic -- +-- needed so tests pass +SET australian_timezones = 'off'; SELECT date '1981-02-03' + time '04:05:06' AS "Date + Time"; diff --git a/src/test/regress/sql/timestamp.sql b/src/test/regress/sql/timestamp.sql index 84c4fdbf6c..49103dbe5e 100644 --- a/src/test/regress/sql/timestamp.sql +++ b/src/test/regress/sql/timestamp.sql @@ -1,10 +1,11 @@ -- -- DATETIME -- - -- Shorthand values -- Not directly usable for regression testing since these are not constants. -- So, just try to test parser and hope for the best - thomas 97/04/26 +-- needed so tests pass +SET australian_timezones = 'off'; SELECT (timestamp 'today' = (timestamp 'yesterday' + interval '1 day')) as "True"; SELECT (timestamp 'today' = (timestamp 'tomorrow' - interval '1 day')) as "True"; |