[jira] [Created] (CALCITE-1051) Underflow exception occurs when executing query which has an in-clause with more than 19 ids.

[Frankie Bollaert (JIRA)]

Frankie Bollaert created CALCITE-1051:
-----------------------------------------

             Summary: Underflow exception occurs when executing query which has 
an in-clause with more than 19 ids.
                 Key: CALCITE-1051
                 URL: https://issues.apache.org/jira/browse/CALCITE-1051
             Project: Calcite
          Issue Type: Bug
            Reporter: Frankie Bollaert
            Assignee: Julian Hyde
            Priority: Minor


Underflow exception occurs when executing query with more then 19 values in the 
in-clause.

Example below illustrates the problem in the csv example:
{code}
select e.name from emps as e where e.empno in (130, 130, 130, 130, 130, 130, 
130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130 );

Error: Error while executing SQL "select e.name from emps as e where e.empno in 
(130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 
130, 130, 130, 130, 130 )": Underflow (state=,code=0)
{code}

The SqlToRelConverter will convert this to a SemiJoin.  Literals in the IN 
clause value list are scaled.  When the type of the literal does not have a 
scale set, as happens with a java.lang.Integer, the default value of the 
type.scale is chosen, which is Integer.MIN_VALUE.  Scaling to this value causes 
the underflow.





--
This message was sent by Atlassian JIRA
(v6.3.4#6332)