-
Notifications
You must be signed in to change notification settings - Fork 3.7k
Description
my version update frome 0.12.rc03 to 0.12.19-release , bug my old sql is error.
example :
mysql> select distinct country
-> from
-> (
-> select distinct country from my_users
-> ) t2
-> where country > 1;
ERROR 1064 (HY000): errCode = 2, detailMessage = Unexpected exception: null
the log error is ::
WARN 1175 [StmtExecutor.analyze():492] Analyze failed because
java.lang.NullPointerException: null
at org.apache.doris.planner.SingleNodePlanner.getPredicatesBoundedByGroupbysSourceExpr(SingleNodePlanner.java:2023) ~[palo-fe.jar:?]
at org.apache.doris.planner.SingleNodePlanner.pushDownPredicatesPastAggregation(SingleNodePlanner.java:1998) ~[palo-fe.jar:?]
at org.apache.doris.planner.SingleNodePlanner.pushDownPredicates(SingleNodePlanner.java:1939) ~[palo-fe.jar:?]
at org.apache.doris.planner.SingleNodePlanner.createQueryPlan(SingleNodePlanner.java:222) ~[palo-fe.jar:?]
at org.apache.doris.planner.SingleNodePlanner.createInlineViewPlan(SingleNodePlanner.java:1016) ~[palo-fe.jar:?]
at org.apache.doris.planner.SingleNodePlanner.createTableRefNode(SingleNodePlanner.java:1581) ~[palo-fe.jar:?]
at org.apache.doris.planner.SingleNodePlanner.createSelectPlan(SingleNodePlanner.java:683) ~[palo-fe.jar:?]
at org.apache.doris.planner.SingleNodePlanner.createQueryPlan(SingleNodePlanner.java:224) ~[palo-fe.jar:?]
at org.apache.doris.planner.SingleNodePlanner.createSingleNodePlan(SingleNodePlanner.java:151) ~[palo-fe.jar:?]
at org.apache.doris.planner.Planner.createPlanFragments(Planner.java:144) ~[palo-fe.jar:?]
at org.apache.doris.planner.Planner.plan(Planner.java:76) ~[palo-fe.jar:?]
at org.apache.doris.qe.StmtExecutor.analyze(StmtExecutor.java:482) ~[palo-fe.jar:?]
at org.apache.doris.qe.StmtExecutor.execute(StmtExecutor.java:228) ~[palo-fe.jar:?]
at org.apache.doris.qe.ConnectProcessor.handleQuery(ConnectProcessor.java:183) ~[palo-fe.jar:?]
at org.apache.doris.qe.ConnectProcessor.dispatch(ConnectProcessor.java:315) ~[palo-fe.jar:?]
at org.apache.doris.qe.ConnectProcessor.processOnce(ConnectProcessor.java:500) ~[palo-fe.jar:?]
at org.apache.doris.mysql.nio.ReadListener.lambda$handleEvent$0(ReadListener.java:50) ~[palo-fe.jar:?]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [?:1.8.0_172]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0_172]
at java.lang.Thread.run(Thread.java:748) [?:1.8.0_172]