Joni Ollila updated an issue

Hibernate ORM / HHH-11207 JPQL cast and Criteria API Expression.as produce wrong SQL for Float and Double types with mySQL database Change By: Joni Ollila Component/s: query-criteria Component/s: hibernate-core Summary: JPQL cast and Criteria API Expression.as produces produce wrong SQL for Float and Double types with mySQL database When creating Criteria API expression using Expression.as(Double.class) or Expression.as(Float.class) wrong SQL is produced. First one produces "cast(<attribute> as double precision)" and the second one "cast(<attribute> as float)". Either of these syntax are not working with MySQL database. Noticed that same bug applies also to JPQL queries, so it is not Criteria API specific. For example "select cast(t.<attribute> as double) from Table t". Add Comment

This message was sent by Atlassian JIRA (v1000.482.0#100017-sha1:2ceeb22)