[teiid-issues] [JBoss JIRA] (TEIID-5074) Support a way provide SEQUENCE in TeiidDialect

[Steven Hawkins (JIRA)]

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

Steven Hawkins commented on TEIID-5074:
---------------------------------------

[~rareddy] You may want to consider adding an import option for at least oracle/pg that will import sequences and create the relevant function/procedure.  If you are going to require a procedure (presumably to prevent unintended pushdown), you could just use the native query there instead.

> Support a way provide SEQUENCE in TeiidDialect
> ----------------------------------------------
>
>                 Key: TEIID-5074
>                 URL: https://issues.jboss.org/browse/TEIID-5074
>             Project: Teiid
>          Issue Type: Enhancement
>          Components: JDBC Driver
>            Reporter: Ramesh Reddy
>            Assignee: Ramesh Reddy
>             Fix For: 10.0
>
>
> Currently, the sequence based Table identity generation support is not available in current TeiidDialect. The support will not be direct, but with additional constructs in VDB, we can make this available. Teiid needs to provide a way to call in source specific of way to insert a layer in Teiid to accomplish this.



--
This message was sent by Atlassian JIRA
(v7.2.3#72005)