[jira] [Created] (DRILL-704) issue with casting varchar into date

["Chun Chang (JIRA)" <ji...@apache.org>]

Chun Chang created DRILL-704:
--------------------------------

             Summary: issue with casting varchar into date
                 Key: DRILL-704
                 URL: https://issues.apache.org/jira/browse/DRILL-704
             Project: Apache Drill
          Issue Type: Bug
            Reporter: Chun Chang


When drill casts varchar into date, we seem to adding a time portion with appears random timezone info.

postgres:

foodmart=# select c_date, cast(c_date as date) from data where c_row < 23;
   c_date   |   c_date
------------+------------
 1957-04-09 | 1957-04-09
 1957-06-13 | 1957-06-13
 1996-02-28 | 1996-02-28
 1996-01-29 | 1996-01-29
 1996-03-01 | 1996-03-01
 1996-03-02 | 1996-03-02
 1997-02-28 | 1997-02-28
 1997-01-29 | 1997-01-29
 1997-03-01 | 1997-03-01
 1997-03-02 | 1997-03-02
 2000-04-01 | 2000-04-01
 2000-04-02 | 2000-04-02
 2000-04-03 | 2000-04-03
 2038-04-08 | 2038-04-08
 2039-04-09 | 2039-04-09
 2040-04-10 | 2040-04-10
 1999-01-08 | 1999-01-08
 1999-02-08 | 1999-02-08
 1999-03-08 | 1999-03-08
 1999-01-18 | 1999-01-18
 2003-01-02 | 2003-01-02
 1999-04-08 | 1999-04-08
(22 rows)

drill:

0: jdbc:drill:schema=dfs> select cast(c_date as varchar(50)), cast(c_date as date) from data where c_row < 23;
+------------+------------+
|   EXPR$0   |   EXPR$1   |
+------------+------------+
| 1957-04-09 | 1957-04-09T00:00:00.000-08:00 |
| 1957-06-13 | 1957-06-13T00:00:00.000-07:00 |
| 1996-02-28 | 1996-02-28T00:00:00.000-08:00 |
| 1996-01-29 | 1996-01-29T00:00:00.000-08:00 |
| 1996-03-01 | 1996-03-01T00:00:00.000-08:00 |
| 1996-03-02 | 1996-03-02T00:00:00.000-08:00 |
| 1997-02-28 | 1997-02-28T00:00:00.000-08:00 |
| 1997-01-29 | 1997-01-29T00:00:00.000-08:00 |
| 1997-03-01 | 1997-03-01T00:00:00.000-08:00 |
| 1997-03-02 | 1997-03-02T00:00:00.000-08:00 |
| 2000-04-01 | 2000-04-01T00:00:00.000-08:00 |
| 2000-04-02 | 2000-04-02T00:00:00.000-08:00 |
| 2000-04-03 | 2000-04-03T00:00:00.000-07:00 |
| 2038-04-08 | 2038-04-08T00:00:00.000-07:00 |
| 2039-04-09 | 2039-04-09T00:00:00.000-07:00 |
| 2040-04-10 | 2040-04-10T00:00:00.000-07:00 |
| 1999-01-08 | 1999-01-08T00:00:00.000-08:00 |
| 1999-02-08 | 1999-02-08T00:00:00.000-08:00 |
| 1999-03-08 | 1999-03-08T00:00:00.000-08:00 |
| 1999-01-18 | 1999-01-18T00:00:00.000-08:00 |
| 2003-01-02 | 2003-01-02T00:00:00.000-08:00 |
| 1999-04-08 | 1999-04-08T00:00:00.000-07:00 |
+------------+------------+
22 rows selected (0.175 seconds)

This is a regression.



--
This message was sent by Atlassian JIRA
(v6.2#6252)