Wenhai created ASTERIXDB-1355:
---------------------------------
Summary: Multiway UNION error
Key: ASTERIXDB-1355
URL: https://issues.apache.org/jira/browse/ASTERIXDB-1355
Project: Apache AsterixDB
Issue Type: Bug
Components: AsterixDB
Environment: General environment
Reporter: Wenhai
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]
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
