openjpa-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Hebert Coelho (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (OPENJPA-2333) Problem with duplicated results in criteria
Date Wed, 27 Feb 2013 18:35:14 GMT

    [ https://issues.apache.org/jira/browse/OPENJPA-2333?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13588598#comment-13588598
] 

Hebert Coelho commented on OPENJPA-2333:
----------------------------------------

But the spec is not the same for JPQL and Criteria? Should not result in the same query and
results since both result in a query that bring the same result?

Thanks

PS.: if needed, I can add the test case.
                
> Problem with duplicated results in criteria
> -------------------------------------------
>
>                 Key: OPENJPA-2333
>                 URL: https://issues.apache.org/jira/browse/OPENJPA-2333
>             Project: OpenJPA
>          Issue Type: Bug
>    Affects Versions: 2.2.1
>         Environment: linux or windows
> jdk 6 or 7
> OpenJPA 2.2
>            Reporter: Hebert Coelho
>
> I have described the problem in here: http://openjpa.208410.n2.nabble.com/Problem-with-JPA-Criteria-td7582759.html#a7582764
> The code bellow brings duplicated results when it should only bring one result
>         CriteriaBuilder criteriaBuilder = em.getCriteriaBuilder();
>         CriteriaQuery<Person> criteriaQuery = criteriaBuilder.createQuery(Person.class);
>         Root<Person> mainRoot = criteriaQuery.from(Person.class);
>         criteriaQuery.select(mainRoot);
>         mainRoot.join("dogs", JoinType.INNER);
>         Predicate predicate = criteriaBuilder.and(criteriaBuilder.equal(mainRoot.get("dogs").get("name"),
"Fire"));
>         criteriaQuery.where(predicate);
>         TypedQuery<Person> criteriaGeneratedQuery = em.createQuery(criteriaQuery);
>         System.err.println(criteriaGeneratedQuery.getResultList()); // brings two objects
instead one
> In the tested database, there is only one dog named Fire.
> If you need more information, just say it.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira

Mime
View raw message