[
https://issues.jboss.org/browse/TEIID-3774?page=com.atlassian.jira.plugin...
]
Juraj Duráni updated TEIID-3774:
--------------------------------
Description:
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|
was:
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|
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)