[teiid-issues] [JBoss JIRA] (TEIID-5161) Push down rand() function

[Steven Hawkins (JIRA)]

     [ https://issues.jboss.org/browse/TEIID-5161?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Steven Hawkins resolved TEIID-5161.
-----------------------------------
    Resolution: Done


Documented / prevented the pushdown of RAND with seed so that it only affects Teiid - as that seems like the only consistent behavior we can shoot for.  Sources have different ranges for seed values, different random generation schemes, and even different behavior with respect to evaluation - see mysql.

Otherwise the pushdown of the rand with no arguments is now supported against the sources listed in this issue.

> 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
>
>
> 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)