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

Krisztian Kasa reassigned HIVE-28589:
-------------------------------------

    Assignee: Krisztian Kasa

> Not null constraint does not enforced at invalid cast
> -----------------------------------------------------
>
>                 Key: HIVE-28589
>                 URL: https://issues.apache.org/jira/browse/HIVE-28589
>             Project: Hive
>          Issue Type: Bug
>            Reporter: Krisztian Kasa
>            Assignee: Krisztian Kasa
>            Priority: Major
>              Labels: pull-request-available
>
> {code}
> create table t1(
>   date_col date not null
> );
> insert into t1 values ('2024-99-99');
> {code}
> The string literal {{'2024-99-99'}} can not be converted to date and the 
> implicit cast returns {{null}}. The insert should fail with constraint 
> violation but {{null}} is inserted



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

Reply via email to