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

Reply via email to