[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:
----------------------------------
Assignee: Steven Hawkins (was: Larry O'Leary)
The trunc function is supported by db2, but not derby. It would be best to consolidate
the implementation of the modfunctionmodifier with the one used for sybase/sqlserver and
to use functions supported by all of those sources. Note that the current
modfunctionmodifier for sybase/sqlserver actually implements the math function modulo, but
it should instead compute the remainder (which can be negative).
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: Steven Hawkins
Fix For: 6.2.0
Attachments: mylyn-context.zip, TEIID-486_connector-jdbc_200907101735.patch,
TEIID-486_connector-jdbc_200907231854.patch
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