[
https://issues.jboss.org/browse/TEIIDDES-2345?page=com.atlassian.jira.plu...
]
Barry LaFond commented on TEIIDDES-2345:
----------------------------------------
[~asmigala] can you add your SQL text to the description as well?
I've tested with the following SQL and it validates OK
{code}
BEGIN ATOMIC
DECLARE integer VARIABLES.ROWS_UPDATED;
SELECT MySQL_Books.books.ISBN FROM MySQL_Books.books;
VARIABLES.ROWS_UPDATED = VARIABLES.ROWCOUNT;
END
{code}
Using VARIABLES.ROWCOUNT in update procedure causes validation error
--------------------------------------------------------------------
Key: TEIIDDES-2345
URL:
https://issues.jboss.org/browse/TEIIDDES-2345
Project: Teiid Designer
Issue Type: Bug
Components: Transformations
Affects Versions: 8.6
Reporter: Andrej Šmigala
Assignee: Barry LaFond
Trying to get the number of affected rows in the update/insert/delete procedure of a view
table by using the VARIABLES.ROWCOUNT variable causes the following error:
{quote}ERROR: TEIID31118 Element "VARIABLES.ROWCOUNT" is not defined by any
relevant group.{quote}
--
This message was sent by Atlassian JIRA
(v6.3.8#6338)