[OPENJPA-189] EXISTS conditional operator and subquery don't return values, but they do exist

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 0.9.7
• Component/s: query
• Assignee: Unassigned
• Reporter: Jacek Laskowski
• Created: 28/Mar/07 08:02
• Updated: 28/Mar/07 08:57

Description

The test says it all. When the line where the condition is checked is removed the test fails with Apache OpenJPA 0.9.7-SNAPSHOT.

public void testExists() {
Query query = em.createQuery("SELECT DISTINCT p FROM Projekt p WHERE EXISTS (SELECT zaleznosc FROM Projekt zaleznosc WHERE zaleznosc MEMBER OF p.zaleznosci AND zaleznosc.rodzajProjektu = pl.jaceklaskowski.jpa.entity.RodzajProjektu.OTWARTY)");
// Apache OpenJPA 0.9.7-SNAPSHOT workaround so the test passes
// TopLink Essentials 2.0 BUILD 40 i Hibernate EntityManager 3.3.0.GA work fine
if (!em.getClass().getCanonicalName().equals("org.apache.openjpa.persistence.EntityManagerImpl"))

{ List<Projekt> projekty = query.getResultList(); assert projekty.size() == 1 : projekty.size() + " projects received"; assert projekty.get(0).getNazwa().equals("Apache Geronimo") : "Should be 'Apache Geronimo', but was " + projekty.get(0).getNazwa(); }

}