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

[Steven Hawkins (JIRA)]

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

Steven Hawkins commented on TEIID-3770:
---------------------------------------

There's not much more we can do with this issue.  We can either not pushdown correlated subqueries, or just accept that phoenix has bugs in this area and address it further if it becomes a customer issue.  Since this produces as exception it's safe to just take the latter approach for now.

> 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)