[jira] [Assigned] (ASTERIXDB-1602) Nested subqueries in with clause throws StackOverflowError

["Yingyi Bu (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/ASTERIXDB-1602?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Yingyi Bu reassigned ASTERIXDB-1602:
------------------------------------

    Assignee: Yingyi Bu

> 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)