[Bug] insert after delete where like ‘%%’ on paritial update mode will get no data

[ryanzryu]

Search before asking

• [X] I had searched in the issues 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