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