Multiple not like filter rewrites error

[hpphpp]

Steps to reproduce the behavior (Required)

中文论坛帖子https://forum.mirrorship.cn/t/topic/17023

reproduction step
create table test_regexp2(order_status varchar(1000),spec_code varchar(1000),product_name varchar(1000));
insert into test_regexp2 values(‘已发货’,‘Y1LS0700094’,‘高钙牛乳棒’);
select * from test_regexp2 where order_status = ‘已发货’ and spec_code not like ‘%test%’ and product_name not like ‘%差价%’ and product_name not like ‘%元红包%’ ;

this bug is cause by ConsolidateLikesRule this rule

Expected behavior (Required)

select one record

Real behavior (Required)

select empty set

StarRocks version (Required)

• You can get the StarRocks version by executing SQL select current_version()
  3.2.11 and 3.3.7

[before-Sunrise]

@satanson

[LiShuMing]

This should be already fixed by #53311

You can upgrade to 3.3.9 and recheck it.