Ran tests with a clean workspace and got same results. So something is
broken...
Thanks,
Sahoo
Sanjeeb Kumar Sahoo wrote:
> 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