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

Wed Aug 15 14:50:15 EDT 2012

     [ https://issues.jboss.org/browse/TEIID-1956?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Steven Hawkins resolved TEIID-1956.
-----------------------------------

    Resolution: Done

The initial fix addressed the trivial situation of having fully duplicate predicates and when having duplicate equi-join elements where none of the non-equi join elements were projected.  Thus the fix was incomplete.  Scanning the full reorder indexes address this, since when there are duplicate columns it will be longer than the number of elements.

> 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
>          Components: Query Engine
>    Affects Versions: 7.4
>         Environment: Operating system: Windows 7 
> Eclipse Version: Helios Service Release 1
>            Reporter: Pramod Kumar
>            Assignee: Steven Hawkins
>            Priority: Blocker
>             Fix For: 8.1
>
>
> 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