[CALCITE-2596] AssertionError: Not-null boxed primitive should come back as primitive when translating correlated variables

• Type: Bug
• Status: Closed
• Priority: Blocker
• Resolution: Fixed
• Affects Version/s: 1.17.0
• Fix Version/s: 1.18.0
• Component/s: core
• Assignee: Julian Hyde
• Reporter: Stamatis Zampetakis
• Created: 26/Sep/18 11:55
• Updated: 23/Dec/18 00:12
• Resolved: 04/Dec/18 09:05

Description

Queries introducing correlated variables on boxed primitive fields throw an assertion error when they are translated to generated code in the Enumerable convention.

For example, consider the following query where e.commission is a field of type Integer:

SELECT empid FROM emps e 
WHERE NOT EXISTS 
     (SELECT 1 FROM depts d WHERE d.deptno=e.commission)

 

Issue Links

• blocks: CALCITE-2575 Release Calcite 1.18.0
• links to: PR#868