My entity-persistence-test and entity-persistence modules are
up-to-date. I have made some changes to my local workspace, but I don't
see how that can cause the following failure:
Testcase: testAnyAndAll took 0.016 sec
Caused an ERROR
Internal Exception: org.apache.derby.client.am.SqlException: Subquery is
only allowed to return a single column.Error Code: -1
Call:SELECT t0.F_NAME, t0.L_NAME, t0.ID_NUMBER, t0.DTYPE, t0.CUBE_ID,
t0.CUBE_CODE, t0.DEPT_NAME, t0.DEPT_ROLE, t0.DEPT_LOCATION FROM
CMP3_SCIENTIST t0 WHERE EXISTS (SELECT t1.F_NAME, t1.L_NAME,
t1.ID_NUMBER, t1.DTYPE, t1.CUBE_ID, t1.CUBE_CODE, t1.DEPT_NAME,
t1.DEPT_ROLE, t1.DEPT_LOCATION FROM CMP3_SCIENTIST t1 WHERE (((t0.F_NAME
= t1.F_NAME) AND (t0.L_NAME = t1.L_NAME)) AND (t0.ID_NUMBER =
t1.ID_NUMBER)))
Query:ReportQuery(oracle.toplink.essentials.testing.models.cmp3.advanced.compositepk.Scientist)
at
oracle.toplink.essentials.exceptions.DatabaseException.sqlException(DatabaseException.java:303)
at
oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:551)
at
oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:437)
at
oracle.toplink.essentials.threetier.ServerSession.executeCall(ServerSession.java:465)
Tests are run against JavaDB. Is this a known failure?
Thanks,
Sahoo