starocean999 opened a new issue, #10182: URL: https://github.com/apache/incubator-doris/issues/10182
### Search before asking - [X] I had searched in the [issues](https://github.com/apache/incubator-doris/issues?q=is%3Aissue) and found no similar issues. ### Version master ### What's Wrong? use tpch 1G data, and run the following sql: select count(*) from ( select l1.l_linenumber, l1.l_shipdate, l1.l_comment from lineitem l1 order by l_orderkey limit 100000 intersect select l2.l_linenumber, l2.l_comment, l2.l_shipdate from lineitem l2 order by l_orderkey limit 100000 intersect select l3.l_linenumber, l3.l_comment, l3.l_shipdate from lineitem l3 order by l_orderkey limit 100000 ) tmp; | count(*) | | ---- | | 0 | 1 row in set (10.46 sec) ### What You Expected? should take much less time like bellow: | count(*) | | ---- | | 0 | 1 row in set (0.36 sec) ### How to Reproduce? _No response_ ### 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: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
