[teiid-issues] [JBoss JIRA] (TEIID-1226) Reuse dynamic sql plans and allow for prepared statements in procedure logic

[Steven Hawkins (JIRA)]

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

Steven Hawkins commented on TEIID-1226:
---------------------------------------

Ideally here we would reuse standard syntax, such as

PREPARE stmt FROM sql

EXECUTE stmt USING x, y, z

DEALLOCATE PREPARE stmt

This requires 2 new statements and a variation of our dynamic sql command.

Given our prepared infrastructure, it's just as easy though to have a single execute/prepare statement.

EXECUTE PREPARE stmt USING x, y, z

Here the context of the statement becomes important though as the plan should only be visible in the current/child procedure blocks.
                
> Reuse dynamic sql plans and allow for prepared statements in procedure logic
> ----------------------------------------------------------------------------
>
>                 Key: TEIID-1226
>                 URL: https://issues.jboss.org/browse/TEIID-1226
>             Project: Teiid
>          Issue Type: Feature Request
>          Components: Query Engine
>    Affects Versions: 7.1
>            Reporter: Steven Hawkins
>            Assignee: Steven Hawkins
>            Priority: Minor
>             Fix For: 8.6
>
>
> Dynamic sql plans (for dynamic sql statements, lookup, and matview refreshes) should allow for plan reuse.
> Also procedure logic should have a mechanism to execute prepared statements for further plan reuse.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira