[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=12690902#comment-12690902 ] 

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

Rick Wagner <rwagner at redhat.com> made a comment on [bug 813932|https://bugzilla.redhat.com/show_bug.cgi?id=813932]

This bug is important to GSS because it's been repaired under EDS 5.2 via BZ 816602.  If we don't get it put in EDS 5.3, a customer on patched 5.2 would notice a regression.  Can we please put this in EDS 5.3 to prevent this?

Thanks,

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