[
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)
