Andrew Pilloud created BEAM-9709:
------------------------------------
Summary: 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
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)