cambyzju opened a new issue, #30319: URL: https://github.com/apache/doris/issues/30319
### 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 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? - [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: commits-unsubscr...@doris.apache.org.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org