openjpa-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Marc Prud'hommeaux (JIRA)" <j...@apache.org>
Subject [jira] Commented: (OPENJPA-189) EXISTS conditional operator and subquery don't return values, but they do exist
Date Wed, 28 Mar 2007 08:58:32 GMT

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

Marc Prud'hommeaux commented on OPENJPA-189:
--------------------------------------------

If you just execute the subquery by itself, does it return any results?

Also, can you enable SQL logging and post the SQL that is executed when you run the subquery?

> EXISTS conditional operator and subquery don't return values, but they do exist
> -------------------------------------------------------------------------------
>
>                 Key: OPENJPA-189
>                 URL: https://issues.apache.org/jira/browse/OPENJPA-189
>             Project: OpenJPA
>          Issue Type: Bug
>          Components: query
>    Affects Versions: 0.9.7
>            Reporter: Jacek Laskowski
>
> 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();
>     }
>   }

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


Mime
View raw message