[CALCITE-387] CompileException when cast TRUE to nullable boolean

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 0.9.1-incubating
• Assignee: Julian Hyde
• Reporter: Julian Hyde
• Created: 25/Aug/14 20:03
• Updated: 18/Oct/14 22:36
• Resolved: 28/Aug/14 01:44

Description

In contexts where boolean values can be null, we need to convert them to java.lang.Boolean. Query

select case when deptno = 10 then null else true end
from (values (10), (20)) as t(deptno)

gives

Caused by: org.codehaus.commons.compiler.CompileException: Line 25, Column 104: Incompatible expression types "java.lang.Boolean" and "boolean"
	at org.codehaus.janino.UnitCompiler.compileError(UnitCompiler.java:10064)
	at org.codehaus.janino.UnitCompiler.compileGet2(UnitCompiler.java:3643)
	at org.codehaus.janino.UnitCompiler.access$6600(UnitCompiler.java:181)
	at org.codehaus.janino.UnitCompiler$10.visitConditionalExpression(UnitCompiler.java:3268)

from compiling the generated code

            public Object current() {
              return net.hydromatic.optiq.runtime.SqlFunctions.toInt(inputEnumerator.current()) == 10 ? (Boolean) null : true;
            }