Juraj Duráni created TEIID-3768: ----------------------------------- Summary: 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)