[teiid-issues] [JBoss JIRA] Resolved: (TEIID-941) MOD function in Postgres push down is producing connector error
Steven Hawkins (JIRA)
jira-events at lists.jboss.org
Tue Jan 26 12:53:19 EST 2010
[ https://jira.jboss.org/jira/browse/TEIID-941?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Steven Hawkins resolved TEIID-941.
----------------------------------
Fix Version/s: 7.0
Resolution: Done
Reused the modfunctionmodifer to compute mod for float and double types.
> MOD function in Postgres push down is producing connector error
> ---------------------------------------------------------------
>
> Key: TEIID-941
> URL: https://jira.jboss.org/jira/browse/TEIID-941
> Project: Teiid
> Issue Type: Bug
> Components: Query Engine
> Affects Versions: 7.0
> Reporter: Warren Gibson
> Assignee: Steven Hawkins
> Fix For: 7.0
>
>
> MOD function in Postgres push down is producing error on connector.
> Example:
> SELECT DoubleNum, 11, MOD(DoubleNum, 11) FROM BQT1.SmallA ORDER BY DoubleNum
> Error Code:0 Message:Error Code:0 Message:Error occurred on connector PostgreSQL_Push<14> - Error Code:0 Message:ERROR: function mod(double precision, numeric) does not exist Executing statement: [SQL: SELECT g_0."doublenum" AS c_0, 11 AS c_1, MOD(g_0."doublenum", 11.0) AS c_2 FROM "smalla" AS g_0 ORDER BY c_0]
--
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
More information about the teiid-issues
mailing list