Skip to:
JPA specification ask avg() should return Double.
In Reference Manual:When you average (signed or unsigned) int, smallint, tinyint data, Adaptive Server returns the result as an int value.
But considering it as an ASE feature, it won't be fixed.
Bulk closing rejected tickets in "resolved" state.
for example:
ID
VALUE
1
2
Double avgValue = (Double)session.createQuery("select avg(t.value) from Table t").uniqueResult();
mysql : avgValue == 1.5sybase : avgValue == 1
JPA specification ask avg() should return Double.
In Reference Manual:
When you average (signed or unsigned) int, smallint, tinyint data, Adaptive Server returns the result as an int value.
But considering it as an ASE feature, it won't be fixed.