[
https://issues.jboss.org/browse/TEIID-2259?page=com.atlassian.jira.plugin...
]
Steven Hawkins commented on TEIID-2259:
---------------------------------------
Do you mean to use ("DB2_public_employee"."hire_date" =
"DB2_public_employee"."end_date") IS NULL? That would have a simple
workaround using coalesce.
In any case that is a valid boolean expression for Teiid and with our or for example
oracle precedence the parens are optional, but it looks like postgresql uses a higher
precedence for IS, which results in the error you're seeing. So we need to tweak the
sql generated for postgresql to prevent this.
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