ryanzryu opened a new issue, #34296: URL: https://github.com/apache/doris/issues/34296
### 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 master doris-4.0.0-preview-6b9f132 ### What's Wrong? insert after delete where like ‘%%’ on paritial update mode will get no data ### What You Expected? get insert data after delete where like ‘%%’ ### How to Reproduce? create table test2 ( k varchar(200) null, v int null ) unique key (k) distributed by hash(k) buckets 1 properties("replication_num" = "1", "enable_unique_key_merge_on_write"="true", "disable_auto_compaction"="true"); set enable_unique_key_partial_update=true; set enable_insert_strict = false; insert into test2(k,v) values('a1',100); select * from test2 order by k; delete from test2 where k like '%a%'; select * from test2 order by k; insert into test2(k,v) values('a1',100); select * from test2 order by k; get no result from last query ### Anything Else? _No response_ ### Are you willing to submit PR? - [X] 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: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
