[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-7165) ount query on classes mapped as EmbeddedId with multiple Id's fail to execute

[Jeremy Whiting (JIRA)]

    [ https://hibernate.onjira.com/browse/HHH-7165?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=45916#comment-45916 ] 

Jeremy Whiting commented on HHH-7165:
-------------------------------------

 I have been working on getting a test case together too. There are three projects in the attachment added to this issue. An EJB, ejbclient test case and parent project.
 The test fails to work with either MySQL or MariaDB. PostgreSQL works because it tolerates multiple columns in a count clause.

> ount query on classes mapped as EmbeddedId with multiple Id's fail to execute
> -----------------------------------------------------------------------------
>
>                 Key: HHH-7165
>                 URL: https://hibernate.onjira.com/browse/HHH-7165
>             Project: Hibernate ORM
>          Issue Type: Bug
>          Components: core
>    Affects Versions: 4.1.1
>            Reporter: Ståle W. Pedersen
>         Attachments: column-count-test.tar.bz2
>
>
> 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.
For more information on JIRA, see: http://www.atlassian.com/software/jira