openjpa-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Patrick Linskey (JIRA)" <j...@apache.org>
Subject [jira] Updated: (OPENJPA-28) groupby clause of a subquery incorrectly duplicated in the main query in the generated SQL
Date Thu, 01 Mar 2007 01:12:52 GMT

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

Patrick Linskey updated OPENJPA-28:
-----------------------------------

    Fix Version/s: 0.9.7

> groupby clause of a subquery incorrectly duplicated in the main query in the generated
SQL
> ------------------------------------------------------------------------------------------
>
>                 Key: OPENJPA-28
>                 URL: https://issues.apache.org/jira/browse/OPENJPA-28
>             Project: OpenJPA
>          Issue Type: Bug
>          Components: query
>            Reporter: Catalina Wei
>             Fix For: 0.9.7
>
>
> JPquery: select e.name, e.salary from EmpBean e where (e.name = Any(select e1.name from
EmpBean e1 group by e1.name )) order by e.name 
> generated pushdown SQL:
> SELECT t0.name, t0.salary, t1.name FROM EmpBean t0 JOIN EmpBean t1 ON (1 = 1) WHERE (t0.name
= ANY((SELECT t2.name FROM EmpBean t2 GROUP BY t2.name))) GROUP BY t1.name ORDER BY t0.name
ASC
> correct pushdown SQL should be:
> SELECT t0.name, t0.salary, t1.name FROM EmpBean t0 JOIN EmpBean t1 ON (1 = 1) WHERE (t0.name
= ANY((SELECT t2.name FROM EmpBean t2 GROUP BY t2.name))) ORDER BY t0.name ASC

-- 
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