[
https://issues.apache.org/jira/browse/ASTERIXDB-1580?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15421905#comment-15421905
]
Yingyi Bu commented on ASTERIXDB-1580:
--------------------------------------
[~vignesh.raghunathan], the issue has already been fixed in the latest master
by previous changes. Can you generate even smaller scale dataset (which can
still produce meaningful results instead of empty result sets) so that I can
put the query and results into the regression tests? The dataset you provided
is great but still a bit too large to put into github. Ideally, we'd like the
dataset scale similar to tpch0.001 at asterixdb/asterix-app/data/tpch0.001/.
> 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)
