[
https://issues.apache.org/jira/browse/ASTERIXDB-1602?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Yingyi Bu closed ASTERIXDB-1602.
--------------------------------
Resolution: Fixed
Fixed with regression tests.
> Nested subqueries in with clause throws StackOverflowError
> ----------------------------------------------------------
>
> Key: ASTERIXDB-1602
> URL: https://issues.apache.org/jira/browse/ASTERIXDB-1602
> Project: Apache AsterixDB
> Issue Type: Bug
> Environment: Master branch with latest change id
> I363df794c48644ca806958f583a05aea10a93166
> Reporter: Vignesh Raghunathan
> Assignee: Yingyi Bu
> Attachments: adblog.txt, tpcdsadb.txt
>
>
> To reproduce the issue, run the following sqlpp query after creating datasets
> using tpcdsadb.txt
> {code}
> use tpcds;
> with tab as
> (select *
> from item,
> date_dim d1
> where d1.d_date in
> (select d2.d_date
> from date_dim d2
> where d2.d_week_seq in
> (select d3.d_week_seq
> from date_dim d3
> where d3.d_date in
> [date('1998-01-02'),date('1998-10-15'),date('1998-11-10')]))
> group by i_item_id)
> select *
> from tab t1, tab t2;
> {code}
> Result:
> Please check adblog.txt
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
