[teiid-issues] [JBoss JIRA] (TEIID-3774) HBase - Phoenix driver evalues 'HAVING MIN/MAX/AVG(x) = null' to true
[
https://issues.jboss.org/browse/TEIID-3774?page=com.atlassian.jira.plugin...
]
Steven Hawkins commented on TEIID-3774:
---------------------------------------
There is a phoenix issue here. However this is somewhat of a corner case in that it looks
like the issue occurs only when computing an aggregate over a grouping column - which is
valid syntax, but not commonly needed. With an aggregate computed outside of the
grouping, I don't see an issue with null values. I'd vote for adding a KI for
this.
HBase - Phoenix driver evalues 'HAVING MIN/MAX/AVG(x) = null'
to true
---------------------------------------------------------------------
Key: TEIID-3774
URL: https://issues.jboss.org/browse/TEIID-3774
Project: Teiid
Issue Type: Bug
Affects Versions: 8.7.1.6_2
Reporter: Juraj Duráni
Assignee: Steven Hawkins
Phoenix driver evaluates clause HAVING MIN/MAX/AVG\(x\) = null to true. This is problem
for query e.g. *SELECT stringnum FROM bqt1.smalla GROUP BY stringnum HAVING MIN(stringnum)
= '1'* as result is:
|StringNum|
|<null>|
|1|
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)