6:17 p.m.
Ivan Chan created TEIID-2259:
--------------------------------
Summary: 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
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
6:17 p.m.
[
https://issues.jboss.org/browse/TEIID-2259?page=com.atlassian.jira.plugin...
]
Ivan Chan updated TEIID-2259:
-----------------------------
Attachment: stacktrace.txt
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
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
6:19 p.m.
[
https://issues.jboss.org/browse/TEIID-2259?page=com.atlassian.jira.plugin...
]
Ivan Chan updated TEIID-2259:
-----------------------------
Attachment: vds.txt
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
6:21 p.m.
[
https://issues.jboss.org/browse/TEIID-2259?page=com.atlassian.jira.plugin...
]
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
8:10 p.m.
[
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
9:28 a.m.
[
https://issues.jboss.org/browse/TEIID-2259?page=com.atlassian.jira.plugin...
]
Steven Hawkins resolved TEIID-2259.
-----------------------------------
Fix Version/s: 8.2
Resolution: Done
I misspoke, parens are required for Teiid also. The fix ensures that nested conditions
are in parens. Also added precedence tables in the expression/criteria sections of the
reference.
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
Fix For: 8.2
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
1:02 p.m.
[
https://issues.jboss.org/browse/TEIID-2259?page=com.atlassian.jira.plugin...
]
Ivan Chan commented on TEIID-2259:
----------------------------------
Yes, your workaround works perfectly. Thanks!
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
Fix For: 8.2
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
8:41 a.m.
[
https://issues.jboss.org/browse/TEIID-2259?page=com.atlassian.jira.plugin...
]
Steven Hawkins updated TEIID-2259:
----------------------------------
Affects Version/s: 7.7
(was: 8.1)
(was: 8.2)
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: 7.7
Environment: Running Teiid 8.1 embedded version on Windows
Reporter: Ivan Chan
Assignee: Steven Hawkins
Fix For: 8.2
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
4200
days inactive
4241
days old
7 comments
2 participants
participants (2)
-
Ivan Chan (JIRA) -
Steven Hawkins (JIRA)