[infinispan-issues] [JBoss JIRA] (ISPN-5732) Aggregation functions should ignore NULL values

[Jakub Markos (JIRA)]

Jakub Markos created ISPN-5732:
----------------------------------

             Summary: Aggregation functions should ignore NULL values
                 Key: ISPN-5732
                 URL: https://issues.jboss.org/browse/ISPN-5732
             Project: Infinispan
          Issue Type: Bug
            Reporter: Jakub Markos
            Assignee: Adrian Nistor


For example, this query returns 3 (in QueryDslConditionsTest)
{code}
public void testCountNull() {
    QueryFactory qf = getQueryFactory();
    Query q = qf.from(getModelFactory().getUserImplClass())
            .select(Expression.count("age"))
            .build();
{code}
while only 1 value is non-null.
It might be good to behave like JPA, which ignores NULL values:
"Null values are eliminated before the aggregate function is applied, regardless of whether the keyword DISTINCT is specified." http://download.oracle.com/otn-pub/jcp/persistence-2.0-fr-eval-oth-JSpec/persistence-2_0-final-spec.pdf?AuthParam=1441633088_b920076e17d14a7f5faa4677495f61f0



--
This message was sent by Atlassian JIRA
(v6.4.11#64026)