[ 
https://issues.apache.org/jira/browse/BEAM-9709?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Andrew Pilloud updated BEAM-9709:
---------------------------------
    Description: 
two failures in shard 13, one failure in shard 19
{code}
Expected: ARRAY<STRUCT<TIMESTAMP>>[{2014-01-31 00:00:00+00}]
  Actual: ARRAY<STRUCT<$col1 TIMESTAMP>>[{2014-01-31 08:00:00+00}], 
{code}
{code}
select timestamp(date '2014-01-31')
{code}

  was:
one failure in shard 19
(It is possible this test is attempting to change the default timezone before 
running)
{code}
Expected: ARRAY<STRUCT<x TIMESTAMP>>[
  {2000-01-02 18:20:30+00},
  {2000-01-02 09:02:03+00}
]
  Actual: ARRAY<STRUCT<x TIMESTAMP>>[
  {2000-01-02 10:20:30+00},
  {2000-01-02 01:02:03+00}
], 
{code}
{code}
SELECT x FROM UNNEST([TIMESTAMP '2000-01-02 10:20:30', '2000-01-02 01:02:03']) 
x;
{code}


> timezone off by 8 hours
> -----------------------
>
>                 Key: BEAM-9709
>                 URL: https://issues.apache.org/jira/browse/BEAM-9709
>             Project: Beam
>          Issue Type: Bug
>          Components: dsl-sql-zetasql
>            Reporter: Andrew Pilloud
>            Priority: Trivial
>              Labels: zetasql-compliance
>
> two failures in shard 13, one failure in shard 19
> {code}
> Expected: ARRAY<STRUCT<TIMESTAMP>>[{2014-01-31 00:00:00+00}]
>   Actual: ARRAY<STRUCT<$col1 TIMESTAMP>>[{2014-01-31 08:00:00+00}], 
> {code}
> {code}
> select timestamp(date '2014-01-31')
> {code}



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

Reply via email to