[CALCITE-1778] Query with "WHERE CASE" throws AssertionError "Cast for just nullability not allowed"

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.13.0
• Assignee: Julian Hyde
• Reporter: Julian Hyde
• Created: 08/May/17 21:52
• Updated: 27/Feb/24 22:24
• Resolved: 09/May/17 01:51

Description

The following query throws "Cast for just nullability not allowed", just after ProjectFilterTransposeRule is invoked.

select count(*)
from emp
where case when mgr < 10 then true else false end