[ http://issues.apache.org/jira/browse/JDO-242?page=all ] Michael Bouschen resolved JDO-242: ----------------------------------
Resolution: Fixed This is the same as described in JDO-244 and JDO-271: the JDOQL query is not valid, because it uses a field from the subclass. Craig fixed this with revision 365775. > JPOX returns wrong query result for test case Grouping. > ------------------------------------------------------- > > Key: JDO-242 > URL: http://issues.apache.org/jira/browse/JDO-242 > Project: JDO > Type: Bug > Components: tck20 > Reporter: Michael Watzek > Assignee: Erik Bengtson > > Test case Grouping fails for the query below due to a wrong value returned > for SUM(salary): > 14:22:47,921 (main) DEBUG [org.apache.jdo.tck] - Executing API query: SELECT > department, SUM(salary) FROM org.apache.jdo.tck.pc.company.Employee GROUP BY > department > 14:22:47,968 (main) DEBUG [org.apache.jdo.tck] - Query result: > [[Department(1, name Development), 30000.0], [Department(2, name Human > Resources), 45000.0]] > 14:22:47,968 (main) DEBUG [org.apache.jdo.tck] - Wrong query result: > expected: [[Department(1, name Development), 45000.0], [Department(2, name > Human Resources), 58000.0]] > got: [[Department(1, name Development), 30000.0], [Department(2, name > Human Resources), 45000.0]] > 14:22:47,968 (main) INFO [org.apache.jdo.tck] - Exception during setUp or > runtest: > junit.framework.AssertionFailedError: Assertion A14.6.10-1 (Grouping) failed: > Wrong query result: > expected: [[Department(1, name Development), 45000.0], [Department(2, name > Human Resources), 58000.0]] > got: [[Department(1, name Development), 30000.0], [Department(2, name > Human Resources), 45000.0]] > at junit.framework.Assert.fail(Assert.java:47) > at org.apache.jdo.tck.JDO_Test.fail(JDO_Test.java:546) > at org.apache.jdo.tck.query.QueryTest.queryFailed(QueryTest.java:500) > at > org.apache.jdo.tck.query.QueryTest.checkQueryResultWithoutOrder(QueryTest.java:485) > at org.apache.jdo.tck.query.QueryTest.execute(QueryTest.java:1189) > at org.apache.jdo.tck.query.QueryTest.execute(QueryTest.java:1029) > at > org.apache.jdo.tck.query.QueryTest.executeAPIQuery(QueryTest.java:966) > at > org.apache.jdo.tck.query.QueryTest.executeAPIQuery(QueryTest.java:946) > at > org.apache.jdo.tck.query.result.Grouping.testPositive(Grouping.java:112) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) > at java.lang.reflect.Method.invoke(Method.java:324) > at junit.framework.TestCase.runTest(TestCase.java:154) > at org.apache.jdo.tck.JDO_Test.runBare(JDO_Test.java:204) > at junit.framework.TestResult$1.protect(TestResult.java:106) > at junit.framework.TestResult.runProtected(TestResult.java:124) > at junit.framework.TestResult.run(TestResult.java:109) > at junit.framework.TestCase.run(TestCase.java:118) > at junit.framework.TestSuite.runTest(TestSuite.java:208) > at junit.framework.TestSuite.run(TestSuite.java:203) > at junit.framework.TestSuite.runTest(TestSuite.java:208) > at junit.framework.TestSuite.run(TestSuite.java:203) > at junit.textui.TestRunner.doRun(TestRunner.java:116) > at junit.textui.TestRunner.doRun(TestRunner.java:109) > at > org.apache.jdo.tck.util.BatchTestRunner.start(BatchTestRunner.java:120) > at org.apache.jdo.tck.util.BatchTestRunner.main(BatchTestRunner.java:95) -- 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