You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "Jim Hopper (JIRA)" <ji...@apache.org> on 2017/07/05 12:54:00 UTC
[jira] [Updated] (HIVE-17038) invalid CAST result
[ 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)