hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jim Hopper (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (HIVE-17038) invalid CAST result
Date Wed, 05 Jul 2017 12:54:00 GMT

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

Jim Hopper updated HIVE-17038:
------------------------------
    Description: 
when casting incorrect date literals to DATE data type hive returns wrong values instead of
NULL.

{code}

SELECT CAST('2017-02-31' AS DATE);
SELECT CAST('2017-05-31' AS DATE);

{code}


  was:
when casting incorrect date literals to DATE data type hive returns wrong values instead of
NULL.

{code}

SELECT CAST('2017-05-31' AS DATE);

{code}



> invalid CAST result
> -------------------
>
>                 Key: HIVE-17038
>                 URL: https://issues.apache.org/jira/browse/HIVE-17038
>             Project: Hive
>          Issue Type: Bug
>            Reporter: Jim Hopper
>
> when casting incorrect date literals to DATE data type hive returns wrong values instead
of NULL.
> {code}
> SELECT CAST('2017-02-31' AS DATE);
> SELECT CAST('2017-05-31' AS DATE);
> {code}



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)

Mime
View raw message