Uploaded image for project: 'Teiid'
  1. Teiid
  2. TEIID-2005

Source query for Oracle sequence adds an alias, which will return "sequence doesn't exist" errors

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Major
    • 7.7.1, 8.0
    • 7.4.1
    • JDBC Connector
    • None

    Description

      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

      Attachments

        Activity

          People

            rhn-engineering-shawkins Steven Hawkins
            rhn-support-dsteigner Deborah Steigner (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: