[JBoss JIRA] (TEIID-5161) Push down rand() function
- First Post
- Replies
- Stats
-
Go to
- ----- 2026 -----
- January
- ----- 2025 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2024 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2023 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2022 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2021 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2020 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2019 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2018 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2017 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2016 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2015 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2014 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2013 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2012 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2011 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2010 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2009 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
[
https://issues.jboss.org/browse/TEIID-5161?page=com.atlassian.jira.plugin...
]
Steven Hawkins commented on TEIID-5161:
---------------------------------------
I don't know what we can do here, maybe it's better just not
to push down rand function for MSSQL or maybe there is a problem on teiid core...
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. We can
still push it down, but will have to resort to effectively passing a random seed -
https://stackoverflow.com/questions/1045138/how-do-i-generate-random-numb...
So it's probably safest to just not push to SQL Server.
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)
2944
days inactive
2944
days old
0 comments
1 participants
tags (0)
participants (1)
-
Steven Hawkins (JIRA)