[OPENJPA-187] MEMBER OF query fails on OpenJPA, but works fine with TopLink and Hibernate EM

• Type: New Feature
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 0.9.7
• Fix Version/s: 1.2.0, 1.3.0
• Component/s: query
• Assignee: Pinaki Poddar
• Reporter: Jacek Laskowski
• Created: 28/Mar/07 07:53
• Updated: 09/Mar/10 18:32
• Resolved: 31/Jul/08 15:36

Description

What's wrong with the following query?

Query query = em.createQuery("SELECT DISTINCT o FROM Osoba o WHERE :projekt MEMBER OF o.projekty");
query.setParameter("projekt", new Projekt("Apache OpenEJB", RodzajProjektu.OTWARTY));
List<Osoba> osoby = query.getResultList();
assert osoby.size() == 1 : "Otrzymano " + osoby.size();

where Projekt is an entity where @Id is of type String (the first input parameter in the two-param constructor above).

TopLink 2.0 BUILD 40 and Hibernate EntityManager 3.3.0.GA work fine whereas OpenJPA 0.9.7-SNAPSHOT finishes with the java.lang.AssertionError error (it's the test itself actually, but since the query returns 0 elements the issue originates in OpenJPA).