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

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

      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

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

                Created:
                Updated:
                Resolved: