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

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Component/s: COMP - Compiler
• Assignee: Dmitry Lychagin
• Reporter: Dmitry Lychagin
• Created: 11/Feb/19 19:10
• Updated: 16/Feb/19 00:23
• Resolved: 12/Feb/19 19:27

Description

1. Create LineItem dataset
2. Create index on l_suppkey

     create index idx_LineItem_suppkey on LineItem (l_suppkey) type btree;
     

3. Run the following query

     select value count(*)
     from LineItem as c
     where
       ((c.l_suppkey < 100 + tobigint(random()/2)) and
       (c.l_suppkey > 5 + tobigint(random()/2)));
     

4. Error:

      java.lang.Exception: ASX1079: Compilation error: Could not infer type for variable '$$44'.
      

There's a range search on indexed field and search expressions are not a constants