Details
-
Bug
-
Resolution: Fixed
-
Major
-
7.6.0
-
Untriaged
-
0
-
Unknown
-
Analytics Sprint 31, Analytics Sprint 32
Description
The following query causes Stack overflow error
drop dataverse test if exists;
|
create dataverse test;
|
use test;
|
|
|
create dataset collection0 primary key (id:int);
|
create dataset collection1 primary key (id:int);
|
create dataset collection2 primary key (id:int);
|
|
|
SELECT DISTINCT T1.*,
|
(SELECT H.u
|
FROM collection1 H
|
WHERE H.y_id = T1.x_id
|
AND H.a IN [12, 66, 67, 13, 26]
|
AND H.to_u = 'aaaaa'
|
AND H.b in
|
(SELECT value MAX(L.b)
|
FROM collection1 L
|
WHERE L.y_id = T1.x_id
|
AND L.a IN [12, 66, 67, 13, 26]
|
AND L.to_u = 'aaaaa')
|
) AS sub_query1,
|
(SELECT H.u
|
FROM collection1 H
|
WHERE H.y_id = T1.x_id
|
AND H.a IN [12, 66, 67, 13]
|
AND H.posi IN ['a','b']
|
AND H.b in
|
(SELECT value MAX(L.b)
|
FROM collection1 L
|
WHERE L.y_id = T1.x_id
|
AND L.posi IN ['a','b'])
|
) AS sub_query2
|
FROM (SELECT T0.x_id
|
FROM collection0 T0
|
) T1;
|
|
11:27:12.757 [HttpExecutor(port:19001)-0] WARN org.apache.hyracks.http.server.AbstractServlet - Unhandled throwable |
java.lang.StackOverflowError: null |
at org.apache.hyracks.algebricks.core.algebra.typing.PropagatingTypeEnvironment.getVarType(PropagatingTypeEnvironment.java:86) ~[classes/:?] |
at org.apache.hyracks.algebricks.core.algebra.properties.TypePropagationPolicy$1.getVarType(TypePropagationPolicy.java:46) ~[classes/:?] |
at org.apache.hyracks.algebricks.core.algebra.typing.PropagatingTypeEnvironment.getVarTypeFullList(PropagatingTypeEnvironment.java:108) ~[classes/:?] |
at org.apache.hyracks.algebricks.core.algebra.typing.PropagatingTypeEnvironment.getVarType(PropagatingTypeEnvironment.java:86) ~[classes/:?] |
at org.apache.hyracks.algebricks.core.algebra.properties.TypePropagationPolicy$1.getVarType(TypePropagationPolicy.java:46) ~[classes/:?] |
at org.apache.hyracks.algebricks.core.algebra.typing.PropagatingTypeEnvironment.getVarTypeFullList(PropagatingTypeEnvironment.java:108) ~[classes/:?] |
at org.apache.hyracks.algebricks.core.algebra.typing.PropagatingTypeEnvironment.getVarType(PropagatingTypeEnvironment.java:86) ~[classes/:?] |
at org.apache.hyracks.algebricks.core.algebra.properties.TypePropagationPolicy$1.getVarType(TypePropagationPolicy.java:46) ~[classes/:?] |
at org.apache.hyracks.algebricks.core.algebra.typing.PropagatingTypeEnvironment.getVarTypeFullList(PropagatingTypeEnvironment.java:108) ~[classes/:?] |
at org.apache.hyracks.algebricks.core.algebra.typing.PropagatingTypeEnvironment.getVarType(PropagatingTypeEnvironment.java:86) ~[classes/:?] |
at org.apache.hyracks.algebricks.core.algebra.properties.TypePropagationPolicy$1.getVarType(TypePropagationPolicy.java:46) ~[classes/:?] |
at org.apache.hyracks.algebricks.core.algebra.typing.PropagatingTypeEnvironment.getVarTypeFullList(PropagatingTypeEnvironment.java:108) ~[classes/:?] |
at org.apache.hyracks.algebricks.core.algebra.typing.PropagatingTypeEnvironment.getVarType(PropagatingTypeEnvironment.java:86) ~[classes/:?] |
at org.apache.hyracks.algebricks.core.algebra.properties.TypePropagationPolicy$1.getVarType(TypePropagationPolicy.java:46) ~[classes/:?] |