[ http://issues.apache.org/jira/browse/OPENJPA-49?page=comments#action_12436054 ] George Hongell commented on OPENJPA-49: ---------------------------------------
removed testcase references. run on version 443432. EJBQL: select count(e) from EmpBean e, DeptBean d, EmpBean e1 OPENJPA ERROR OR SQL PUSHDOWN: returns count of 10 when should return count of 500 15469 TRACE [main] openjpa.jdbc.SQL - <t 1094861122, conn 295440796> [0 ms] executing prepstmnt 582099634 SELECT COUNT(t0.empid) FROM EmpBean t0 SUGGESTED SQL PUSHDOWN: select count(t0) FROM EmpBean t0 ,DeptBean t1 ,EmpBean t2 > bad sql pushdown, should use inner joins but has no joins, just uses first > entity > --------------------------------------------------------------------------------- > > Key: OPENJPA-49 > URL: http://issues.apache.org/jira/browse/OPENJPA-49 > Project: OpenJPA > Issue Type: Bug > Components: query > Environment: Windows xp, db2, derby > Reporter: George Hongell > Attachments: failureEntities.jar > > > 182 bad pushdown, should use inner joins but has no joins, just uses first > entity > TEST182; select count(e) from EmpBean e, DeptBean d, EmpBean e1 > 15469 TRACE [main] openjpa.jdbc.SQL - <t 1094861122, conn 295440796> [0 ms] > executing prepstmnt 582099634 SELECT COUNT(t0.empid) FROM EmpBean t0 > s/b > select count(t0) FROM EmpBean t0 ,DeptBean t1 ,EmpBean t2 > [ FAILED 182- bucket = fvtfull, query = select count(e) from EmpBean e, > DeptBean d, EmpBean e1 : > EXPECTED( > TEST182; select count(e) from EmpBean e, DeptBean d, EmpBean e1 > [500] > TEST182; 1 tuple ) > ACTUAL( > TEST182; select count(e) from EmpBean e, DeptBean d, EmpBean e1 > count(e) > ~~~~~~~~ > 10 > TEST182; 1 tuple) ] -- 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