weilai201 opened a new issue, #34551: URL: https://github.com/apache/doris/issues/34551
### 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.0.4 ### What's Wrong? --1. 先创建TEST1表 drop table IF EXISTS TEST1; CREATE TABLE IF NOT EXISTS `TEST1` ( `ID` int NULL COMMENT 'ID', `ID1` int NULL COMMENT 'ID1', `ID2` int NULL COMMENT 'ID2' ) UNIQUE KEY( `ID` ) DISTRIBUTED BY HASH(`ID`) BUCKETS AUTO PROPERTIES ( "replication_allocation" = "tag.location.default: 1", "enable_unique_key_merge_on_write" = "true", "store_row_column" = "true" ); -- 2. 表中插入一条记录 insert into TEST1(ID,ID1,ID2) values(1,1,1); select * from TEST1; 查询结果 <img width="220" alt="image" src="https://github.com/apache/doris/assets/12964080/cc1c5067-21f1-45b2-ba44-db14352f98a6";> -- 3. 删除此记录 delete from TEST1 where ID=1; --4. 设置部分更新 set enable_unique_key_partial_update=true; set enable_insert_strict=false; --5. 在此插入相同key值记录 insert into TEST1(ID,ID1) values(1,2); select * from TEST1; <img width="209" alt="image" src="https://github.com/apache/doris/assets/12964080/8745d7a8-8ee7-4f59-a89b-76fd1b34c5f6";> ### What You Expected? 上面第五步骤中期望结果为 <img width="219" alt="image" src="https://github.com/apache/doris/assets/12964080/ef71b9f2-d007-464a-b9b5-d2cf895f0c57";> ### How to Reproduce? _No response_ ### Anything Else? _No response_ ### 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
