openjpa-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Catalina Wei (JIRA)" <j...@apache.org>
Subject [jira] Created: (OPENJPA-28) groupby clause of a subquery incorrectly duplicated in the main query in the generated SQL
Date Mon, 21 Aug 2006 19:11:14 GMT
groupby clause of a subquery incorrectly duplicated in the main query in the generated SQL
------------------------------------------------------------------------------------------

                 Key: OPENJPA-28
                 URL: http://issues.apache.org/jira/browse/OPENJPA-28
             Project: OpenJPA
          Issue Type: Bug
          Components: query
            Reporter: Catalina Wei


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.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

Mime
View raw message