wrong result when lowcardinality optimazation with multiple delete conditions

[stdpain]

Steps to reproduce the behavior (Required)

table dates was from SSB100g

create table dates_bak like dates;
insert into dates_bak select * from dates;
analyze full table dates_bak;

delete from dates_bak where d_yearmonth = "Jan1992";
delete from dates_bak where d_weekdayfl > 0 and d_yearmonth in ('Feb1992', 'Feb1993', 'Feb1994');
delete from dates_bak where d_yearmonth = "Jan1993";
delete from dates_bak where d_yearmonth = "Jan1994";

select count(*) from dates_bak;
-- run mulit times
select count(d_yearmonth) from dates_bak;

Expected behavior (Required)

mysql> select count(d_yearmonth) from dates_bak;
+--------------------+
| count(d_yearmonth) |
+--------------------+
|               2403 |
+--------------------+
1 row in set (0.01 sec)

Real behavior (Required)

mysql> select count(d_yearmonth) from dates_bak;
+--------------------+
| count(d_yearmonth) |
+--------------------+
|               2378 |
+--------------------+
1 row in set (0.01 sec)

StarRocks version (Required)

• main
• 2.0.4
• 2.1.4
• 2.2-rc01 2.2-rc02