[teiid-issues] [JBoss JIRA] (TEIID-5204) NOW() is calculated several times for SYS tables
[
https://issues.jboss.org/browse/TEIID-5204?page=com.atlassian.jira.plugin...
]
Steven Hawkins resolved TEIID-5204.
-----------------------------------
Fix Version/s: 10.1
10.0.2
9.3.6
Resolution: Done
The fix was to move the function evaluation onto the commandcontext so that a single time
value would be used for all evaluations under that user command.
NOW() is calculated several times for SYS tables
------------------------------------------------
Key: TEIID-5204
URL: https://issues.jboss.org/browse/TEIID-5204
Project: Teiid
Issue Type: Bug
Components: Query Engine
Reporter: El Fuego
Assignee: Steven Hawkins
Fix For: 10.1, 10.0.2, 9.3.6
When applied to an internally processed schema (like {{SYS}}, {{SYSADMIN}}), command
deterministic functions like {{NOW()}} are calculated separately for each row and thus
give different results.
--
This message was sent by Atlassian JIRA
(v7.5.0#75005)