[
https://issues.apache.org/jira/browse/ASTERIXDB-3316?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17796485#comment-17796485
]
ASF subversion and git services commented on ASTERIXDB-3316:
------------------------------------------------------------
Commit 43b62b0c1f251bd9113c58572349e25c9b9da767 in asterixdb's branch
refs/heads/master from Peeyush Gupta
[ https://gitbox.apache.org/repos/asf?p=asterixdb.git;h=43b62b0c1f ]
[ASTERIXDB-3316][COMP] Stack overflow during query compilation
- user model changes: no
- storage format changes: no
- interface changes: no
Change-Id: I0011cd5633bbf4f57fcf81566170f6989fe2565d
Reviewed-on: https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/18003
Integration-Tests: Jenkins <[email protected]>
Tested-by: Jenkins <[email protected]>
Reviewed-by: Peeyush Gupta <[email protected]>
Reviewed-by: Ali Alsuliman <[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)
