[teiid-issues] [JBoss JIRA] Commented: (TEIID-1294) procedure validation issues

Tue Oct 12 17:34:39 EDT 2010

    [ https://jira.jboss.org/browse/TEIID-1294?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12556624#action_12556624 ] 

Steven Hawkins commented on TEIID-1294:
---------------------------------------

Based upon TEIID-1237, I think that the other validations we should add are treating VARIABLES.ROWCOUNT as reserved and to not allow the use of an assignment with an exec that doesn't have a return parameter.  Then we'll address TEIID-1237 in 7.2.

> procedure validation issues
> ---------------------------
>
>                 Key: TEIID-1294
>                 URL: https://jira.jboss.org/browse/TEIID-1294
>             Project: Teiid
>          Issue Type: Quality Risk
>          Components: Query Engine
>    Affects Versions: 7.1
>            Reporter: Steven Hawkins
>            Assignee: Steven Hawkins
>             Fix For: 7.1.1
>
>
> We should introduce several validations to ensure proper procedure usage.
> The first is to not allow the use of insert/update/delete as a command statement that creates the implicit return cursor.
> There may be others based upon TEIID-1237

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira