[hibernate-issues] [Hibernate-JIRA] Updated: (HHH-7165) count() query on classes using EmbeddedId should not use id column tuple on Dialects which dont support non-distinct tuple counts

[Steve Ebersole (JIRA)]

     [ https://hibernate.onjira.com/browse/HHH-7165?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Steve Ebersole updated HHH-7165:
--------------------------------

    Pull Requests: https://github.com/hibernate/hibernate-orm/pull/287  (was: https://github.com/hibernate/hibernate-orm/pull/287)
          Summary: count() query on classes using EmbeddedId should not use id column tuple on Dialects which dont support non-distinct tuple counts   (was: Count query on classes mapped as EmbeddedId with multiple Id columns fail to execute)

> count() query on classes using EmbeddedId should not use id column tuple on Dialects which dont support non-distinct tuple counts 
> ----------------------------------------------------------------------------------------------------------------------------------
>
>                 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
>            Assignee: Steve Ebersole
>         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