[jira] [Created] (ASTERIXDB-1602) Nest subqueries in with clause throws StackOverflowError

[Vignesh Raghunathan (JIRA)]

Vignesh Raghunathan created ASTERIXDB-1602:
----------------------------------------------

             Summary: Nest 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


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)