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

Support temporary table on commit behavior ------------------------------------------ Key: TEIIDDES-2407 URL: https://issues.jboss.org/browse/TEIIDDES-2407 Project: Teiid Designer Issue Type: Enhancement Components: Teiid Integration Reporter: Steven Hawkins 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).