[teiid-issues] [JBoss JIRA] (TEIID-1965) Ingres10 as a Teiid Source - correlated subquery failing with Error Code 2118 Message:'Invalid qualifier
RH Bugzilla Integration (JIRA)
jira-events at lists.jboss.org
Fri Mar 9 13:54:36 EST 2012
[ https://issues.jboss.org/browse/TEIID-1965?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12675580#comment-12675580 ]
RH Bugzilla Integration commented on TEIID-1965:
------------------------------------------------
Van Halbert <vhalbert at redhat.com> changed the Status of [bug 801175|https://bugzilla.redhat.com/show_bug.cgi?id=801175] from NEW to MODIFIED
> 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
More information about the teiid-issues
mailing list