Summary: Hive beeline not throw Error when update a varchar column 
value is exceed the length length
                 Key: HIVE-24057
                 URL: https://issues.apache.org/jira/browse/HIVE-24057
             Project: Hive
          Issue Type: Bug
          Components: Hive
    Affects Versions: 3.1.0
            Reporter: ABHISHEK KUMAR GUPTA

1. CREATE TABLE table013(orderkey int, orderstatus varchar(7), totalprice 
double, orderdate date) stored as orc tblproperties('transactional'='true');
2. INSERT INTO  table013 VALUES(10, 'SUCCESS', 125.15, DATE'2019-05-17');
3. update table013 set orderkey=40,orderstatus='FAILEDDDDDD' where orderkey=10;

Current behavior: Operation will be success. No error
But select * from table013; does not update the column orderstatus.

Expected: Should throw Mismatch column Error Msg as orderstatus  column expect 
7 length.

This message was sent by Atlassian Jira

Reply via email to