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

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

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Blocker
    • Resolution: Done
    • Affects Version/s: 7.4
    • Fix Version/s: 7.4.4, 8.1
    • Component/s: Query Engine
    • Labels:
      None
    • Environment:

      Operating system: Windows 7
      Eclipse Version: Helios Service Release 1

      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.

        Gliffy Diagrams

          Attachments

            Activity

              People

              • Assignee:
                shawkins Steven Hawkins
                Reporter:
                pramod.gampa Pramod Kumar
              • Votes:
                0 Vote for this issue
                Watchers:
                7 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: