You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@asterixdb.apache.org by "Yingyi Bu (JIRA)" <ji...@apache.org> on 2016/08/17 05:00:27 UTC
[jira] [Resolved] (ASTERIXDB-1580) Subquery in having clause throws
ArrayIndexOutOfBoundsException
[ https://issues.apache.org/jira/browse/ASTERIXDB-1580?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Yingyi Bu resolved ASTERIXDB-1580.
----------------------------------
Resolution: Fixed
Already fixed in the master.
Regression tests added in the following change:
https://github.com/apache/asterixdb/commit/e61534ee0c7dfc0e2f5ce2d70511f7daa5e45e3b
> Subquery in having clause throws ArrayIndexOutOfBoundsException
> ---------------------------------------------------------------
>
> Key: ASTERIXDB-1580
> URL: https://issues.apache.org/jira/browse/ASTERIXDB-1580
> Project: Apache AsterixDB
> Issue Type: Bug
> Reporter: Vignesh Raghunathan
> Assignee: Yingyi Bu
> Attachments: logs.zip
>
>
> The following sqlpp query throws an ArrayIndexOutOfBoundsException
> {code}
> use tpcds;
> select a.ca_state state, count(a) cnt
> from customer_address a
> ,customer c
> ,store_sales s
> ,date_dim d
> ,item i
> where a.ca_address_sk = c.c_current_addr_sk
> and c.c_customer_sk = s.ss_customer_sk
> and s.ss_sold_date_sk = d.d_date_sk
> and s.ss_item_sk = i.i_item_sk
> group by a.ca_state group as stategrp
> having coll_count((select value a from stategrp)) >= 10
> order by cnt
> limit 100;
> {code}
> tpcdsq6.zip contains the schema and data for the datasets used in the query
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)