[ https://issues.apache.org/jira/browse/BEAM-9712?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Andrew Pilloud updated BEAM-9712: --------------------------------- Status: Open (was: Triage Needed) > setting default timezone doesn't work > ------------------------------------- > > Key: BEAM-9712 > URL: https://issues.apache.org/jira/browse/BEAM-9712 > Project: Beam > Issue Type: Bug > Components: dsl-sql-zetasql > Reporter: Andrew Pilloud > Priority: Trivial > Labels: zetasql-compliance > > several failures in shard 14 > (note: fixing the internal tests requires plumbing through the timezone > config.) > {code} > [name=timestamp_to_string_1] > select [cast(timestamp "2015-01-28" as string), > cast(timestamp "2015-01-28 00:00:00" as string), > cast(timestamp "2015-01-28 00:00:00.0" as string), > cast(timestamp "2015-01-28 00:00:00.00" as string), > cast(timestamp "2015-01-28 00:00:00.000" as string), > cast(timestamp "2015-01-28 00:00:00.0000" as string), > cast(timestamp "2015-01-28 00:00:00.00000" as string), > cast(timestamp "2015-01-28 00:00:00.000000" as string)] > -- > ARRAY<STRUCT<ARRAY<>>>[ > {ARRAY<STRING>[ > "2015-01-28 00:00:00+13:45", > "2015-01-28 00:00:00+13:45", > "2015-01-28 00:00:00+13:45", > "2015-01-28 00:00:00+13:45", > "2015-01-28 00:00:00+13:45", > "2015-01-28 00:00:00+13:45", > "2015-01-28 00:00:00+13:45", > "2015-01-28 00:00:00+13:45" > ]} > ] > {code} > {code} > [default_time_zone=Pacific/Chatham] > [name=timestamp_to_string_1] > select [cast(timestamp "2015-01-28" as string), > cast(timestamp "2015-01-28 00:00:00" as string), > cast(timestamp "2015-01-28 00:00:00.0" as string), > cast(timestamp "2015-01-28 00:00:00.00" as string), > cast(timestamp "2015-01-28 00:00:00.000" as string), > cast(timestamp "2015-01-28 00:00:00.0000" as string), > cast(timestamp "2015-01-28 00:00:00.00000" as string), > cast(timestamp "2015-01-28 00:00:00.000000" as string)] > -- > ARRAY<STRUCT<ARRAY<>>>[ > {ARRAY<STRING>[ > "2015-01-28 00:00:00+13:45", > "2015-01-28 00:00:00+13:45", > "2015-01-28 00:00:00+13:45", > "2015-01-28 00:00:00+13:45", > "2015-01-28 00:00:00+13:45", > "2015-01-28 00:00:00+13:45", > "2015-01-28 00:00:00+13:45", > "2015-01-28 00:00:00+13:45" > ]} > ] > {code} -- This message was sent by Atlassian Jira (v8.3.4#803005)