[ASTERIXDB-1355] Multiway UNION error

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Duplicate
• Component/s: *DB - AsterixDB
• Environment: General environment
• Flags: Patch
• Assignee: Yingyi Bu
• Reporter: Wenhai Li
• Created: 19/Mar/16 06:22
• Updated: 22/Jul/16 23:52
• Resolved: 22/Jul/16 23:52

Description

I am not sure whether the following query is legal, but it really poses an internel error.
Schemas

drop dataverse tpch if exists;
create dataverse tpch;

use dataverse tpch;

create type LineItemType as closed {
  l_orderkey: int32, 
  l_partkey: int32, 
  l_suppkey: int32, 
  l_linenumber: int32, 
  l_quantity: int32, 
  l_extendedprice: double,
  l_discount: double, 
  l_tax: double,
  l_returnflag: string, 
  l_linestatus: string, 
  l_shipdate: string,
  l_commitdate: string, 
  l_receiptdate: string, 
  l_shipinstruct: string, 
  l_shipmode: string, 
  l_comment: string
}

create type OrderType as closed {
  o_orderkey: int32, 
  o_custkey: int32, 
  o_orderstatus: string, 
  o_totalprice: double, 
  o_orderdate: string, 
  o_orderpriority: string,
  o_clerk: string, 
  o_shippriority: int32, 
  o_comment: string
}
create type PartSuppType as closed {
  ps_partkey: int32, 
  ps_suppkey: int32,
  ps_availqty: int32,
  ps_supplycost: double,
  ps_comment: string 
}
create dataset LineItem(LineItemType)
  primary key l_orderkey, l_linenumber;
create dataset Orders(OrderType)
  primary key o_orderkey;
create dataset Partsupp(PartSuppType)
  primary key ps_partkey, ps_suppkey; 

Query:

use dataverse tpch;

let $l := for $r in dataset LineItem where $r.l_orderkey = 1
return $r.l_linenumber
let $o := for $s in dataset Orders where $s.o_orderkey = 2
return $s.o_custkey
let $s := for $t in dataset Partsupp where $t.ps_parkey = 3
return $t.ps_suppkey
let $c := $l union $o union $s
return $c

Error:

-7 [ArrayIndexOutOfBoundsException]

Issue Links

• duplicates: ASTERIXDB-1354 Foreign key select error of UNION