[teiid-issues] [JBoss JIRA] (TEIID-2005) Source query for Oracle sequence adds an alias, which will return "sequence doesn't exist" errors

[RH Bugzilla Integration (JIRA)]

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

RH Bugzilla Integration commented on TEIID-2005:
------------------------------------------------

jolee at redhat.com made a private comment on [bug 816602|https://bugzilla.redhat.com/show_bug.cgi?id=816602]
                
> Source query for Oracle sequence adds an alias, which will return "sequence doesn't exist" errors
> -------------------------------------------------------------------------------------------------
>
>                 Key: TEIID-2005
>                 URL: https://issues.jboss.org/browse/TEIID-2005
>             Project: Teiid
>          Issue Type: Bug
>          Components: JDBC Connector
>    Affects Versions: 7.4.1
>            Reporter: Debbie Steigner
>            Assignee: Steven Hawkins
>             Fix For: 7.7.1, 8.0
>
>
> Per Documentation, setup an oracle sequence or use the EV.vdb on slnttech04.mmx.gss.redhat.com:31100
> run the below query:
> select cpe_seq from Evolvecontrol.seq_gen
> It will error with 
> [SELECT g_0.tid_cl_seq.nextval FROM dual g_0] [SQLException]ORA-02289: sequence does not exist

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira