Uploaded image for project: 'Apache AsterixDB'
  1. Apache AsterixDB
  2. ASTERIXDB-1580

Subquery in having clause throws ArrayIndexOutOfBoundsException

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None

      Description

      The following sqlpp query throws an ArrayIndexOutOfBoundsException

      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;
      

      tpcdsq6.zip contains the schema and data for the datasets used in the query

        Attachments

        1. logs.zip
          94 kB
          Vignesh Raghunathan

          Activity

            People

            • Assignee:
              buyingyi Yingyi Bu
              Reporter:
              vignesh.raghunathan90 Vignesh Raghunathan
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: