[BEAM-9710] Got current time instead of timestamp value

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

Description

one failure in shard 13

Expected: ARRAY<STRUCT<timestamp_val TIMESTAMP>>[{2014-12-01 00:00:00+00}]
  Actual: ARRAY<STRUCT<timestamp_val TIMESTAMP>>[{2020-04-06 00:20:40.052+00}], 

[prepare_database]
CREATE TABLE Table1 AS
SELECT timestamp '2014-12-01' as timestamp_val
--
ARRAY<STRUCT<timestamp_val TIMESTAMP>>[{2014-12-01 00:00:00+00}]
==
[name=timestamp_type_2]
SELECT timestamp_val
FROM Table1
--
ARRAY<STRUCT<timestamp_val TIMESTAMP>>[{2014-12-01 00:00:00+00}]