[teiid-issues] [JBoss JIRA] Commented: (TEIID-1349) Better default update procedure handling

[Steven Hawkins (JIRA)]

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

Steven Hawkins commented on TEIID-1349:
---------------------------------------

Our handling will be updated so that no update procedure sql will be interpreted as wanting the default.  Correspondingly, Teiid designer will need to ensure that when the use default box is checked for a given update procedure, then no update procedure sql is in the index file.  The UpdateProcedureGenerator class will also be removed.

The new handling will be enhanced from the old.  In many circumstances we will be able to process the update as a pass through command, rather than as something that needs a procedural hook.

The basics will be similar to oracle: http://psoug.org/reference/views.html

Any use of a join will result in a non-pass through update, which will get processed as a batch.  Deletes with a join will also affect only the first key preserving table in the FROM clause, but it may be worthwhile to add metadata for the user to specify cascading deletes.

> Better default update procedure handling
> ----------------------------------------
>
>                 Key: TEIID-1349
>                 URL: https://jira.jboss.org/browse/TEIID-1349
>             Project: Teiid
>          Issue Type: Feature Request
>          Components: Query Engine
>    Affects Versions: 7.2
>            Reporter: Steven Hawkins
>            Assignee: Steven Hawkins
>             Fix For: 8.0
>
>
> We are currently very restrictive in what we can automatically handle in terms of updates procedures.  Anything other than a simple non-joined select cannot have a default update procedure.  We should look at expanding our default handling to simple joins and union all - along with designer warnings for derived columns or other situations that would not be automatically updatable. 

-- 
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira