]
RH Bugzilla Integration updated TEIID-3768:
-------------------------------------------
Bugzilla References:
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