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

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

Dmitry Lychagin created ASTERIXDB-2519:
------------------------------------------

             Summary: 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


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