SamuelBin opened a new issue, #24085: URL: https://github.com/apache/doris/issues/24085
### 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.6 ### What's Wrong? sql： set runtime_filter_type = 'IN_OR_BLOOM_FILTER,BITMAP_FILTER'; SELECT uid FROM db_test.user AS au WHERE au.uid IN (SELECT at.uid FROM db_test.tag AS at AND at.id = '157494391112458240' ) or au.createTime < '2023-09-07 00:00:00') user是用户表 au.uid是 long类型。tag是标签表 at.uid 是bitmap类型 下面的or au.createTime < '2023-09-07 00:00:00' 换成 and au.createTime < '2023-09-07 00:00:00'就能执行通过 报错 2023-09-08 11:36:22,730 WARN (mysql-nio-pool-13632|283706) [StmtExecutor.execute():593] execute Exception. stmt[5514794, a859c51bcbd94a6a-b94d438868ed7a5a] java.lang.IllegalArgumentException: toThrift in BitmapFilterPredicate should not be reached! at com.google.common.base.Preconditions.checkArgument(Preconditions.java:142) ~[guava-30.0-jre.jar:?] at org.apache.doris.analysis.BitmapFilterPredicate.toThrift(BitmapFilterPredicate.java:98) ~[doris-fe.jar:1.2-SNAPSHOT] at org.apache.doris.analysis.Expr.treeToThriftHelper(Expr.java:961) ~[doris-fe.jar:1.2-SNAPSHOT] at org.apache.doris.analysis.Expr.treeToThriftHelper(Expr.java:964) ~[doris-fe.jar:1.2-SNAPSHOT] at org.apache.doris.analysis.Expr.treeToThrift(Expr.java:940) ~[doris-fe.jar:1.2-SNAPSHOT] at org.apache.doris.planner.PlanNode.treeToThriftHelper(PlanNode.java:585) ~[doris-fe.jar:1.2-SNAPSHOT] at org.apache.doris.planner.PlanNode.treeToThrift(PlanNode.java:558) ~[doris-fe.jar:1.2-SNAPSHOT] at org.apache.doris.planner.PlanFragment.toThrift(PlanFragment.java:281) ~[doris-fe.jar:1.2-SNAPSHOT] at org.apache.doris.qe.Coordinator$FragmentExecParams.toThrift(Coordinator.java:2354) ~[doris-fe.jar:1.2-SNAPSHOT] at org.apache.doris.qe.Coordinator.sendFragment(Coordinator.java:608) ~[doris-fe.jar:1.2-SNAPSHOT] at org.apache.doris.qe.Coordinator.exec(Coordinator.java:553) ~[doris-fe.jar:1.2-SNAPSHOT] at org.apache.doris.qe.StmtExecutor.sendResult(StmtExecutor.java:1142) ~[doris-fe.jar:1.2-SNAPSHOT] at org.apache.doris.qe.StmtExecutor.handleQueryStmt(StmtExecutor.java:1122) ~[doris-fe.jar:1.2-SNAPSHOT] at org.apache.doris.qe.StmtExecutor.execute(StmtExecutor.java:522) ~[doris-fe.jar:1.2-SNAPSHOT] at org.apache.doris.qe.StmtExecutor.execute(StmtExecutor.java:409) ~[doris-fe.jar:1.2-SNAPSHOT] at org.apache.doris.qe.ConnectProcessor.handleQuery(ConnectProcessor.java:330) ~[doris-fe.jar:1.2-SNAPSHOT] at org.apache.doris.qe.ConnectProcessor.dispatch(ConnectProcessor.java:473) ~[doris-fe.jar:1.2-SNAPSHOT] at org.apache.doris.qe.ConnectProcessor.processOnce(ConnectProcessor.java:700) ~[doris-fe.jar:1.2-SNAPSHOT] at org.apache.doris.mysql.ReadListener.lambda$handleEvent$0(ReadListener.java:52) ~[doris-fe.jar:1.2-SNAPSHOT] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) ~[?:1.8.0_342] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) ~[?:1.8.0_342] ### What You Expected? 在in子查询为bitmap的时候，并且使用or条件查询，sql能正常返回结果 ### 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: 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
