[X] I had searched in the issues and found no similar issues.
Version
doris-2.0.5-rc02
What's Wrong?
When the subquery returns a large amount of data (approximately 350,000), a nested query with "NOT IN" can lead to errors, while the statement with "IN" works correctly.
What You Expected?
The query statement using not in returns the correct result
How to Reproduce?
select count(*) from t1 where id not in (select t1id from t2);
Search before asking
Version
doris-2.0.5-rc02
What's Wrong?
When the subquery returns a large amount of data (approximately 350,000), a nested query with "NOT IN" can lead to errors, while the statement with "IN" works correctly.
What You Expected?
The query statement using not in returns the correct result
How to Reproduce?
select count(*) from t1 where id not in (select t1id from t2);
Anything Else?
No response
Are you willing to submit PR?
Code of Conduct