Details
-
Bug
-
Resolution: Fixed
-
Major
-
7.1.0
-
Untriaged
-
1
-
Unknown
-
CX Sprint 270
Description
The query is
select count (*) from orders o, lineitem l, customer c
|
where tobigint (l.l_orderkey) = (o.o_orderkey)
|
and (o.o_custkey+l.l_orderkey) = c.c_custkey +l.l_orderkey;
|
The stack trace is as follows:
2021-11-12T16:06:37.866-08:00 INFO CBAS.messaging.CCMessageBroker [Executor-31:ClusterController] Received message: ExecuteStatementRequestMessage(id=4, from=2e34b8157f6115c9b7ce726f115857c2): <ud>explain select count (*) from orders o, lineitem l, customer c\nwhere tobigint (l.l_orderkey) = (o.o_orderkey)\nand (o.o_custkey+l.l_orderkey) = c.c_custkey +l.l_orderkey;</ud>
|
2021-11-12T16:06:37.947-08:00 INFO CBAS.translator.QueryTranslator [QueryTranslator:c303423b-bc92-479d-b61b-808035139766] null
|
java.lang.NullPointerException: null
|
at org.apache.asterix.om.typecomputer.impl.TypeComputeUtils.getActualType(TypeComputeUtils.java:206) ~[asterix-om-7.0.1-0000.jar:7.0.1-0000]
|
at org.apache.asterix.om.typecomputer.impl.TypeComputeUtils.getActualType(TypeComputeUtils.java:185) ~[asterix-om-7.0.1-0000.jar:7.0.1-0000]
|
at org.apache.asterix.om.typecomputer.impl.TypeComputeUtils.resolveResultType(TypeComputeUtils.java:90) ~[asterix-om-7.0.1-0000.jar:7.0.1-0000]
|
at org.apache.asterix.om.typecomputer.base.AbstractResultTypeComputer.computeType(AbstractResultTypeComputer.java:44) ~[asterix-om-7.0.1-0000.jar:7.0.1-0000]
|
at org.apache.asterix.dataflow.data.common.ExpressionTypeComputer.getTypeForFunction(ExpressionTypeComputer.java:70) ~[asterix-om-7.0.1-0000.jar:7.0.1-0000]
|
at org.apache.asterix.dataflow.data.common.ExpressionTypeComputer.getType(ExpressionTypeComputer.java:52) ~[asterix-om-7.0.1-0000.jar:7.0.1-0000]
|
at org.apache.hyracks.algebricks.core.algebra.typing.AbstractTypeEnvironment.getType(AbstractTypeEnvironment.java:45) ~[algebricks-core-7.0.1-0000.jar:7.0.1-0000]
|
at org.apache.asterix.om.typecomputer.impl.TypeComputeUtils.resolveResultType(TypeComputeUtils.java:86) ~[asterix-om-7.0.1-0000.jar:7.0.1-0000]
|