[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-4769) In HQL, function ROUND always returns an Integer, it truncate the decimal part of Double number.

In HQL, function ROUND always returns an Integer, it truncate the decimal part of Double number. ------------------------------------------------------------------------------------------------ Key: HHH-4769 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-4769 Project: Hibernate Core Issue Type: Bug Components: core, entity-manager, query-hql Affects Versions: 3.3.2 Environment: hibernate 3.3.2, mysql-connector-java-5.1.7, database MYSQL 5. Reporter: Andrea Tunesi Assignee: Strong Liu Priority: Blocker Running the query "select round(stTmpRiepCap.imponibile,1), round(stTmpRiepCap.ritImponibile,1) from StTmpRiepCap stTmpRiepCap", it always returns an Integer and it always truncate the decimal part of Double number ("stTmpRiepCap.imponibile" and "stTmpRiepCap.ritImponibile" are "java.lang.Double"). Example REAL VALUE - Imponibile: 1528.57 -- Ritenuta imponibile 266.13 VALUE RETURNED USING ROUND - Imponibile: 1528 -- Ritenuta imponibile 266