RUN AggregateOnSize.testMaxAndSizeInSubquery ERROR RUN MethodsInResult.testCollectionSizeInResult ERROR RUN MethodsInResult.testMapSizeInResult ERROR RUN MethodsInResult.testMaxAndSizeInResult ERROR RUN MethodsInResult.testMapGetInResult FAILURE RUN MethodsInResult.testSubstringInResult ERROR RUN MethodsInResult.testIndexOfInResult FAILURE Description: One test, no testdata. Time: 021 There were 5 errors: 1) testMaxAndSizeInSubquery(org.apache.jdo.tck.query.jdoql.subqueries.AggregateOnSize)javax.jdo.JDOException: JDOUserException thrown while executing query: SELECT FROM org.apache.jdo.tck.pc.company.Department WHERE this.employees.size() == (SELECT MAX(d.employees.size()) FROM org.apache.jdo.tck.pc.company.Department d) at org.apache.jdo.tck.query.QueryTest.execute(QueryTest.java:1307) at org.apache.jdo.tck.query.QueryTest.executeJDOQuery(QueryTest.java:1161) at org.apache.jdo.tck.query.jdoql.subqueries.AggregateOnSize.testMaxAndSizeInSubquery(AggregateOnSize.java:72) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at org.apache.jdo.tck.JDO_Test.runBare(JDO_Test.java:272) at org.apache.jdo.tck.util.BatchTestRunner.doRun(BatchTestRunner.java:108) at org.apache.jdo.tck.util.BatchTestRunner.start(BatchTestRunner.java:148) at org.apache.jdo.tck.util.BatchTestRunner.main(BatchTestRunner.java:123) NestedThrowablesStackTrace: javax.jdo.JDOUserException: The expression AggregateExpression "MAX((SELECT COUNT(*) FROM applicationidentity0.PERSONS SUB_EMPLOYEES WHERE SUB_EMPLOYEES.DEPARTMENT = SUB.ID))" is not supported in results. at org.datanucleus.jdo.NucleusJDOHelper.getJDOExceptionForNucleusException(NucleusJDOHelper.java:405) at org.datanucleus.jdo.JDOQuery.execute(JDOQuery.java:224) at org.apache.jdo.tck.query.QueryTest.execute(QueryTest.java:1255) at org.apache.jdo.tck.query.QueryTest.executeJDOQuery(QueryTest.java:1161) at org.apache.jdo.tck.query.jdoql.subqueries.AggregateOnSize.testMaxAndSizeInSubquery(AggregateOnSize.java:72) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at org.apache.jdo.tck.JDO_Test.runBare(JDO_Test.java:272) at org.apache.jdo.tck.util.BatchTestRunner.doRun(BatchTestRunner.java:108) at org.apache.jdo.tck.util.BatchTestRunner.start(BatchTestRunner.java:148) at org.apache.jdo.tck.util.BatchTestRunner.main(BatchTestRunner.java:123) NestedThrowablesStackTrace: The expression AggregateExpression "MAX((SELECT COUNT(*) FROM applicationidentity0.PERSONS SUB_EMPLOYEES WHERE SUB_EMPLOYEES.DEPARTMENT = SUB.ID))" is not supported in results. org.datanucleus.exceptions.NucleusUserException: The expression AggregateExpression "MAX((SELECT COUNT(*) FROM applicationidentity0.PERSONS SUB_EMPLOYEES WHERE SUB_EMPLOYEES.DEPARTMENT = SUB.ID))" is not supported in results. at org.datanucleus.store.rdbms.query.ResultExpressionsQueryable.newResultObjectFactory(ResultExpressionsQueryable.java:406) at org.datanucleus.store.rdbms.query.JDOQLQueryCompiler.compileSubqueryVariable(JDOQLQueryCompiler.java:1067) at org.datanucleus.store.rdbms.query.JDOQLQueryCompiler.compileIdentifier(JDOQLQueryCompiler.java:932) at org.datanucleus.store.rdbms.query.JDOQLQueryCompiler.compilePrimary(JDOQLQueryCompiler.java:778) at org.datanucleus.store.rdbms.query.JavaQueryCompiler.compileUnaryExpressionNotPlusMinus(JavaQueryCompiler.java:1133) at org.datanucleus.store.rdbms.query.JavaQueryCompiler.compileUnaryExpression(JavaQueryCompiler.java:1114) at org.datanucleus.store.rdbms.query.JavaQueryCompiler.compileMultiplicativeExpression(JavaQueryCompiler.java:1067) at org.datanucleus.store.rdbms.query.JavaQueryCompiler.compileAdditiveExpression(JavaQueryCompiler.java:1044) at org.datanucleus.store.rdbms.query.JDOQLQueryCompiler.compileRelationalExpression(JDOQLQueryCompiler.java:691) at org.datanucleus.store.rdbms.query.JDOQLQueryCompiler.compileEqualityExpression(JDOQLQueryCompiler.java:669) at org.datanucleus.store.rdbms.query.JDOQLQueryCompiler.compileAndExpression(JDOQLQueryCompiler.java:651) at org.datanucleus.store.rdbms.query.JDOQLQueryCompiler.compileExclusiveOrExpression(JDOQLQueryCompiler.java:639) at org.datanucleus.store.rdbms.query.JDOQLQueryCompiler.compileInclusiveOrExpression(JDOQLQueryCompiler.java:627) at org.datanucleus.store.rdbms.query.JDOQLQueryCompiler.compileConditionalAndExpression(JDOQLQueryCompiler.java:615) at org.datanucleus.store.rdbms.query.JDOQLQueryCompiler.compileConditionalOrExpression(JDOQLQueryCompiler.java:597) at org.datanucleus.store.rdbms.query.JDOQLQueryCompiler.compileExpression(JDOQLQueryCompiler.java:574) at org.datanucleus.store.rdbms.query.JDOQLQueryCompiler.compileExpressionFromString(JDOQLQueryCompiler.java:554) at org.datanucleus.store.rdbms.query.JavaQueryCompiler.compileFilter(JavaQueryCompiler.java:652) at org.datanucleus.store.rdbms.query.JDOQLQueryCompiler.performCompile(JDOQLQueryCompiler.java:263) at org.datanucleus.store.rdbms.query.JavaQueryCompiler.executionCompile(JavaQueryCompiler.java:299) at org.datanucleus.store.rdbms.query.JDOQLQueryCompiler.compile(JDOQLQueryCompiler.java:227) at org.datanucleus.store.rdbms.query.JDOQLQuery.compileInternal(JDOQLQuery.java:169) at org.datanucleus.store.query.Query.executeQuery(Query.java:1328) at org.datanucleus.store.rdbms.query.JDOQLQuery.executeQuery(JDOQLQuery.java:226) at org.datanucleus.store.query.Query.executeWithArray(Query.java:1269) at org.datanucleus.store.query.Query.execute(Query.java:1208) at org.datanucleus.jdo.JDOQuery.execute(JDOQuery.java:215) at org.apache.jdo.tck.query.QueryTest.execute(QueryTest.java:1255) at org.apache.jdo.tck.query.QueryTest.executeJDOQuery(QueryTest.java:1161) at org.apache.jdo.tck.query.jdoql.subqueries.AggregateOnSize.testMaxAndSizeInSubquery(AggregateOnSize.java:72) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at org.apache.jdo.tck.JDO_Test.runBare(JDO_Test.java:272) at org.apache.jdo.tck.util.BatchTestRunner.doRun(BatchTestRunner.java:108) at org.apache.jdo.tck.util.BatchTestRunner.start(BatchTestRunner.java:148) at org.apache.jdo.tck.util.BatchTestRunner.main(BatchTestRunner.java:123) 2) testCollectionSizeInResult(org.apache.jdo.tck.query.jdoql.result.MethodsInResult)javax.jdo.JDOException: JDOUserException thrown while executing query: SELECT this.employees.size() FROM org.apache.jdo.tck.pc.company.Department ORDER BY this.name ascending at org.apache.jdo.tck.query.QueryTest.execute(QueryTest.java:1307) at org.apache.jdo.tck.query.QueryTest.execute(QueryTest.java:1133) at org.apache.jdo.tck.query.QueryTest.executeAPIQuery(QueryTest.java:1069) at org.apache.jdo.tck.query.QueryTest.executeAPIQuery(QueryTest.java:1049) at org.apache.jdo.tck.query.jdoql.result.MethodsInResult.testCollectionSizeInResult(MethodsInResult.java:180) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at org.apache.jdo.tck.JDO_Test.runBare(JDO_Test.java:272) at org.apache.jdo.tck.util.BatchTestRunner.doRun(BatchTestRunner.java:108) at org.apache.jdo.tck.util.BatchTestRunner.start(BatchTestRunner.java:148) at org.apache.jdo.tck.util.BatchTestRunner.main(BatchTestRunner.java:123) NestedThrowablesStackTrace: javax.jdo.JDOUserException: The expression ContainerSizeExpression "(SELECT COUNT(*) FROM applicationidentity0.PERSONS THIS_EMPLOYEES WHERE THIS_EMPLOYEES.DEPARTMENT = THIS.ID)" is not supported in results. at org.datanucleus.jdo.NucleusJDOHelper.getJDOExceptionForNucleusException(NucleusJDOHelper.java:405) at org.datanucleus.jdo.JDOQuery.execute(JDOQuery.java:224) at org.apache.jdo.tck.query.QueryTest.execute(QueryTest.java:1255) at org.apache.jdo.tck.query.QueryTest.execute(QueryTest.java:1133) at org.apache.jdo.tck.query.QueryTest.executeAPIQuery(QueryTest.java:1069) at org.apache.jdo.tck.query.QueryTest.executeAPIQuery(QueryTest.java:1049) at org.apache.jdo.tck.query.jdoql.result.MethodsInResult.testCollectionSizeInResult(MethodsInResult.java:180) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at org.apache.jdo.tck.JDO_Test.runBare(JDO_Test.java:272) at org.apache.jdo.tck.util.BatchTestRunner.doRun(BatchTestRunner.java:108) at org.apache.jdo.tck.util.BatchTestRunner.start(BatchTestRunner.java:148) at org.apache.jdo.tck.util.BatchTestRunner.main(BatchTestRunner.java:123) NestedThrowablesStackTrace: The expression ContainerSizeExpression "(SELECT COUNT(*) FROM applicationidentity0.PERSONS THIS_EMPLOYEES WHERE THIS_EMPLOYEES.DEPARTMENT = THIS.ID)" is not supported in results. org.datanucleus.exceptions.NucleusUserException: The expression ContainerSizeExpression "(SELECT COUNT(*) FROM applicationidentity0.PERSONS THIS_EMPLOYEES WHERE THIS_EMPLOYEES.DEPARTMENT = THIS.ID)" is not supported in results. at org.datanucleus.store.rdbms.query.ResultExpressionsQueryable.newResultObjectFactory(ResultExpressionsQueryable.java:406) at org.datanucleus.store.rdbms.query.JDOQLQuery.performExecute(JDOQLQuery.java:262) at org.datanucleus.store.query.Query.executeQuery(Query.java:1361) at org.datanucleus.store.rdbms.query.JDOQLQuery.executeQuery(JDOQLQuery.java:226) at org.datanucleus.store.query.Query.executeWithArray(Query.java:1269) at org.datanucleus.store.query.Query.execute(Query.java:1208) at org.datanucleus.jdo.JDOQuery.execute(JDOQuery.java:215) at org.apache.jdo.tck.query.QueryTest.execute(QueryTest.java:1255) at org.apache.jdo.tck.query.QueryTest.execute(QueryTest.java:1133) at org.apache.jdo.tck.query.QueryTest.executeAPIQuery(QueryTest.java:1069) at org.apache.jdo.tck.query.QueryTest.executeAPIQuery(QueryTest.java:1049) at org.apache.jdo.tck.query.jdoql.result.MethodsInResult.testCollectionSizeInResult(MethodsInResult.java:180) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at org.apache.jdo.tck.JDO_Test.runBare(JDO_Test.java:272) at org.apache.jdo.tck.util.BatchTestRunner.doRun(BatchTestRunner.java:108) at org.apache.jdo.tck.util.BatchTestRunner.start(BatchTestRunner.java:148) at org.apache.jdo.tck.util.BatchTestRunner.main(BatchTestRunner.java:123) 3) testMapSizeInResult(org.apache.jdo.tck.query.jdoql.result.MethodsInResult)javax.jdo.JDOException: JDOUserException thrown while executing query: SELECT this.phoneNumbers.size() FROM org.apache.jdo.tck.pc.company.Employee ORDER BY this.lastname ascending, this.firstname ascending at org.apache.jdo.tck.query.QueryTest.execute(QueryTest.java:1307) at org.apache.jdo.tck.query.QueryTest.execute(QueryTest.java:1133) at org.apache.jdo.tck.query.QueryTest.executeAPIQuery(QueryTest.java:1069) at org.apache.jdo.tck.query.QueryTest.executeAPIQuery(QueryTest.java:1049) at org.apache.jdo.tck.query.jdoql.result.MethodsInResult.testMapSizeInResult(MethodsInResult.java:188) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at org.apache.jdo.tck.JDO_Test.runBare(JDO_Test.java:272) at org.apache.jdo.tck.util.BatchTestRunner.doRun(BatchTestRunner.java:108) at org.apache.jdo.tck.util.BatchTestRunner.start(BatchTestRunner.java:148) at org.apache.jdo.tck.util.BatchTestRunner.main(BatchTestRunner.java:123) NestedThrowablesStackTrace: javax.jdo.JDOUserException: The expression ContainerSizeExpression "(SELECT COUNT(*) FROM applicationidentity0.EMPLOYEE_PHONENO_TYPE THIS_PHONENUMBERS WHERE THIS_PHONENUMBERS.EMPID = THIS.PERSONID)" is not supported in results. at org.datanucleus.jdo.NucleusJDOHelper.getJDOExceptionForNucleusException(NucleusJDOHelper.java:405) at org.datanucleus.jdo.JDOQuery.execute(JDOQuery.java:224) at org.apache.jdo.tck.query.QueryTest.execute(QueryTest.java:1255) at org.apache.jdo.tck.query.QueryTest.execute(QueryTest.java:1133) at org.apache.jdo.tck.query.QueryTest.executeAPIQuery(QueryTest.java:1069) at org.apache.jdo.tck.query.QueryTest.executeAPIQuery(QueryTest.java:1049) at org.apache.jdo.tck.query.jdoql.result.MethodsInResult.testMapSizeInResult(MethodsInResult.java:188) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at org.apache.jdo.tck.JDO_Test.runBare(JDO_Test.java:272) at org.apache.jdo.tck.util.BatchTestRunner.doRun(BatchTestRunner.java:108) at org.apache.jdo.tck.util.BatchTestRunner.start(BatchTestRunner.java:148) at org.apache.jdo.tck.util.BatchTestRunner.main(BatchTestRunner.java:123) NestedThrowablesStackTrace: The expression ContainerSizeExpression "(SELECT COUNT(*) FROM applicationidentity0.EMPLOYEE_PHONENO_TYPE THIS_PHONENUMBERS WHERE THIS_PHONENUMBERS.EMPID = THIS.PERSONID)" is not supported in results. org.datanucleus.exceptions.NucleusUserException: The expression ContainerSizeExpression "(SELECT COUNT(*) FROM applicationidentity0.EMPLOYEE_PHONENO_TYPE THIS_PHONENUMBERS WHERE THIS_PHONENUMBERS.EMPID = THIS.PERSONID)" is not supported in results. at org.datanucleus.store.rdbms.query.ResultExpressionsQueryable.newResultObjectFactory(ResultExpressionsQueryable.java:406) at org.datanucleus.store.rdbms.query.JDOQLQuery.performExecute(JDOQLQuery.java:262) at org.datanucleus.store.query.Query.executeQuery(Query.java:1361) at org.datanucleus.store.rdbms.query.JDOQLQuery.executeQuery(JDOQLQuery.java:226) at org.datanucleus.store.query.Query.executeWithArray(Query.java:1269) at org.datanucleus.store.query.Query.execute(Query.java:1208) at org.datanucleus.jdo.JDOQuery.execute(JDOQuery.java:215) at org.apache.jdo.tck.query.QueryTest.execute(QueryTest.java:1255) at org.apache.jdo.tck.query.QueryTest.execute(QueryTest.java:1133) at org.apache.jdo.tck.query.QueryTest.executeAPIQuery(QueryTest.java:1069) at org.apache.jdo.tck.query.QueryTest.executeAPIQuery(QueryTest.java:1049) at org.apache.jdo.tck.query.jdoql.result.MethodsInResult.testMapSizeInResult(MethodsInResult.java:188) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at org.apache.jdo.tck.JDO_Test.runBare(JDO_Test.java:272) at org.apache.jdo.tck.util.BatchTestRunner.doRun(BatchTestRunner.java:108) at org.apache.jdo.tck.util.BatchTestRunner.start(BatchTestRunner.java:148) at org.apache.jdo.tck.util.BatchTestRunner.main(BatchTestRunner.java:123) 4) testMaxAndSizeInResult(org.apache.jdo.tck.query.jdoql.result.MethodsInResult)javax.jdo.JDOException: JDOUserException thrown while executing query: SELECT MAX(this.employees.size()) FROM org.apache.jdo.tck.pc.company.Department at org.apache.jdo.tck.query.QueryTest.execute(QueryTest.java:1307) at org.apache.jdo.tck.query.QueryTest.execute(QueryTest.java:1133) at org.apache.jdo.tck.query.QueryTest.executeAPIQuery(QueryTest.java:1069) at org.apache.jdo.tck.query.QueryTest.executeAPIQuery(QueryTest.java:1049) at org.apache.jdo.tck.query.jdoql.result.MethodsInResult.testMaxAndSizeInResult(MethodsInResult.java:196) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at org.apache.jdo.tck.JDO_Test.runBare(JDO_Test.java:272) at org.apache.jdo.tck.util.BatchTestRunner.doRun(BatchTestRunner.java:108) at org.apache.jdo.tck.util.BatchTestRunner.start(BatchTestRunner.java:148) at org.apache.jdo.tck.util.BatchTestRunner.main(BatchTestRunner.java:123) NestedThrowablesStackTrace: javax.jdo.JDOUserException: The expression AggregateExpression "MAX((SELECT COUNT(*) FROM applicationidentity0.PERSONS THIS_EMPLOYEES WHERE THIS_EMPLOYEES.DEPARTMENT = THIS.ID))" is not supported in results. at org.datanucleus.jdo.NucleusJDOHelper.getJDOExceptionForNucleusException(NucleusJDOHelper.java:405) at org.datanucleus.jdo.JDOQuery.execute(JDOQuery.java:224) at org.apache.jdo.tck.query.QueryTest.execute(QueryTest.java:1255) at org.apache.jdo.tck.query.QueryTest.execute(QueryTest.java:1133) at org.apache.jdo.tck.query.QueryTest.executeAPIQuery(QueryTest.java:1069) at org.apache.jdo.tck.query.QueryTest.executeAPIQuery(QueryTest.java:1049) at org.apache.jdo.tck.query.jdoql.result.MethodsInResult.testMaxAndSizeInResult(MethodsInResult.java:196) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at org.apache.jdo.tck.JDO_Test.runBare(JDO_Test.java:272) at org.apache.jdo.tck.util.BatchTestRunner.doRun(BatchTestRunner.java:108) at org.apache.jdo.tck.util.BatchTestRunner.start(BatchTestRunner.java:148) at org.apache.jdo.tck.util.BatchTestRunner.main(BatchTestRunner.java:123) NestedThrowablesStackTrace: The expression AggregateExpression "MAX((SELECT COUNT(*) FROM applicationidentity0.PERSONS THIS_EMPLOYEES WHERE THIS_EMPLOYEES.DEPARTMENT = THIS.ID))" is not supported in results. org.datanucleus.exceptions.NucleusUserException: The expression AggregateExpression "MAX((SELECT COUNT(*) FROM applicationidentity0.PERSONS THIS_EMPLOYEES WHERE THIS_EMPLOYEES.DEPARTMENT = THIS.ID))" is not supported in results. at org.datanucleus.store.rdbms.query.ResultExpressionsQueryable.newResultObjectFactory(ResultExpressionsQueryable.java:406) at org.datanucleus.store.rdbms.query.JDOQLQuery.performExecute(JDOQLQuery.java:262) at org.datanucleus.store.query.Query.executeQuery(Query.java:1361) at org.datanucleus.store.rdbms.query.JDOQLQuery.executeQuery(JDOQLQuery.java:226) at org.datanucleus.store.query.Query.executeWithArray(Query.java:1269) at org.datanucleus.store.query.Query.execute(Query.java:1208) at org.datanucleus.jdo.JDOQuery.execute(JDOQuery.java:215) at org.apache.jdo.tck.query.QueryTest.execute(QueryTest.java:1255) at org.apache.jdo.tck.query.QueryTest.execute(QueryTest.java:1133) at org.apache.jdo.tck.query.QueryTest.executeAPIQuery(QueryTest.java:1069) at org.apache.jdo.tck.query.QueryTest.executeAPIQuery(QueryTest.java:1049) at org.apache.jdo.tck.query.jdoql.result.MethodsInResult.testMaxAndSizeInResult(MethodsInResult.java:196) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at org.apache.jdo.tck.JDO_Test.runBare(JDO_Test.java:272) at org.apache.jdo.tck.util.BatchTestRunner.doRun(BatchTestRunner.java:108) at org.apache.jdo.tck.util.BatchTestRunner.start(BatchTestRunner.java:148) at org.apache.jdo.tck.util.BatchTestRunner.main(BatchTestRunner.java:123) 5) testSubstringInResult(org.apache.jdo.tck.query.jdoql.result.MethodsInResult)javax.jdo.JDOException: JDOUserException thrown while executing query: SELECT this.firstname.substring(1,4) FROM org.apache.jdo.tck.pc.company.Employee ORDER BY this.lastname ascending, this.firstname ascending at org.apache.jdo.tck.query.QueryTest.execute(QueryTest.java:1307) at org.apache.jdo.tck.query.QueryTest.execute(QueryTest.java:1133) at org.apache.jdo.tck.query.QueryTest.executeAPIQuery(QueryTest.java:1069) at org.apache.jdo.tck.query.QueryTest.executeAPIQuery(QueryTest.java:1049) at org.apache.jdo.tck.query.jdoql.result.MethodsInResult.testSubstringInResult(MethodsInResult.java:212) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at org.apache.jdo.tck.JDO_Test.runBare(JDO_Test.java:272) at org.apache.jdo.tck.util.BatchTestRunner.doRun(BatchTestRunner.java:108) at org.apache.jdo.tck.util.BatchTestRunner.start(BatchTestRunner.java:148) at org.apache.jdo.tck.util.BatchTestRunner.main(BatchTestRunner.java:123) NestedThrowablesStackTrace: javax.jdo.JDOUserException: The expression StringExpression "SUBSTR(THIS.FIRSTNAME,2,3)" is not supported in results. at org.datanucleus.jdo.NucleusJDOHelper.getJDOExceptionForNucleusException(NucleusJDOHelper.java:405) at org.datanucleus.jdo.JDOQuery.execute(JDOQuery.java:224) at org.apache.jdo.tck.query.QueryTest.execute(QueryTest.java:1255) at org.apache.jdo.tck.query.QueryTest.execute(QueryTest.java:1133) at org.apache.jdo.tck.query.QueryTest.executeAPIQuery(QueryTest.java:1069) at org.apache.jdo.tck.query.QueryTest.executeAPIQuery(QueryTest.java:1049) at org.apache.jdo.tck.query.jdoql.result.MethodsInResult.testSubstringInResult(MethodsInResult.java:212) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at org.apache.jdo.tck.JDO_Test.runBare(JDO_Test.java:272) at org.apache.jdo.tck.util.BatchTestRunner.doRun(BatchTestRunner.java:108) at org.apache.jdo.tck.util.BatchTestRunner.start(BatchTestRunner.java:148) at org.apache.jdo.tck.util.BatchTestRunner.main(BatchTestRunner.java:123) NestedThrowablesStackTrace: The expression StringExpression "SUBSTR(THIS.FIRSTNAME,2,3)" is not supported in results. org.datanucleus.exceptions.NucleusUserException: The expression StringExpression "SUBSTR(THIS.FIRSTNAME,2,3)" is not supported in results. at org.datanucleus.store.rdbms.query.ResultExpressionsQueryable.newResultObjectFactory(ResultExpressionsQueryable.java:406) at org.datanucleus.store.rdbms.query.JDOQLQuery.performExecute(JDOQLQuery.java:262) at org.datanucleus.store.query.Query.executeQuery(Query.java:1361) at org.datanucleus.store.rdbms.query.JDOQLQuery.executeQuery(JDOQLQuery.java:226) at org.datanucleus.store.query.Query.executeWithArray(Query.java:1269) at org.datanucleus.store.query.Query.execute(Query.java:1208) at org.datanucleus.jdo.JDOQuery.execute(JDOQuery.java:215) at org.apache.jdo.tck.query.QueryTest.execute(QueryTest.java:1255) at org.apache.jdo.tck.query.QueryTest.execute(QueryTest.java:1133) at org.apache.jdo.tck.query.QueryTest.executeAPIQuery(QueryTest.java:1069) at org.apache.jdo.tck.query.QueryTest.executeAPIQuery(QueryTest.java:1049) at org.apache.jdo.tck.query.jdoql.result.MethodsInResult.testSubstringInResult(MethodsInResult.java:212) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at org.apache.jdo.tck.JDO_Test.runBare(JDO_Test.java:272) at org.apache.jdo.tck.util.BatchTestRunner.doRun(BatchTestRunner.java:108) at org.apache.jdo.tck.util.BatchTestRunner.start(BatchTestRunner.java:148) at org.apache.jdo.tck.util.BatchTestRunner.main(BatchTestRunner.java:123) There were 2 failures: 1) testMapGetInResult(org.apache.jdo.tck.query.jdoql.result.MethodsInResult)junit.framework.AssertionFailedError: Assertion (MethodsInResult) failed: Wrong query result: query: SELECT this.phoneNumbers.get('home') FROM org.apache.jdo.tck.pc.company.Employee ORDER BY this.lastname ascending, this.firstname ascending expected: java.util.ArrayList of size 5 [1111, 2222, 3333, 3343, 3363] got: java.util.ArrayList of size 10 [123456-1, 1111, 123456-2, 2222, 3333, 123456-3, 124456-3, 3343, 126456-3, 3363] at org.apache.jdo.tck.JDO_Test.fail(JDO_Test.java:682) at org.apache.jdo.tck.query.QueryTest.queryFailed(QueryTest.java:518) at org.apache.jdo.tck.query.QueryTest.checkQueryResultWithOrder(QueryTest.java:533) at org.apache.jdo.tck.query.QueryTest.execute(QueryTest.java:1290) at org.apache.jdo.tck.query.QueryTest.execute(QueryTest.java:1133) at org.apache.jdo.tck.query.QueryTest.executeAPIQuery(QueryTest.java:1069) at org.apache.jdo.tck.query.QueryTest.executeAPIQuery(QueryTest.java:1049) at org.apache.jdo.tck.query.jdoql.result.MethodsInResult.testMapGetInResult(MethodsInResult.java:204) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at org.apache.jdo.tck.JDO_Test.runBare(JDO_Test.java:272) at org.apache.jdo.tck.util.BatchTestRunner.doRun(BatchTestRunner.java:108) at org.apache.jdo.tck.util.BatchTestRunner.start(BatchTestRunner.java:148) at org.apache.jdo.tck.util.BatchTestRunner.main(BatchTestRunner.java:123) 2) testIndexOfInResult(org.apache.jdo.tck.query.jdoql.result.MethodsInResult)junit.framework.AssertionFailedError: Assertion (MethodsInResult) failed: Wrong query result: query: SELECT this.firstname.indexOf('First') FROM org.apache.jdo.tck.pc.company.Employee ORDER BY this.lastname ascending, this.firstname ascending expected: java.util.ArrayList of size 5 [4, 4, 4, 4, 4] got: java.util.ArrayList of size 5 [4, 4, 4, 4, 4] at org.apache.jdo.tck.JDO_Test.fail(JDO_Test.java:682) at org.apache.jdo.tck.query.QueryTest.queryFailed(QueryTest.java:518) at org.apache.jdo.tck.query.QueryTest.checkQueryResultWithOrder(QueryTest.java:533) at org.apache.jdo.tck.query.QueryTest.execute(QueryTest.java:1290) at org.apache.jdo.tck.query.QueryTest.execute(QueryTest.java:1133) at org.apache.jdo.tck.query.QueryTest.executeAPIQuery(QueryTest.java:1069) at org.apache.jdo.tck.query.QueryTest.executeAPIQuery(QueryTest.java:1049) at org.apache.jdo.tck.query.jdoql.result.MethodsInResult.testIndexOfInResult(MethodsInResult.java:220) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at org.apache.jdo.tck.JDO_Test.runBare(JDO_Test.java:272) at org.apache.jdo.tck.util.BatchTestRunner.doRun(BatchTestRunner.java:108) at org.apache.jdo.tck.util.BatchTestRunner.start(BatchTestRunner.java:148) at org.apache.jdo.tck.util.BatchTestRunner.main(BatchTestRunner.java:123) FAILURES!!! Error summary: 001 error: org.datanucleus.exceptions.NucleusUserException: The expression AggregateExpression "MAX((SELECT COUNT(*) FROM applicationidentity0.PERSONS SUB_EMPLOYEES WHERE SUB_EMPLOYEES.DEPARTMENT = SUB.ID))" is not supported in results. 001 error: org.datanucleus.exceptions.NucleusUserException: The expression AggregateExpression "MAX((SELECT COUNT(*) FROM applicationidentity0.PERSONS THIS_EMPLOYEES WHERE THIS_EMPLOYEES.DEPARTMENT = THIS.ID))" is not supported in results. 001 error: org.datanucleus.exceptions.NucleusUserException: The expression ContainerSizeExpression "(SELECT COUNT(*) FROM applicationidentity0.EMPLOYEE_PHONENO_TYPE THIS_PHONENUMBERS WHERE THIS_PHONENUMBERS.EMPID = THIS.PERSONID)" is not supported in results. 001 error: org.datanucleus.exceptions.NucleusUserException: The expression ContainerSizeExpression "(SELECT COUNT(*) FROM applicationidentity0.PERSONS THIS_EMPLOYEES WHERE THIS_EMPLOYEES.DEPARTMENT = THIS.ID)" is not supported in results. 001 error: org.datanucleus.exceptions.NucleusUserException: The expression StringExpression "SUBSTR(THIS.FIRSTNAME,2,3)" is not supported in results. derby-app-JDO-580-junit.txt: ** Tests run: 007, Time: 021 seconds. Failures: 2, Errors: 5 Excluded tests: [org.apache.jdo.tck.enhancement.FieldAccessModified, org.apache.jdo.tck.enhancement.ImplementsPersistenceCapable]