[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-5419) COUNT operator with composite primary key and JPA 2.0 Criteria API produces bad sql

[Steve Ebersole (JIRA)]

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

Steve Ebersole commented on HHH-5419:
-------------------------------------

Well we still need to make sure it works for you with your db in SOME release of Hibernate.  Otherwise JBoss has nothing to pull in.  What Dialect do you use?

> COUNT operator with composite primary key and JPA 2.0 Criteria API produces bad sql
> -----------------------------------------------------------------------------------
>
>                 Key: HHH-5419
>                 URL: https://hibernate.onjira.com/browse/HHH-5419
>             Project: Hibernate ORM
>          Issue Type: Bug
>    Affects Versions: 3.5.4, 3.6.0.Beta1, 4.0.0.CR3
>         Environment: hibernate-entitymanager 3.6.0.Beta1, glassfish 3.0.1, linux ubuntu 10.04, MS SQL Server 2008
>            Reporter: Fabio Braga de Oliveira
>            Assignee: John Verhaeg
>            Priority: Minor
>             Fix For: 4.0.0.CR4, 4.0.0.CR5
>
>         Attachments: hibernate-count-bug.zip
>
>
> Hibernate produces a invalid SQL if anyone use the count() operator with the JPA 2.0 Criteria API. Code:
> CriteriaBuilder cb = getEntityManager().getCriteriaBuilder();
> CriteriaQuery<Object[]> cq = cb.createQuery(Object[].class);
> Root<EntityCompositePK> r = cq.from(EntityCompositePK.class);
> cq.multiselect(cb.count(r));
> assertEquals(0, ((Long) (getEntityManager().createQuery(cq).getSingleResult())[0]).intValue());
> I'm sending a little maven project which reproduces the bug.

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira