[jira] [Resolved] (ASTERIXDB-2448) NullPointerException in IntroduceSelectAccessMethodRule with 2 indexes and between operator

["Dmitry Lychagin (JIRA)" <ji...@apache.org>]

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

Dmitry Lychagin resolved ASTERIXDB-2448.
----------------------------------------
    Resolution: Fixed

Fixed by https://asterix-gerrit.ics.uci.edu/#/c/2937/

> NullPointerException in IntroduceSelectAccessMethodRule with 2 indexes and between operator
> -------------------------------------------------------------------------------------------
>
>                 Key: ASTERIXDB-2448
>                 URL: https://issues.apache.org/jira/browse/ASTERIXDB-2448
>             Project: Apache AsterixDB
>          Issue Type: Bug
>          Components: COMP - Compiler
>            Reporter: Dmitry Lychagin
>            Assignee: Dmitry Lychagin
>            Priority: Major
>
> NullPointerException is thrown when index intersection is chosen by the IntroduceSelectAccessMethodRule and there's a between operator.
> DDL: 
> create index idx_custkey on Orders (o_custkey) type btree;
> create index idx_orderpriority on Orders (o_orderpriority) type btree;
> Query:
> select o_custkey, o_orderkey, o_orderstatus from Orders
> where
>  o_orderpriority = '1-URGENT' and
>  o_custkey between 40 and 43
> order by o_custkey, o_orderkey
> Exception:
> java.lang.NullPointerException: null
>  at org.apache.asterix.optimizer.rules.am.IntroduceSelectAccessMethodRule.connectAll2ndarySearchPlanWithIntersect(IntroduceSelectAccessMethodRule.java:264) ~[classes/:?]
>  at org.apache.asterix.optimizer.rules.am.IntroduceSelectAccessMethodRule.intersectAllSecondaryIndexes(IntroduceSelectAccessMethodRule.java:232) ~[classes/:?]
> Workaround:
> Use "<=" and ">=" instead of "between"
>  
>  



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)