[
https://issues.jboss.org/browse/TEIID-2407?page=com.atlassian.jira.plugin...
]
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)