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

[ https://jira.jboss.org/browse/TEIID-1349?page=com.atlassian.jira.plugin.s... ] 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. -- This message is automatically generated by JIRA. - For more information on JIRA, see: http://www.atlassian.com/software/jira