]
RH Bugzilla Integration commented on ISPN-5732:
-----------------------------------------------
Vojtech Juranek <vjuranek(a)redhat.com> changed the Status of [bug
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/...