[
https://issues.jboss.org/browse/TEIID-5161?page=com.atlassian.jira.plugin...
]
dalex dalex commented on TEIID-5161:
------------------------------------
[~shawkins]
This isn't an issue with Teiid other than I missed that SQL
Server doesn't treat the rand function as non-deterministic. It is evaluated only once
per query.
Thx, that's interesting...
So it's probably safest to just not push to SQL Server.
let's remove then the:
{code:noformat}
if (getVersion().compareTo(TEN_0) >= 0) {
supportedFunctions.add("RAND"); //$NON-NLS-1$
}
{code}
in SQLServerExecutionFactory.getSupportedFunctions method
Push down rand() function
-------------------------
Key: TEIID-5161
URL:
https://issues.jboss.org/browse/TEIID-5161
Project: Teiid
Issue Type: Quality Risk
Components: JDBC Connector, Query Engine
Affects Versions: 9.3.4
Environment: teiid-9.3.4 on WildFly Full 10.0.0.Final (WildFly Core
2.0.10.Final)
Reporter: dalex dalex
Assignee: Steven Hawkins
Fix For: 10.1
Attachments: mssql_rand_function.jpg
As per discussion within TEIID-5153 we should push down rand() function where ever it
seems to be missing. But first of all the function should be pushed down for at least
PostgreSQL, MySQL, MSSQL and Oracle databases.
--
This message was sent by Atlassian JIRA
(v7.5.0#75005)