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

Wed Apr 18 13:59:17 EDT 2012

Debbie Steigner created TEIID-2005:
--------------------------------------

             Summary: 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: Query Engine
    Affects Versions: 7.4.1
            Reporter: Debbie Steigner
            Assignee: Steven Hawkins

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