[teiid-issues] [JBoss JIRA] (TEIID-3768) HBase - Phoenix does not evaluate query correctly
[
https://issues.jboss.org/browse/TEIID-3768?page=com.atlassian.jira.plugin...
]
Steven Hawkins commented on TEIID-3768:
---------------------------------------
I can't reproduce this if charvalue is a varchar in phoenix. With charvalue as a
char(1) column, then I get no results. I'm not sure we have an immediate workaround
to this. Perhaps just a KI to avoid the phoenix char type.
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)