[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-5173) hql - average returns double but looses the decimal part

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-5173?page=c... ] Sébastien Peters commented on HHH-5173: --------------------------------------- Average function called from inside a NamedQuery: @Entity @Table(name = "review") @Cache(usage = CacheConcurrencyStrategy.READ_ONLY) @NamedQueries( { @NamedQuery(name = "Review.getAverageRatingForSite", query="SELECT AVG(r.rating) FROM Review r WHERE r.site.mySiteId = :mySiteId AND r.active=true") ... } ) public class Review { @Id @GeneratedValue(strategy = GenerationType.IDENTITY) @Column(name = "id", nullable = false) private Long id; ... @Column(nullable = false, columnDefinition = "INT DEFAULT 3") @javax.persistence.Enumerated() private Integer rating; ... } -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.... - For more information on JIRA, see: http://www.atlassian.com/software/jira