jmk1011 opened a new issue #2313: Insert a string type number to a LARGEINT 
column returns error
URL: https://github.com/apache/incubator-doris/issues/2313
 
 
   **Describe the bug**
   Insert a string type number to a LARGEINT column returns error
   the error msg is inaccurate
   
   
![image](https://user-images.githubusercontent.com/18320438/69706872-93450600-1133-11ea-8efb-0cd7e156c51e.png)
   
   
   
   **To Reproduce**
   Steps to reproduce the behavior:
   create table like 
   CREATE TABLE table_name ( k1 BIGINT NULL, k2 BIGINT NULL, v1 TINYINT SUM 
NULL, v2 TINYINT REPLACE NULL, v3 TINYINT REPLACE_IF_NOT_NULL NULL, v4 SMALLINT 
REPLACE_IF_NOT_NULL NULL, v5 INT REPLACE_IF_NOT_NULL NULL, v6 BIGINT 
REPLACE_IF_NOT_NULL NULL, v7 LARGEINT REPLACE_IF_NOT_NULL NULL, v8 DATETIME 
REPLACE_IF_NOT_NULL NULL, v9 DATE REPLACE_IF_NOT_NULL NULL, v10 CHAR(10) 
REPLACE_IF_NOT_NULL NULL, v11 VARCHAR(6) REPLACE_IF_NOT_NULL NULL, v12 
DECIMAL(27,9) REPLACE_IF_NOT_NULL NULL ) AGGREGATE KEY(k1, k2) PARTITION BY 
RANGE(k1) ( PARTITION partition_a VALUES LESS THAN ("100000"), PARTITION 
partition_b VALUES LESS THAN ("1000000000"), PARTITION partition_c VALUES LESS 
THAN ("10000000000"), PARTITION partition_d VALUES LESS THAN MAXVALUE ) 
DISTRIBUTED BY HASH(k1, k2) BUCKETS 13;
   
   insert into table_name (v7) VALUES ("-30000");
   
   

----------------------------------------------------------------
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: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org

Reply via email to