13671653088 opened a new issue #7527: URL: https://github.com/apache/incubator-doris/issues/7527
### Search before asking - [X] I had searched in the [issues](https://github.com/apache/incubator-doris/issues?q=is%3Aissue) and found no similar issues. ### Version Both 0.14.12.4 ant 0.15.1-rc03 ### What's Wrong? When I select value 169 from a bigint column in source table, and insert into the tinyint column in target table. It seem success but the value becomes -87. ### What You Expected? May be it should show "Number out of range[169]. type: TINYINT" ### How to Reproduce? -- create target table `CREATE TABLE test.test ( id int(11) NULL COMMENT "", abc tinyint replace_if_not_null NULL Comment"" ) ENGINE=OLAP AGGREGATE KEY(id) COMMENT "OLAP" DISTRIBUTED BY HASH(id) BUCKETS 6 PROPERTIES ( "replication_allocation" = "tag.location.default: 3", "in_memory" = "false", "storage_format" = "V2" );` -- Input some test data `insert into test.test(id,abc) select 1,100;` -- Number out of range[169]. type: TINYINT `insert into test.test(id,abc) select 2,169;` -- create source table `CREATE TABLE test.test1 ( id int(11) NULL COMMENT "", abc bigint replace_if_not_null NULL Comment"" ) ENGINE=OLAP AGGREGATE KEY(id) COMMENT "OLAP" DISTRIBUTED BY HASH(id) BUCKETS 6 PROPERTIES ( "replication_allocation" = "tag.location.default: 3", "in_memory" = "false", "storage_format" = "V2" );` -- Input some test data `insert into test.test1(id,abc) select 1,100;` `insert into test.test1(id,abc) select 2,169;` -- It seem success but the value becomes -87. `insert into test.test(id,abc) select * from test.test1;` `select * from test.test` ### Anything Else? global variables enable_insert_strict=true ### Are you willing to submit PR? - [ ] Yes I am willing to submit a PR! ### Code of Conduct - [X] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct) -- 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. To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
