[
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
