[teiid-issues] [JBoss JIRA] (TEIID-2558) Add translator support for dependent join pushdown

[Steven Hawkins (JIRA)]

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

Steven Hawkins commented on TEIID-2558:
---------------------------------------

I now have a somewhat working example for Oracle however there are several issues.  The first is that using ad hoc create/drop is fairly expensive for oracle since it's creating a global table (and without a source sequence we have to use a random or other naming strategy).  Second it implies that if the operation is transactional then any pending work will be committed prior to the ddl execution, which is not generally something we can allow unless we know that the session has been used in a read-only capacity.  An autonomous transaction may help here.  Or it may not even work https://forums.oracle.com/thread/1083417  

Third the ojdbc6 driver has a bug that does not allow bulk inserts against temporary tables.  on executeBatch I receive an ArrayIndexOutOfBoundsException and can find no similar occurrences online.  This happens with using either of the on commit behaviors.
                
> Add translator support for dependent join pushdown
> --------------------------------------------------
>
>                 Key: TEIID-2558
>                 URL: https://issues.jboss.org/browse/TEIID-2558
>             Project: Teiid
>          Issue Type: Sub-task
>          Components: Connector API
>            Reporter: Steven Hawkins
>            Assignee: Steven Hawkins
>             Fix For: 8.5
>
>
> JDBC translators should offer built-in support for dependent join pushdown - possibly with index creation and other options.

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