You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by GitBox <gi...@apache.org> on 2019/11/27 08:33:22 UTC

[GitHub] [incubator-doris] jmk1011 opened a new issue #2313: Insert a string type number to a LARGEINT column returns error

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:
users@infra.apache.org


With regards,
Apache Git Services

---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org