asterixdb-notifications mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Wenhai (JIRA)" <j...@apache.org>
Subject [jira] [Created] (ASTERIXDB-1355) Multiway UNION error
Date Sat, 19 Mar 2016 06:22:33 GMT
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)

Mime
View raw message