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)
