[jira] [Updated] (HIVE-28589) Not null constraint does not enforced at invalid cast

["Krisztian Kasa (Jira)" <ji...@apache.org>]

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

Krisztian Kasa updated HIVE-28589:
----------------------------------
    Summary: Not null constraint does not enforced at invalid cast  (was: Not null not constraint does not enforced at invalid cast)

> 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
>      Security Level: Public(Viewable by anyone) 
>            Reporter: 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)