[
https://issues.apache.org/jira/browse/BEAM-9709?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Andrew Pilloud updated BEAM-9709:
---------------------------------
Summary: timezone off by 8 hours (was: unnest timezone off by 8 hours)
> timezone off by 8 hours
> -----------------------
>
> Key: BEAM-9709
> URL: https://issues.apache.org/jira/browse/BEAM-9709
> Project: Beam
> Issue Type: Bug
> Components: dsl-sql-zetasql
> Reporter: Andrew Pilloud
> Priority: Trivial
> Labels: zetasql-compliance
>
> one failure in shard 19
> (It is possible this test is attempting to change the default timezone before
> running)
> {code}
> Expected: ARRAY<STRUCT<x TIMESTAMP>>[
> {2000-01-02 18:20:30+00},
> {2000-01-02 09:02:03+00}
> ]
> Actual: ARRAY<STRUCT<x TIMESTAMP>>[
> {2000-01-02 10:20:30+00},
> {2000-01-02 01:02:03+00}
> ],
> {code}
> {code}
> SELECT x FROM UNNEST([TIMESTAMP '2000-01-02 10:20:30', '2000-01-02
> 01:02:03']) x;
> {code}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
