Peeyush Gupta created ASTERIXDB-3316:
----------------------------------------
Summary: 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
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)
