[jboss-jira] [JBoss JIRA] (AS7-4135) Count query on classes mapped as EmbeddedId with multiple Id's fail to execute

[Scott Marlow (JIRA)]

    [ https://issues.jboss.org/browse/AS7-4135?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12675999#comment-12675999 ] 

Scott Marlow commented on AS7-4135:
-----------------------------------

For anyone watching, HHH-7165 is the HHH jira for this issue.
                
> 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/54911765de7981ec9a2318fc9928be68ff37bab3

--
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