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