[
https://issues.apache.org/jira/browse/ASTERIXDB-3316?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Peeyush Gupta resolved ASTERIXDB-3316.
--------------------------------------
Resolution: Fixed
> Stack overflow during query compilation
> ---------------------------------------
>
> Key: ASTERIXDB-3316
> URL: https://issues.apache.org/jira/browse/ASTERIXDB-3316
> Project: Apache AsterixDB
> Issue Type: Bug
> Components: COMP - Compiler
> Reporter: Peeyush Gupta
> Priority: Major
>
> The following query causes Stack overflow error
> {noformat}
> 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;
> {noformat}
>
>
>
>
>
>
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
