yongjinhou opened a new issue, #40128: URL: https://github.com/apache/doris/issues/40128
### Search before asking - [X] I had searched in the [issues](https://github.com/apache/doris/issues?q=is%3Aissue) and found no similar issues. ### Version 2.1.5 ### What's Wrong? 开启strict模式后不符合要求的数据导入成功 ### What You Expected? 开启strict模式后不符合要求的数据导入失败 ### How to Reproduce? 1.1. 建库建表 ``` CREATE DATABASE test_sys_insert_value_test_insert_value_special_data_db; ``` ``` CREATE TABLE test_sys_insert_value_test_insert_value_special_data_db.test_sys_insert_value_test_insert_value_special_data_tb ( k1 tinyint NULL, k2 smallint NULL, k3 int NULL, k4 bigint NULL, k5 decimal(9, 3) NULL, k6 char(5) NULL, k10 date NULL, k11 datetime NULL, k7 varchar(20) NULL, k8 double max NULL, k9 float sum NULL ) AGGREGATE KEY(k1,k2,k3,k4,k5,k6,k10,k11,k7) DISTRIBUTED BY HASH(k1) BUCKETS 5 PROPERTIES ("replication_allocation" = "tag.location.default: 1"); ``` 1.2. 设置严格模式 ``` SET enable_insert_strict=true; ``` 1.3. 插入数据 ``` insert into test_sys_insert_value_test_insert_value_special_data_tb(k6) values("hello world"); ``` 2.1. 建库建表 ``` CREATE DATABASE test_sys_insert_txn_test_txn_strict_db; ``` ``` CREATE TABLE test_sys_insert_txn_test_txn_strict_db.test_sys_insert_txn_test_txn_strict_tb ( k1 INT NOT NULL, v1 INT NOT NULL, v2 INT NOT NULL, v3 INT NOT NULL, v4 INT NOT NULL ) DISTRIBUTED BY HASH(k1) BUCKETS 5 PROPERTIES ("replication_allocation" = "tag.location.default: 1"); ``` 2.2. 开启事务 ``` BEGIN; ``` 2.3. 插入数据 ``` insert into test_sys_insert_txn_test_txn_strict_db.test_sys_insert_txn_test_txn_strict_tb values("a", "b", "1", "1", "1"); ``` ### Anything Else? 无 ### 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.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
