Mailing-List: contact notifications-help@asterixdb.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@asterixdb.apache.org
Date: Sun, 22 Oct 2017 18:58:00 +0000 (UTC)
From: "Ildar Absalyamov (JIRA)" <jira@apache.org>
To: notifications@asterixdb.incubator.apache.org
Message-ID: <JIRA.12935421.1454228256000.29888.1508698680093@Atlassian.JIRA>
In-Reply-To: <JIRA.12935421.1454228256000@Atlassian.JIRA>
References: <JIRA.12935421.1454228256000@Atlassian.JIRA> <JIRA.12935421.1454228256857@jira-lw-us.apache.org>
Subject: [jira] [Resolved] (ASTERIXDB-1284) Introduce index rewrite does not
 properly consider type promotion
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit
archived-at: Sun, 22 Oct 2017 18:58:10 -0000


     [ https://issues.apache.org/jira/browse/ASTERIXDB-1284?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Ildar Absalyamov resolved ASTERIXDB-1284.
-----------------------------------------
    Resolution: Cannot Reproduce

The query returns correct index-based plan in 0.9.3-SNAPSHOT

> Introduce index rewrite does not properly consider type promotion
> -----------------------------------------------------------------
>
>                 Key: ASTERIXDB-1284
>                 URL: https://issues.apache.org/jira/browse/ASTERIXDB-1284
>             Project: Apache AsterixDB
>          Issue Type: Bug
>          Components: COMP - Compiler
>            Reporter: Ildar Absalyamov
>            Assignee: Ildar Absalyamov
>            Priority: Minor
>              Labels: soon
>
> The following query returns "Can't cast a value: 4.294967296E9 from INT64 type to INT32 type because of the out-of-range error. [AlgebricksException]"  error, while trying to apply index rewrite. The correct solution would be to prune the index and fall back to data scan, since the int64 predicate value is not demotable to int32.
> {noformat}
> drop dataverse tpch if exists;
> create dataverse tpch;
> use dataverse tpch;
> create type OrderType as open {
>   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 dataset Orders(OrderType) primary key o_orderkey;
> for $o in dataset('Orders')
> where $o.o_orderkey <=int64("4294967296")
> order by $o.o_orderkey
> return $o
> {noformat}


--
This message was sent by Atlassian JIRA
(v6.4.14#64029)