Gabriel39 opened a new issue, #10715: URL: https://github.com/apache/doris/issues/10715
### 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? When I set runtime_filter_type=1 which means IN runtime filter is forced to used, all data will be filtered in some cases ### What You Expected? get correct result ### How to Reproduce? TPCDS 1g WITH ws_wh AS ( SELECT ws1.ws_order_number , ws1.ws_warehouse_sk wh1 , ws2.ws_warehouse_sk wh2 FROM web_sales ws1 , web_sales ws2 WHERE (ws1.ws_order_number = ws2.ws_order_number) AND (ws1.ws_warehouse_sk <> ws2.ws_warehouse_sk) ) SELECT count(wr_order_number) FROM web_returns , ws_wh WHERE (wr_order_number = ws_wh.ws_order_number); ### 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
