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

[RH Bugzilla Integration (JIRA)]

    [ https://issues.jboss.org/browse/ISPN-5732?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13108644#comment-13108644 ] 

RH Bugzilla Integration commented on ISPN-5732:
-----------------------------------------------

Dave Stahl <dstahl at redhat.com> changed the Status of [bug 1261563|https://bugzilla.redhat.com/show_bug.cgi?id=1261563] from POST to MODIFIED

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