Parameters of type Long should be casted as SIGNED in MySQL when using cast() ----------------------------------------------------------------------------- Key: HHH-1811 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-1811 Project: Hibernate3 Issue Type: Bug Components: query-hql Environment: MySQL4.1, Hibernate 3.1.3 Reporter: Ricardo Illgen Priority: Minor When using the function cast() in mysql, hibernate doesnt handle properly the properties of type Long. I made a workaround in my application extending the MySQLDialect class, and overwriting the getCastTypeName(int code) method, so it returns "signed" for BIGINT sql types too. Currently its falling back to the ancestor class method and returning "long" which causes an syntax error in MySQL.