[teiid-issues] [JBoss JIRA] (TEIID-1956) WHERE clause throws org.teiid.jdbc.TeiidSQLException: Index: 2, Size: 1
[
https://issues.jboss.org/browse/TEIID-1956?page=com.atlassian.jira.plugin...
]
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