[Bug] The result of the nested query with "NOT IN" is not correct

[Jianing-Xu]

Search before asking

• 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);

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

[wwbbcjeyc]

老哥，你怎么关闭了这个问题。是找到问了嘛。我这表有个类似的