[teiid-issues] [JBoss JIRA] (TEIID-2259) Error executing CASE WHEN THEN ELSE END statement

[Ivan Chan (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-2259?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12725457#comment-12725457 ] 

Ivan Chan commented on TEIID-2259:
----------------------------------

Including stacktrace, vds schema and sql.

SQL:

select sum(CASE WHEN ("DB2_public_employee"."hire_date" = "DB2_public_employee"."end_date")
IS NULL THEN 0 ELSE 1 END) as "DB2_public_employee_DateBool_Count"
from "DB2_public"."employee" "DB2_public_employee"
                
> Error executing CASE WHEN THEN ELSE END statement
> -------------------------------------------------
>
>                 Key: TEIID-2259
>                 URL: https://issues.jboss.org/browse/TEIID-2259
>             Project: Teiid
>          Issue Type: Feature Request
>          Components: Query Engine
>    Affects Versions: 8.1, 8.2
>         Environment: Running Teiid 8.1 embedded version on Windows
>            Reporter: Ivan Chan
>            Assignee: Steven Hawkins
>         Attachments: stacktrace.txt, vds.txt
>
>
> Error executing CASE WHEN THEN ELSE END statement with boolean expression in the WHEN clause

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira