Ståle Pedersen created AS7-4135: ----------------------------------- Summary: Count query on classes mapped as EmbeddedId with multiple Id's fail to execute Key: AS7-4135 URL: https://issues.jboss.org/browse/AS7-4135 Project: Application Server 7 Issue Type: Bug Components: JPA / Hibernate Affects Versions: 7.1.1.Final Environment: Verified on MySQL and MariaDB Reporter: Ståle Pedersen Assignee: Scott Marlow Priority: Critical When doing a count on a class mapped as EmbeddedId with multiple Id's the generated sql will fail on several db's (tested on MySQL/MariaDB) since hibernate generate a count sql containing all the id's. Hibernate creates a different (correct) sql on classes mapped with IdClass and multiple Id's. A simple test that verify the difference between the two: https://github.com/stalep/hibernate-orm/commit/54911765de7981ec9a2318fc99... -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira