[jira] [Updated] (BEAM-9709) unnest timezone off by 8 hours

["Andrew Pilloud (Jira)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/BEAM-9709?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Andrew Pilloud updated BEAM-9709:
---------------------------------
    Status: Open  (was: Triage Needed)

> unnest 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)