[Bug] LikeState memory leak in BE

[cambyzju]

Search before asking

• I had searched in the issues and found no similar issues.

Version

1.2-lts

What's Wrong?

memory leak

What You Expected?

fix

How to Reproduce?

Create two table and insert some data:

> create table test_a (id int, comment string) duplicate key(id) distributed by hash(id) buckets 1 properties("replication_num"="1");
> create table test_b (id int, comment string) duplicate key(id) distributed by hash(id) buckets 1 properties("replication_num"="1");
> insert into test_a values(1, "hello");
> insert into test_b values(1, "hello");

run this SQL for a long time, we found memory leak:

> with temp_a as (select * from test_a where id = 1 and comment like '%hello%'), temp_b as (select * from test_b where id = 1) select * from temp_a join temp_b ON test_a.id = test_b.id;

Anything Else?

No response

Are you willing to submit PR?

• Yes I am willing to submit a PR!

Code of Conduct

• I agree to follow this project's Code of Conduct