[JBoss JIRA] (TEIID-3774) HBase - Phoenix driver evalues 'HAVING MIN/MAX/AVG(x) = null' to true - teiid-issues

Tuesday, 20 October 2015

    [
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)

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

[JBoss JIRA] (TEIID-3774) HBase - Phoenix driver evalues 'HAVING MIN/MAX/AVG(x) = null' to true