[
https://issues.apache.org/jira/browse/CALCITE-1778?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16001625#comment-16001625
]
Julian Hyde commented on CALCITE-1778:
--------------------------------------
Test case: https://github.com/julianhyde/calcite/tree/1778-where-case
> Query with "WHERE CASE" throws AssertionError "Cast for just nullability not
> allowed"
> -------------------------------------------------------------------------------------
>
> Key: CALCITE-1778
> URL: https://issues.apache.org/jira/browse/CALCITE-1778
> Project: Calcite
> Issue Type: Bug
> Reporter: Julian Hyde
> Assignee: Julian Hyde
>
> The following query throws "Cast for just nullability not allowed", just
> after {{ProjectFilterTransposeRule}} is invoked.
> {code}
> select count(*)
> from emp
> where case when mgr < 10 then true else false end
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)