[teiid-issues] [JBoss JIRA] Created: (TEIID-1190) Procedure logic clean up

Sun Aug 8 12:20:49 EDT 2010

Procedure logic clean up
------------------------

                 Key: TEIID-1190
                 URL: https://jira.jboss.org/browse/TEIID-1190
             Project: Teiid
          Issue Type: Quality Risk
          Components: Query Engine
    Affects Versions: 7.1
            Reporter: Steve Hawkins
            Assignee: Steve Hawkins
             Fix For: 7.1

The procedure planning logic has several issues that should be addressed

1. RaiseErrorStatement extends AssignmentStatement, which is confusing the designer code.
2. Assigment/RaiseError/Declare have lots of specialized logic for dealing with commands.  It would be much simplier to just use a scalar subquery to represent the command execution.  This may need to be refined later if we want specialized handling for using the return value from storedprocedures and to use its cursor.
3. Validation is not run on dynamic sql commands.

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