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

[Dan Berindei (JIRA)]

     [ https://issues.jboss.org/browse/ISPN-5732?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Dan Berindei updated ISPN-5732:
-------------------------------
        Status: Resolved  (was: Pull Request Sent)
    Resolution: Done


> Aggregation functions should ignore NULL values
> -----------------------------------------------
>
>                 Key: ISPN-5732
>                 URL: https://issues.jboss.org/browse/ISPN-5732
>             Project: Infinispan
>          Issue Type: Bug
>    Affects Versions: 8.0.0.Final
>            Reporter: Jakub Markos
>            Assignee: Adrian Nistor
>             Fix For: 8.0.1.Final
>
>
> 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)