[jira] [Commented] (ASTERIXDB-2519) Compiler error caused by index selection when search expression is not constant

["ASF subversion and git services (JIRA)" <ji...@apache.org>]

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

ASF subversion and git services commented on ASTERIXDB-2519:
------------------------------------------------------------

Commit 99d970d01ab41263756d5063ee7fb460a24b2dfb in asterixdb's branch refs/heads/master from Dmitry Lychagin
[ https://gitbox.apache.org/repos/asf?p=asterixdb.git;h=99d970d ]

[ASTERIXDB-2519][COMP] Fix compiler error with range predicate

- user model changes: no
- storage format changes: no
- interface changes: no

Details:
- Fix compiler error (Could not infer type for variable ...)
  when non-constant expressions are used in the range predicate

Change-Id: I8896e6c0743dcd5b608ebd5a5f25d3077047c789
Reviewed-on: https://asterix-gerrit.ics.uci.edu/3187
Sonar-Qube: Jenkins <je...@fulliautomatix.ics.uci.edu>
Tested-by: Jenkins <je...@fulliautomatix.ics.uci.edu>
Integration-Tests: Jenkins <je...@fulliautomatix.ics.uci.edu>
Reviewed-by: Ali Alsuliman <al...@gmail.com>


> Compiler error caused by index selection when search expression is not constant
> -------------------------------------------------------------------------------
>
>                 Key: ASTERIXDB-2519
>                 URL: https://issues.apache.org/jira/browse/ASTERIXDB-2519
>             Project: Apache AsterixDB
>          Issue Type: Bug
>          Components: COMP - Compiler
>            Reporter: Dmitry Lychagin
>            Assignee: Dmitry Lychagin
>            Priority: Major
>
> # Create LineItem dataset
> # Create index on l_suppkey 
>   {noformat}
>   create index idx_LineItem_suppkey on LineItem (l_suppkey) type btree;
>   {noformat}
>  # Run the following query
>   {noformat}
>   select value count(*)
>   from LineItem as c
>   where
>     ((c.l_suppkey < 100 + tobigint(random()/2)) and
>     (c.l_suppkey > 5 + tobigint(random()/2)));
>   {noformat}
>  # Error:
>    {noformat}
>    java.lang.Exception: ASX1079: Compilation error: Could not infer type for variable '$$44'.
>    {noformat}
> There's a range search on indexed field and search expressions are not a constants



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