zhangy5 opened a new issue #1555: Insert default value failed when column is 
nullable and do not set default value explicitly
URL: https://github.com/apache/incubator-doris/issues/1555
 
 
   **Describe the bug**
   Create table like
   
   CREATE TABLE `d` (
     `k1` int(11) NULL COMMENT "",
     `k2` int(11) NULL COMMENT ""
   ) ENGINE=OLAP
   AGGREGATE KEY(`k1`, `k2`)
   DISTRIBUTED BY HASH(`k1`) BUCKETS 5
   PROPERTIES (
   "storage_type" = "COLUMN"
   );
   
   When I insert data failed.
   
   mysql> insert into d (k1) values (1);
   ERROR 5002 (HY000): 'k2' must be explicitly mentioned in column permutation
   
   It is expected that this insert will be succeeded, and the value of k2 is 
null.
   

----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
 
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org


With regards,
Apache Git Services

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscr...@doris.apache.org
For additional commands, e-mail: dev-h...@doris.apache.org

Reply via email to