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

WHERE clause throws org.teiid.jdbc.TeiidSQLException: Index: 2, Size: 1

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Blocker
    • Resolution: Done
    • 7.4
    • 7.4.4, 8.1
    • Query Engine
    • None

    Description

      I am trying to execute a query similar to the following query:

      select count from SCHEMA1.STUDENTVIEW as STD_VIEW left join SCHEMA1.LIBRARY LIB on STD_VIEW.sid = LIB.sid where LIB.sid = STD_VIEW.sid and LIB.semister = '4';

      The above query works fine in DB2. But throws org.teiid.jdbc.TeiidSQLException: Index: 2, Size: 1 when trying to execute in Teiid Designer version 7.6.

      Attachments

        Activity

          People

            rhn-engineering-shawkins Steven Hawkins
            pramod.gampa Pramod Kumar (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            7 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: