[
https://issues.jboss.org/browse/TEIID-1965?page=com.atlassian.jira.plugin...
]
Steven Hawkins resolved TEIID-1965.
-----------------------------------
Resolution: Duplicate Issue
Dup of TEIID-1776, which we have deferred generally as TEIID-1008. This can be addressed
if needed should it become a customer issue, but for now it is fine to stay with a KI.
Ingres10 as a Teiid Source - correlated subquery failing with Error
Code 2118 Message:'Invalid qualifier
--------------------------------------------------------------------------------------------------------
Key: TEIID-1965
URL:
https://issues.jboss.org/browse/TEIID-1965
Project: Teiid
Issue Type: Bug
Components: Query Engine
Affects Versions: 7.1.1
Reporter: Warren Gibson
Assignee: Steven Hawkins
The following query is failing in BQT testing:
SELECT TIMEVALUE, BYTENUM, (SELECT B.FLOATNUM FROM BQT1.SMALLA AS B WHERE (B.INTKEY =
(SELECT A.INTKEY FROM BQT1.SMALLA AS A WHERE (A.STRINGNUM > 10) AND (A.INTKEY =
B.INTKEY))) AND (B.INTKEY = A.INTKEY)) FROM bqt1.smalla AS a
Error Code:2118 Message:Remote org.teiid.core.TeiidProcessingException: Error Code:2118
Message:Source: Error Code:2118 Message:'Invalid qualifier 'g_1'.
'g_1' must be declared in the FROM clause or equivalent. If used in a target list,
'g_1' must be declared at the current scope.' error executing statement(s):
[Prepared Values: [] SQL: SELECT g_0.timevalue, cast(g_0.bytenum AS tinyint), (SELECT
g_1.floatnum FROM smalla AS g_1 WHERE g_1.intkey = g_0.intkey AND g_1.intkey = (SELECT
g_2.intkey FROM smalla AS g_2 WHERE g_2.stringnum > '10' AND g_2.intkey =
g_1.intkey)) FROM smalla AS g_0]
--
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