[teiid-issues] [JBoss JIRA] (TEIID-3770) HBase - table's alias (... AS ...) is not "visible" in SELECT caluse in IN predicate

[Van Halbert (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-3770?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13252984#comment-13252984 ] 

Van Halbert commented on TEIID-3770:
------------------------------------

Now, Teiid throws different exception:

12:37:27,261 WARN  [org.teiid.PROCESSOR] (Worker3_QueryProcessorQueue181) TEIID30020 Processing exception for request r7NYsl824ly1.8 'TEIID30504 Source: 602 TEIID11008:TEIID11004 Error executing statement(s): [Prepared Values: [] SQL: SELECT g_0.intkey AS c_0, g_0.bigdecimalvalue AS c_1 FROM smalla AS g_0 WHERE g_0.bigdecimalvalue = SOME (SELECT MAX(g_1.bigdecimalvalue) FROM smalla AS g_1 WHERE g_1.intkey = g_0.intkey) ORDER BY c_0]'. Originally TeiidProcessingException PhoenixSQLParser.java:345.: org.teiid.core.TeiidProcessingException: TEIID30504 Source: 602 TEIID11008:TEIID11004 Error executing statement(s): [Prepared Values: [] SQL: SELECT g_0.intkey AS c_0, g_0.bigdecimalvalue AS c_1 FROM smalla AS g_0 WHERE g_0.bigdecimalvalue = SOME (SELECT MAX(g_1.bigdecimalvalue) FROM smalla AS g_1 WHERE g_1.intkey = g_0.intkey) ORDER BY c_0]
	at org.teiid.dqp.internal.process.DataTierTupleSource.exceptionOccurred(DataTierTupleSource.java:401) [teiid-engine-8.12.5.redhat-6.jar:8.12.5.redhat-6]
	at 

> HBase - table's alias (... AS ...) is not "visible" in SELECT caluse in IN predicate
> ------------------------------------------------------------------------------------
>
>                 Key: TEIID-3770
>                 URL: https://issues.jboss.org/browse/TEIID-3770
>             Project: Teiid
>          Issue Type: Bug
>          Components: Misc. Connectors
>    Affects Versions: 8.7.1.6_2
>            Reporter: Juraj Duráni
>            Assignee: Steven Hawkins
>             Fix For: 8.12.1, 8.13
>
>
> Query:
> SELECT INTKEY, BIGDECIMALVALUE FROM BQT1.SMALLA AS A WHERE BIGDECIMALVALUE *IN (SELECT MAX(BIGDECIMALVALUE) FROM BQT1.SMALLA AS B WHERE _A_.INTKEY = B.INTKEY)* ORDER BY INTKEY
> It seems like bug in Phoenix driver.



--
This message was sent by Atlassian JIRA
(v6.4.11#64026)