[JBoss JIRA] Updated: (TEIID-119) physical procedural mapping results in inconsistent results
by Ramesh Reddy (JIRA)
[ https://jira.jboss.org/jira/browse/TEIID-119?page=com.atlassian.jira.plug... ]
Ramesh Reddy updated TEIID-119:
-------------------------------
Component/s: Query Engine
Fix Version/s: 6.1.0
Affects Version/s: 6.x
> physical procedural mapping results in inconsistent results
> -----------------------------------------------------------
>
> Key: TEIID-119
> URL: https://jira.jboss.org/jira/browse/TEIID-119
> Project: Teiid
> Issue Type: Bug
> Components: Query Engine
> Affects Versions: 6.x
> Reporter: Marc Shirley
> Assignee: Steven Hawkins
> Priority: Critical
> Fix For: 6.1.0
>
>
> Defect Tracker #24951: testing a query with multiple physical procedure calls using the new mapping style results in inconsistent/incorrect results. As a test case, sptest6, a physical procedure that doubles the integer value passed into it, was called twice in a view transformation, with a result set consisting of the the source, input, and result values for each call to the procedure. 2 issues were seen:
> 1) Source and input value columns only showed the value of the last input parameter for all rows.
> 2) The result values for the first procedure call were correct for every row, but the result values for the second procedure call were the same for every row (it only showed the last result value calculated for all the rows).
> After mapping the physical procedure to a virtual procedure, no issue was seen. Issue can be seen in "view.two_bqt_sptest6_test" in attached vdb, or at mm://sluxtech09:55391 (http://sluxtech09:18391).
--
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
15 years, 10 months
[JBoss JIRA] Updated: (TEIID-226) Cacheing translated commands would improve connector performance
by Steven Hawkins (JIRA)
[ https://jira.jboss.org/jira/browse/TEIID-226?page=com.atlassian.jira.plug... ]
Steven Hawkins updated TEIID-226:
---------------------------------
Component/s: Connector API
Query Engine
Fix Version/s: 6.1.0
Affects Version/s: 6.0.0
Affects: [Documentation (Ref Guide, User Guide, etc.), Release Notes]
Complexity: High
It would probably be best for TEIID-303 to be worked, with the addition of prepared commands (references in the data language) so that the command itself could be used as a cache key.
> Cacheing translated commands would improve connector performance
> ----------------------------------------------------------------
>
> Key: TEIID-226
> URL: https://jira.jboss.org/jira/browse/TEIID-226
> Project: Teiid
> Issue Type: Feature Request
> Components: Connector API, Query Engine
> Affects Versions: 6.0.0
> Reporter: Steven Hawkins
> Fix For: 6.1.0
>
>
> Defect Tracker #16722: AD 2/17/05 - Command translation in connector - approx. half the time taken to create an Execution object is spent in command translation. If there was a way to cache the translated command, then we could eliminate that step for subsequent requests.
> Alex 2/17/05 - The problem is that the connector can be used with different vdbs, so the translation may be different even for the same query. Still seems do-able [...].
--
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
15 years, 10 months