[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:all-tabpanel ]

Steven Hawkins updated TEIID-2407:
----------------------------------

    Fix Version/s: 8.6
                       (was: 8.5)


Bumping to 8.6.  Given our local scoping behavior on commit drop is largely not needed (and not yet applicable to our global temporary tables).  On commit delete rows is still worthwhile to pursue.
                
> 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
>            Assignee: Steven Hawkins
>             Fix For: 8.6
>
>
> 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 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