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