You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@doris.apache.org by GitBox <gi...@apache.org> on 2019/04/18 06:13:58 UTC
[GitHub] [incubator-doris] kangkaisen opened a new issue #955: Constant
predicate related bug
kangkaisen opened a new issue #955: Constant predicate related bug
URL: https://github.com/apache/incubator-doris/issues/955
## bug 1
```
select * from t1 join t2 on 1 = 2;
```
The result is
```
mysql> select * from t1 join t2 on 1 = 2;
+------+------+-------+------+------+-------+
| dt | id | value | dt | id | value |
+------+------+-------+------+------+-------+
| 8 | 1 | one | 9 | 11 | one |
| 8 | 1 | one | 9 | 12 | NULL |
| 8 | 1 | one | 8 | 1 | one |
| 8 | 1 | one | 8 | NULL | two |
| 9 | 11 | one | 9 | 11 | one |
| 9 | 11 | one | 9 | 12 | NULL |
| 9 | 11 | one | 8 | 1 | one |
| 9 | 11 | one | 8 | NULL | two |
| 8 | NULL | two | 9 | 12 | NULL |
| 8 | NULL | two | 9 | 11 | one |
| 8 | NULL | two | 8 | NULL | two |
| 8 | NULL | two | 8 | 1 | one |
| 9 | 12 | NULL | 9 | 12 | NULL |
| 9 | 12 | NULL | 9 | 11 | one |
| 9 | 12 | NULL | 8 | NULL | two |
| 9 | 12 | NULL | 8 | 1 | one |
+------+------+-------+------+------+-------+
16 rows in set (0.08 sec)
```
**The result is wrong, the right result should be 0 row.**
## bug 2
**step 1**: create the view with union:
```
CREATE VIEW `union_all_view` AS SELECT `t1`.`id` AS `id`, `t1`.`value` AS `value` FROM `default_cluster:test`.`t1` UNION ALL SELECT `t2`.`id` AS `id`, `t2`.`value` AS `value` FROM `default_cluster:test`.`t2`;
```
**step 2**: query the view with constant predicate and group by and order by
```
select count(*) from union_all_view where id = 1 and 1 = 2 group by id order by id;
```
there will be a exception:
```
2019-04-18 13:50:28,781 WARN 114 [StmtExecutor.analyze():452] Analyze failed because
java.lang.IllegalStateException
at com.google.common.base.Preconditions.checkState(Preconditions.java:134) ~[guava-15.0.jar:?]
at org.apache.doris.planner.UnionNode.init(UnionNode.java:239) ~[palo-fe.jar:?]
at org.apache.doris.planner.DistributedPlanner.createUnionNodeFragment(DistributedPlanner.java:650) ~[palo-fe.jar:?]
at org.apache.doris.planner.DistributedPlanner.createPlanFragments(DistributedPlanner.java:208) ~[palo-fe.jar:?]
at org.apache.doris.planner.DistributedPlanner.createPlanFragments(DistributedPlanner.java:189) ~[palo-fe.jar:?]
at org.apache.doris.planner.DistributedPlanner.createPlanFragments(DistributedPlanner.java:189) ~[palo-fe.jar:?]
at org.apache.doris.planner.DistributedPlanner.createPlanFragments(DistributedPlanner.java:97) ~[palo-fe.jar:?]
at org.apache.doris.planner.Planner.createPlanFragments(Planner.java:171) ~[palo-fe.jar:?]
at org.apache.doris.planner.Planner.plan(Planner.java:78) ~[palo-fe.jar:?]
at org.apache.doris.qe.StmtExecutor.analyze(StmtExecutor.java:440) [palo-fe.jar:?]
at org.apache.doris.qe.StmtExecutor.execute(StmtExecutor.java:201) [palo-fe.jar:?]
at org.apache.doris.qe.ConnectProcessor.handleQuery(ConnectProcessor.java:168) [palo-fe.jar:?]
at org.apache.doris.qe.ConnectProcessor.dispatch(ConnectProcessor.java:258) [palo-fe.jar:?]
at org.apache.doris.qe.ConnectProcessor.processOnce(ConnectProcessor.java:389) [palo-fe.jar:?]
at org.apache.doris.qe.ConnectProcessor.loop(ConnectProcessor.java:399) [palo-fe.jar:?]
at org.apache.doris.qe.ConnectScheduler$LoopHandler.run(ConnectScheduler.java:175) [palo-fe.jar:?]
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) [?:1.8.0_112]
at java.util.concurrent.FutureTask.run(FutureTask.java:266) [?:1.8.0_112]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [?:1.8.0_112]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [?:1.8.0_112]
at java.lang.Thread.run(Thread.java:745) [?:1.8.0_112]
2019-04-18 13:50:28,782 INFO 114 [StmtExecutor.execute():278] execute Exception.
org.apache.doris.common.AnalysisException: Unexpected exception: null
```
I think the root cause is we currently handle constant predicate is not very well.
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
With regards,
Apache Git Services
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@doris.apache.org
For additional commands, e-mail: dev-help@doris.apache.org