asterixdb-notifications mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Till Westmann (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (ASTERIXDB-1355) Multiway UNION error
Date Mon, 16 May 2016 22:43:13 GMT

    [ https://issues.apache.org/jira/browse/ASTERIXDB-1355?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15285573#comment-15285573
] 

Till Westmann commented on ASTERIXDB-1355:
------------------------------------------

Maybe related to ASTERIXDB-1406? "-7" seems to be an interesting array index ..

> 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
> {noformat}
> 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; 
> {noformat}
> Query:
> {noformat}
> 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
> {noformat}
> Error:
> {noformat}
> -7 [ArrayIndexOutOfBoundsException]
> {noformat}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message