[BEAM-9712] setting default timezone doesn't work

• Type: Bug
• Status: Resolved
• Priority: P4
• Resolution: Fixed
• Fix Version/s: 2.24.0
• Component/s: dsl-sql-zetasql
• Labels: zetasql-compliance
• Assignee: Robin Qiu
• Reporter: Andrew Pilloud
• Created: 06/Apr/20 23:38
• Updated: 09/Jul/20 22:45
• Resolved: 09/Jul/20 22:45

Description

several failures in shard 14
(note: fixing the internal tests requires plumbing through the timezone config.)

[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"
   ]}
]

[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"
   ]}
]

Issue Links

• links to: GitHub Pull Request #12163