Mailing-List: contact dev-help@openjpa.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@openjpa.apache.org
Message-ID: <1266493210.1222171604186.JavaMail.jira@brutus>
Date: Tue, 23 Sep 2008 05:06:44 -0700 (PDT)
From: "Bjorn Beskow (JIRA)" <jira@apache.org>
To: dev@openjpa.apache.org
Subject: [jira] Updated: (OPENJPA-728) SubQuery with Exists generates
 invalid SQL
In-Reply-To: <2057779698.1221736304410.JavaMail.jira@brutus>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit


     [ https://issues.apache.org/jira/browse/OPENJPA-728?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Bjorn Beskow updated OPENJPA-728:
---------------------------------

    Attachment: openjpa-bug.zip

Fixed testcase with inverse relationship, to show that SQL generation problem still remains.

> SubQuery with Exists generates invalid SQL
> ------------------------------------------
>
>                 Key: OPENJPA-728
>                 URL: https://issues.apache.org/jira/browse/OPENJPA-728
>             Project: OpenJPA
>          Issue Type: Bug
>          Components: query
>    Affects Versions: 1.0.2, 1.0.3, 1.1.0, 1.2.0
>         Environment: Windows XP, JDK 1.6.0_07, Derby and HSQL.
>            Reporter: Bjorn Beskow
>            Assignee: Michael Dick
>            Priority: Critical
>         Attachments: openjpa-bug.zip, openjpa-bug.zip
>
>
> When using a subquery containing EXISTS, the generated SQL contains table aliases that does not exist in the select statement. For example, the following query:
>       SELECT new test.dto.EmployeeReportDTO(e.name, a.city)
>       FROM Employee e JOIN e.address a 
>       WHERE e.name LIKE :name
>       AND EXISTS (SELECT p.number from PhoneNumber p WHERE p.owner = e)
> Column not found: T3.CITY in statement [SELECT t0.name, t3.city FROM Employee t0 INNER JOIN Address t1 ON t0.address_id = t1.id WHERE (t0.name LIKE ? ESCAPE '\' AND NOT (EXISTS (SELECT t2.number FROM Address t1, PhoneNumber t2 WHERE (t2.owner_id = t0.id))))]

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