You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@asterixdb.apache.org by "ASF subversion and git services (Jira)" <ji...@apache.org> on 2024/09/14 00:27:00 UTC
[jira] [Commented] (ASTERIXDB-3316) Stack overflow during query compilation
[ https://issues.apache.org/jira/browse/ASTERIXDB-3316?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17881727#comment-17881727 ]
ASF subversion and git services commented on ASTERIXDB-3316:
------------------------------------------------------------
Commit 362f09b0a33d0bde2627097db70c20fde20e7a5b in asterixdb's branch refs/heads/master from Peeyush Gupta
[ https://gitbox.apache.org/repos/asf?p=asterixdb.git;h=362f09b0a3 ]
[ASTERIXDB-3316][COMP] Stack overflow during query compilation
- user model changes: no
- storage format changes: no
- interface changes: no
Ext-ref: MB-63466
Change-Id: I0011cd5633bbf4f57fcf81566170f6989fe2565d
Reviewed-on: https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/18003
Integration-Tests: Jenkins <je...@fulliautomatix.ics.uci.edu>
Tested-by: Jenkins <je...@fulliautomatix.ics.uci.edu>
Reviewed-by: Peeyush Gupta <pe...@couchbase.com>
Reviewed-by: Ali Alsuliman <al...@gmail.com>
(cherry picked from commit 43b62b0c1f251bd9113c58572349e25c9b9da767)
Reviewed-on: https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/18885
> 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)