[teiid-issues] [JBoss JIRA] (TEIID-2407) Support temporary table on commit behavior

[Steven Hawkins (JIRA)]

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

Steven Hawkins commented on TEIID-2407:
---------------------------------------

This will be done in part for TEIID-3073, which uses an explicit on commit clause.  At this time we'll just add support for PRESERVE ROWS, which is our default behavior.  DROP as mentioned above is not standard and is probably not needed given that we already do block scoping.  DELETE ROWS is somewhat difficult to implement as requires a commit hook on TempTableStore that doesn't currently exist (we just have the usage based synchronization).

> Support temporary table on commit behavior
> ------------------------------------------
>
>                 Key: TEIID-2407
>                 URL: https://issues.jboss.org/browse/TEIID-2407
>             Project: Teiid
>          Issue Type: Enhancement
>          Components: Query Engine
>            Reporter: Steven Hawkins
>             Fix For: 8.10
>
>
> Now that our temporary tables are transactionally aware we should support the on commit clause.  
> Our current default for on commit is effectively "preserve rows", which is contrary to the sql specification.  We should also offer delete rows and possible drop (similar to pg sql).



--
This message was sent by Atlassian JIRA
(v6.3.8#6338)