[teiid-issues] [JBoss JIRA] Closed: (TEIID-119) physical procedural mapping results in inconsistent results

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