[teiid-issues] [JBoss JIRA] (TEIID-1956) WHERE clause throws org.teiid.jdbc.TeiidSQLException: Index: 2, Size: 1

[Pramod Kumar (JIRA)]

Pramod Kumar created TEIID-1956:
-----------------------------------

             Summary: WHERE clause throws org.teiid.jdbc.TeiidSQLException: Index: 2, Size: 1
                 Key: TEIID-1956
                 URL: https://issues.jboss.org/browse/TEIID-1956
             Project: Teiid
          Issue Type: Bug
    Affects Versions: 7.6
         Environment: Operating system: Windows 7 
Eclipse Version: Helios Service Release 1
            Reporter: Pramod Kumar
            Assignee: Steven Hawkins


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.

--
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