[teiid-issues] [JBoss JIRA] Reopened: (TEIID-486) MOD() scalar function should be supported by DB2 Connector
[
https://jira.jboss.org/jira/browse/TEIID-486?page=com.atlassian.jira.plug...
]
Steven Hawkins reopened TEIID-486:
----------------------------------
There is a mismatch between our mod and db2's mod support. db2 only allows short,
int, and long. We additionally allow for float, double, and biginteger. The
org.teiid.connector.jdbc.sybase.ModFunctionModifier compensates for this mismatch in
sybase. The same approach should work for db2.
MOD() scalar function should be supported by DB2 Connector
----------------------------------------------------------
Key: TEIID-486
URL: https://jira.jboss.org/jira/browse/TEIID-486
Project: Teiid
Issue Type: Feature Request
Components: JDBC Connector
Affects Versions: 6.0.0
Reporter: Larry O'Leary
Assignee: Larry O'Leary
Fix For: 6.2.0
Time Spent: 15 minutes
Remaining Estimate: 15 minutes
An issue was logged in where a function that resulted in the use of the mod() scalar
function would result in a different query plan causing the queries criteria not to be
pushed-down to the source. It appears the cause of the misbehaved query plan was the DB2
connector not supporting the MOD() scalar function.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira