[
https://issues.apache.org/jira/browse/ASTERIXDB-3316?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17810444#comment-17810444
]
ASF subversion and git services commented on ASTERIXDB-3316:
------------------------------------------------------------
Commit a909e18144a9ec05aef53119c45c369c323131c5 in asterixdb's branch
refs/heads/master from Peeyush Gupta
[ https://gitbox.apache.org/repos/asf?p=asterixdb.git;h=a909e18144 ]
[ASTERIXDB-3316][COMP] Stack overflow during query compilation
- user model changes: no
- storage format changes: no
- interface changes: no
Details:
This patch reverts part of the change introduced with the fix of
ASTERIXDB-3316 that caused the CancelUnnestWithNestedListifyRule
to not fire in some legitimate queries.
Change-Id: Id5b108888ffb7084f1314bf908ab7bcc9e3e764b
Reviewed-on: https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/18135
Reviewed-by: Peeyush Gupta <[email protected]>
Reviewed-by: Ali Alsuliman <[email protected]>
Tested-by: Jenkins <[email protected]>
> 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
> Labels: triaged
>
> 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)
