[
https://issues.jboss.org/browse/TEIID-3768?page=com.atlassian.jira.plugin...
]
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)