Hebert Coelho created OPENJPA-2333:
--------------------------------------
Summary: 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
