[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 resolved TEIID-2407.
-----------------------------------
    Resolution: Done


Updated the parser and added a new non-reserved word (preserve).  The online grammar will be updated before the final release.

> 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)