[ https://issues.apache.org/jira/browse/ASTERIXDB-1580?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15429365#comment-15429365 ]
Vignesh Raghunathan commented on ASTERIXDB-1580: ------------------------------------------------ Reopened because the two queries "select value a from stategrp" looks equivalent to "select value stategrp.a from stategrp" I understand that a is syntactic sugar for the second query after the group by clause but I don't get why that's stopping the first query from working. Could you elaborate on the 'materialization of the value a' part? > 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)