4:42 a.m.
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
9:08 a.m.
[
https://issues.jboss.org/browse/TEIID-1956?page=com.atlassian.jira.plugin...
]
Steven Hawkins commented on TEIID-1956:
---------------------------------------
Can you provide a debug log or a vdb to reproduce this error?
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
12:09 a.m.
[
https://issues.jboss.org/browse/TEIID-1956?page=com.atlassian.jira.plugin...
]
Pramod Kumar commented on TEIID-1956:
-------------------------------------
Hi Steven,
Thank you for your quick reply.
I have gone through the following link:
https://community.jboss.org/thread/196005?tstart=0
There I have seen that you got the required details.
Regards,
Pramod Gampa
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
11:05 a.m.
[
https://issues.jboss.org/browse/TEIID-1956?page=com.atlassian.jira.plugin...
]
Steven Hawkins resolved TEIID-1956.
-----------------------------------
Fix Version/s: 7.7.1
Resolution: Done
The fix addresses the indexing issue in EnhancedSortMergeJoinStrategy, and enhances
RuleCopyCriteria to prevent/minimize when this situation can occur.
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
Fix For: 7.7.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
4:48 p.m.
[
https://issues.jboss.org/browse/TEIID-1956?page=com.atlassian.jira.plugin...
]
RH Bugzilla Integration updated TEIID-1956:
-------------------------------------------
Bugzilla References: https://bugzilla.redhat.com/show_bug.cgi?id=823676
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
Fix For: 7.7.1, 8.0
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
4:48 p.m.
[
https://issues.jboss.org/browse/TEIID-1956?page=com.atlassian.jira.plugin...
]
RH Bugzilla Integration updated TEIID-1956:
-------------------------------------------
Bugzilla Update: Perform
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
Fix For: 7.7.1, 8.0
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
3:15 p.m.
[
https://issues.jboss.org/browse/TEIID-1956?page=com.atlassian.jira.plugin...
]
RH Bugzilla Integration commented on TEIID-1956:
------------------------------------------------
jolee(a)redhat.com made a private comment on [bug
823676|https://bugzilla.redhat.com/show_bug.cgi?id=823676]
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
Fix For: 7.7.1, 8.0
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
3:15 p.m.
[
https://issues.jboss.org/browse/TEIID-1956?page=com.atlassian.jira.plugin...
]
RH Bugzilla Integration commented on TEIID-1956:
------------------------------------------------
jolee(a)redhat.com changed the Status of [bug
823676|https://bugzilla.redhat.com/show_bug.cgi?id=823676] from NEW to MODIFIED
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
Fix For: 7.7.1, 8.0
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
3:15 p.m.
[
https://issues.jboss.org/browse/TEIID-1956?page=com.atlassian.jira.plugin...
]
RH Bugzilla Integration commented on TEIID-1956:
------------------------------------------------
jolee(a)redhat.com made a private comment on [bug
823676|https://bugzilla.redhat.com/show_bug.cgi?id=823676]
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
Fix For: 7.7.1, 8.0
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
3:15 p.m.
[
https://issues.jboss.org/browse/TEIID-1956?page=com.atlassian.jira.plugin...
]
RH Bugzilla Integration commented on TEIID-1956:
------------------------------------------------
jolee(a)redhat.com made a comment on [bug
823676|https://bugzilla.redhat.com/show_bug.cgi?id=823676]
Description of problem:
Version-Release number of selected component (if applicable):
How reproducible:
Steps to Reproduce:
1.
2.
3.
Actual results:
Expected results:
Additional info:
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
Fix For: 7.7.1, 8.0
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
11:32 a.m.
[
https://issues.jboss.org/browse/TEIID-1956?page=com.atlassian.jira.plugin...
]
RH Bugzilla Integration commented on TEIID-1956:
------------------------------------------------
jolee(a)redhat.com made a private comment on [bug
823676|https://bugzilla.redhat.com/show_bug.cgi?id=823676]
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
Fix For: 7.7.1, 8.0
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
11:32 a.m.
[
https://issues.jboss.org/browse/TEIID-1956?page=com.atlassian.jira.plugin...
]
RH Bugzilla Integration commented on TEIID-1956:
------------------------------------------------
jolee(a)redhat.com changed the Status of [bug
823676|https://bugzilla.redhat.com/show_bug.cgi?id=823676] from MODIFIED to CLOSED
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
Fix For: 7.7.1, 8.0
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
8:42 a.m.
[
https://issues.jboss.org/browse/TEIID-1956?page=com.atlassian.jira.plugin...
]
Steven Hawkins closed TEIID-1956.
---------------------------------
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
Fix For: 7.7.1, 8.0
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
1:38 p.m.
[
https://issues.jboss.org/browse/TEIID-1956?page=com.atlassian.jira.plugin...
]
Steven Hawkins reopened TEIID-1956:
-----------------------------------
A further problem was detected as part of
https://c.na7.visual.force.com/apex/Case_View?id=500A000000Ashz2IAB
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
Fix For: 7.7.1, 8.0
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
1:42 p.m.
[
https://issues.jboss.org/browse/TEIID-1956?page=com.atlassian.jira.plugin...
]
Steven Hawkins updated TEIID-1956:
----------------------------------
Fix Version/s: 8.1
(was: 8.0)
(was: 7.7.1)
Priority: Blocker (was: Major)
Bugzilla References: https://bugzilla.redhat.com/show_bug.cgi?id=823676 (was:
https://bugzilla.redhat.com/show_bug.cgi?id=823676)
Affects Version/s: 7.4
(was: 7.6)
This fixed missed proper computation of projecting back out the tuple from the index,
which can lead to an exception, but in the worst case could lead to inaccurate results.
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.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
2:50 p.m.
[
https://issues.jboss.org/browse/TEIID-1956?page=com.atlassian.jira.plugin...
]
Steven Hawkins updated TEIID-1956:
----------------------------------
Bugzilla References: https://bugzilla.redhat.com/show_bug.cgi?id=823676 (was:
https://bugzilla.redhat.com/show_bug.cgi?id=823676)
Component/s: Query Engine
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
2:50 p.m.
[
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
8:18 a.m.
[
https://issues.jboss.org/browse/TEIID-1956?page=com.atlassian.jira.plugin...
]
RH Bugzilla Integration updated TEIID-1956:
-------------------------------------------
Bugzilla References: https://bugzilla.redhat.com/show_bug.cgi?id=823676 (was:
https://bugzilla.redhat.com/show_bug.cgi?id=823676)
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
8:18 a.m.
[
https://issues.jboss.org/browse/TEIID-1956?page=com.atlassian.jira.plugin...
]
RH Bugzilla Integration commented on TEIID-1956:
------------------------------------------------
jolee(a)redhat.com made a comment on [bug
848792|https://bugzilla.redhat.com/show_bug.cgi?id=848792]
Description of problem:
Refer to https://issues.jboss.org/browse/TEIID-1956
Version-Release number of selected component (if applicable):
How reproducible:
Steps to Reproduce:
1.
2.
3.
Actual results:
Expected results:
Additional info:
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
8:18 a.m.
[
https://issues.jboss.org/browse/TEIID-1956?page=com.atlassian.jira.plugin...
]
RH Bugzilla Integration updated TEIID-1956:
-------------------------------------------
Bugzilla References: https://bugzilla.redhat.com/show_bug.cgi?id=823676,
https://bugzilla.redhat.com/show_bug.cgi?id=848792 (was:
https://bugzilla.redhat.com/show_bug.cgi?id=823676)
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
11:17 a.m.
[
https://issues.jboss.org/browse/TEIID-1956?page=com.atlassian.jira.plugin...
]
RH Bugzilla Integration commented on TEIID-1956:
------------------------------------------------
jolee(a)redhat.com made a comment on [bug
848792|https://bugzilla.redhat.com/show_bug.cgi?id=848792]
Committed r4330 to https://svn.jboss.org/repos/teiid/branches/7.4.x/
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
11:17 a.m.
[
https://issues.jboss.org/browse/TEIID-1956?page=com.atlassian.jira.plugin...
]
RH Bugzilla Integration commented on TEIID-1956:
------------------------------------------------
jolee(a)redhat.com changed the Status of [bug
848792|https://bugzilla.redhat.com/show_bug.cgi?id=848792] from NEW to MODIFIED
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
11:12 a.m.
[
https://issues.jboss.org/browse/TEIID-1956?page=com.atlassian.jira.plugin...
]
Paul Nittel commented on TEIID-1956:
------------------------------------
Unit tests are in place to continue verification of this correction.
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
11:14 a.m.
[
https://issues.jboss.org/browse/TEIID-1956?page=com.atlassian.jira.plugin...
]
RH Bugzilla Integration commented on TEIID-1956:
------------------------------------------------
Paul Nittel <pnittel(a)redhat.com> made a comment on [bug
848792|https://bugzilla.redhat.com/show_bug.cgi?id=848792]
Marking verified.
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
11:14 a.m.
[
https://issues.jboss.org/browse/TEIID-1956?page=com.atlassian.jira.plugin...
]
RH Bugzilla Integration commented on TEIID-1956:
------------------------------------------------
Paul Nittel <pnittel(a)redhat.com> changed the Status of [bug
848792|https://bugzilla.redhat.com/show_bug.cgi?id=848792] from MODIFIED to VERIFIED
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
8:15 a.m.
[
https://issues.jboss.org/browse/TEIID-1956?page=com.atlassian.jira.plugin...
]
RH Bugzilla Integration commented on TEIID-1956:
------------------------------------------------
jolee(a)redhat.com made a comment on [bug
823676|https://bugzilla.redhat.com/show_bug.cgi?id=823676]
Van,
This is a 5.2 Support Patch, we need a new BZ to represent the backport as a 5.3 blocker.
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
For more information on JIRA, see: http://www.atlassian.com/software/jira
9:58 a.m.
[
https://issues.jboss.org/browse/TEIID-1956?page=com.atlassian.jira.plugin...
]
RH Bugzilla Integration updated TEIID-1956:
-------------------------------------------
Bugzilla References: https://bugzilla.redhat.com/show_bug.cgi?id=823676,
https://bugzilla.redhat.com/show_bug.cgi?id=848792 (was:
https://bugzilla.redhat.com/show_bug.cgi?id=823676,
https://bugzilla.redhat.com/show_bug.cgi?id=848792)
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
For more information on JIRA, see: http://www.atlassian.com/software/jira
9:58 a.m.
[
https://issues.jboss.org/browse/TEIID-1956?page=com.atlassian.jira.plugin...
]
RH Bugzilla Integration updated TEIID-1956:
-------------------------------------------
Bugzilla References: https://bugzilla.redhat.com/show_bug.cgi?id=823676,
https://bugzilla.redhat.com/show_bug.cgi?id=848792,
https://bugzilla.redhat.com/show_bug.cgi?id=855005 (was:
https://bugzilla.redhat.com/show_bug.cgi?id=823676,
https://bugzilla.redhat.com/show_bug.cgi?id=848792)
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
For more information on JIRA, see: http://www.atlassian.com/software/jira
10:52 a.m.
[
https://issues.jboss.org/browse/TEIID-1956?page=com.atlassian.jira.plugin...
]
Johnathon Lee updated TEIID-1956:
---------------------------------
Fix Version/s: 7.4.4
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: 7.4.4, 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
For more information on JIRA, see: http://www.atlassian.com/software/jira
9:17 a.m.
[
https://issues.jboss.org/browse/TEIID-1956?page=com.atlassian.jira.plugin...
]
Steven Hawkins closed TEIID-1956.
---------------------------------
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: 7.4.4, 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
For more information on JIRA, see: http://www.atlassian.com/software/jira
4180
days inactive
4446
days old
29 comments
5 participants
participants (5)
-
Johnathon Lee (JIRA) -
Paul Nittel (JIRA)
-
Pramod Kumar (JIRA)
-
RH Bugzilla Integration (JIRA)
-
Steven Hawkins (JIRA)