You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@openjpa.apache.org by "Hiroki Tateno (JIRA)" <ji...@apache.org> on 2009/10/30 02:12:59 UTC
[jira] Updated: (OPENJPA-681) Subquery generates SQL with syntax
error
[ https://issues.apache.org/jira/browse/OPENJPA-681?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Hiroki Tateno updated OPENJPA-681:
----------------------------------
Attachment: OPENJPA-681_1_1_x.patch
Hi,
I backported it to 1.1.x branch.
It works fine for my failure and I verified all tests were passed.
Would greatly appreciated if you merge this into 1.1.x.
Thanks,
Hiroki
> Subquery generates SQL with syntax error
> ----------------------------------------
>
> Key: OPENJPA-681
> URL: https://issues.apache.org/jira/browse/OPENJPA-681
> Project: OpenJPA
> Issue Type: Sub-task
> Reporter: Catalina Wei
> Fix For: 1.0.4, 1.2.1, 1.3.0
>
> Attachments: OPENJPA-681_1_1_x.patch
>
>
> This is another kind of subquery that is not handled correctly in resolving table aliases, the failed JPQL:
> "select o1.oid, c.name from Order o1, Customer c where o1.amount = " +
> " any(select o2.amount from in(c.orders) o2)",
> The incorrect SQL contains t4.name where t4 is not defined in FROM clause:
> SELECT t0.oid, t4.name FROM Order t0 JOIN Customer t1 ON (1 = 1) WHERE (t0.amount = ANY (SELECT t3.amount FROM Customer t1, Order t2, Order t3 WHERE (t2.oid = t3.oid) AND t1.countryCode = t2.CUSTOMER_COUNTRYCODE AND t1.id = t2.CUSTOMER_ID ))
> The correct SQL should be:
> SELECT t0.oid, t1.name FROM Order t0 JOIN Customer t1 ON (1 = 1) WHERE (t0.amount = ANY (SELECT t3.amount FROM Order t2, Order t3 WHERE (t2.oid = t3.oid) AND t1.countryCode = t2.CUSTOMER_COUNTRYCODE AND t1.id = t2.CUSTOMER_ID ))
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.