Is is normal that
Number num = (Number)entityManager.createQuery( "select count(*) from X x;") .getSingleResult();
Number num = (Number)entityManager.createQuery( "select sum(x.id) from X x") .getSingleResult();
TITLE IS : getSingleResult behaviour mismatch for count() and sum() when no entities found
and I am using 4.0.2 + EJB3RC2 on gentoo with sun-jdk-1.5.05 on postgresql 8.0.3