[teiid-issues] [JBoss JIRA] (TEIID-3768) HBase - Phoenix does not evaluate query correctly

[Juraj Duráni (JIRA)]

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

Juraj Duráni commented on TEIID-3768:
-------------------------------------

I can confirm, that literal value worked for me too. Even query without MAX(...) works fine - SELECT INTKEY, CHARVALUE FROM BQT1.SMALLA AS A WHERE CHARVALUE <= (SELECT CHARVALUE FROM BQT1.SMALLA AS B WHERE A.INTKEY = B.INTKEY) ORDER BY INTKEY.

I vote for KI. It is probably the best option as the original query is not evaluated correctly even in Phoenix.

> HBase - Phoenix does not evaluate query correctly
> -------------------------------------------------
>
>                 Key: TEIID-3768
>                 URL: https://issues.jboss.org/browse/TEIID-3768
>             Project: Teiid
>          Issue Type: Bug
>    Affects Versions: 8.7.1.6_2
>            Reporter: Juraj Duráni
>            Assignee: Steven Hawkins
>
> This specific query \[1\] is not evaluated correctly (especially MAX(charvalue); e.g. there is no problem with MAX(longnum)). It seems like bug in Phoenix.
> \[1\]
> SELECT INTKEY, CHARVALUE FROM BQT1.SMALLA AS A WHERE CHARVALUE <= (SELECT MAX(CHARVALUE) FROM BQT1.SMALLA AS B WHERE A.INTKEY = B.INTKEY) ORDER BY INTKEY



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