| testNotContainsValuesInMapFields | 0.66 |
| testNotContainsValuesInMapFieldsInverse | 0.10 |
| testNotContainsKeysInMapFields | 0.33 |
| testNotContainsKeysInMapFieldsInverse | 0.26 |
| testNotContainsEntryInMapFields | 0.24 |
| testNotContainsEntryInMapFieldsInverse | 0.26 |
| testGetInMapFields | 0.22 |
| testGetInOrderingInMapFields | 0.21 |
expected:<2> but was:<3>
|
| testNegateContains | 0.38 |
| testContainsInListFields | 0.04 |
| testContainsInSetFields | 0.08 |
| testContainsInMapFields | 0.23 |
| testContainsInParameterCollection | 0.35 |
| testContainsInParameterArray | 0.24 |
| testContainsResultVariable | 0.22 |
| testContainsResultVariableNestedContains | 0.21 |
| testContainsInParameterCollectionOfPCleanInstances | 0.20 |
| testContainsInImplicitParameterCollection | 0.17 |
| testContainsInImplicitParameterCollectionOfPCleanInstances | 0.19 |
| testMapGetMethod | 0.28 |
| testMapGetAsLiteralWithKeyAsExpression | 0.54 |
Cannot perform operation "getMethod" on MapKeyLiteral "('2 doors')" and StringExpression "THIS.MODEL"
|
| testCollectionSize | 0.14 |
| testCollectionIsEmpty | 0.11 |
| testMapSize | 0.15 |
| testMapIsEmpty | 0.16 |
| testQueryUsesContainsOnceOnOneUnboundVariable | 0.18 |
| testQueryUsesContainsOnceAndEqualsOnOneUnboundVariable | 0.15 |
| testQueryUsesContainsValueOnceOnOneUnboundVariable | 0.23 |
| testQueryUsesContainsValueAndEqualsOnceOnOneUnboundVariable | 0.18 |
| testQueryUsesContainsValueOnceOnOneUnboundVariableInverse | 0.27 |
| testQueryContainsKeyOnCharacter | 0.06 |
| testQueryUsesContainsKeyOnceOnOneUnboundVariableInverse | 0.23 |
| testQueryUsesContainsKeyOnceOnOneUnboundVariable | 0.21 |
| testQueryUsesContainsOnceOnOneUnboundVariableUsingParameters | 0.17 |
| testQueryUsesContainsValueOnceOnOneUnboundVariableUsingParameters | 0.16 |
| testQueryUsesContainsValueOnceOnOneUnboundVariableUsingParametersInverse | 0.19 |
| testQueryUsesContainsKeyOnceOnOneUnboundVariableUsingParametersInverse | 0.19 |
| testQueryUsesContainsKeyOnceOnOneUnboundVariableUsingParameters | 0.20 |
| testQueryUsesContainsOnceOnOneUnboundVariableImplicitVariables | 0.18 |
| testQueryUsesContainsValueOnceOnOneUnboundVariableImplicitVariables | 0.17 |
| testQueryUsesContainsValueOnceOnOneUnboundVariableImplicitVariablesInverse | 0.19 |
| testQueryUsesContainsKeyOnceOnOneUnboundVariableImplicitVariablesInverse | 0.25 |
| testQueryUsesContainsKeyOnceOnOneUnboundVariableImplicitVariables | 0.16 |
| testQueryUsesContainsOnceOnOneUnboundVariableInverse | 0.16 |
| testQueryUsesContainsOnceOnOneUnboundVariableInverseImplicitVariables | 0.18 |
| testQueryUsesContainsOnceOnOneUnboundVariableInverseUsingParameter | 0.19 |
| testQueryUsesContainsOnceOnOneUnboundVariableMtoN | 0.08 |
| testQueryUsesContainsTwiceOnOneUnboundVariable | 0.13 |
| testQueryUsesContainsValueTwiceOnOneUnboundVariable | 0.16 |
| testQueryUsesContainsValueTwiceOnOneUnboundVariableInverse | 0.18 |
| testQueryUsesContainsKeyTwiceOnOneUnboundVariableInverse | 0.16 |
| testQueryUsesContainsKeyTwiceOnOneUnboundVariable | 0.15 |
| testQueryUsesContainsTwiceOnOneUnboundVariableInverse | 0.16 |
| testQueryUsesContainsTwiceOnOneUnboundVariableMtoN | 0.06 |
| testQueryUsesContainsTwiceOnFieldUsingWorkaround | 0.12 |
[JPOX-042007] Error executing JDOQL query "SELECT 'org.jpox.samples.models.company.Manager' AS JPOXMETADATA,THIS_1.AGE,THIS_1.EMAIL_ADDRESS,THIS_1.FIRSTNAME,THIS_1.GLOBALNUM,THIS_1.LASTNAME,THIS_1.PERSONNUM,THIS_2.MANAGER_GLOBALNUM_OID,THIS_2.MANAGER_PERSONNUM_OID,THIS_2.SALARY,THIS_2.SALARY_CURRENCY,THIS_2.SERIAL_NO FROM MANAGER THIS INNER JOIN PERSON THIS_1 ON THIS_1.GLOBALNUM = THIS.GLOBALNUM AND THIS_1.PERSONNUM = THIS.PERSONNUM INNER JOIN EMPLOYEE THIS_2 ON THIS_2.GLOBALNUM = THIS.GLOBALNUM AND THIS_2.PERSONNUM = THIS.PERSONNUM WHERE EXISTS (SELECT 1 FROM EMPLOYEE UNBOUND_EMP1 INNER JOIN PERSON UNBOUND_EMP1_1 ON UNBOUND_EMP1_1.GLOBALNUM = UNBOUND_EMP1.GLOBALNUM AND UNBOUND_EMP1_1.PERSONNUM = UNBOUND_EMP1.PERSONNUM , MANAGER_SUBORDINATES THIS_SUBORDINATES_EMP1 WHERE THIS_SUBORDINATES_EMP1.GLOBALNUM_OID = THIS.GLOBALNUM AND THIS_SUBORDINATES_EMP1.PERSONNUM_OID = THIS.PERSONNUM AND UNBOUND_EMP1.GLOBALNUM = THIS_SUBORDINATES_EMP1.GLOBALNUM_EID AND UNBOUND_EMP1.PERSONNUM = THIS_SUBORDINATES_EMP1.PERSONNUM_EID) AND EXISTS (SELECT 1 FROM EMPLOYEE UNBOUND_EMP2 INNER JOIN PERSON UNBOUND_EMP2_1 ON UNBOUND_EMP2_1.GLOBALNUM = UNBOUND_EMP2.GLOBALNUM AND UNBOUND_EMP2_1.PERSONNUM = UNBOUND_EMP2.PERSONNUM , MANAGER_SUBORDINATES THIS_SUBORDINATES_EMP2 WHERE THIS_SUBORDINATES_EMP2.GLOBALNUM_OID = THIS.GLOBALNUM AND THIS_SUBORDINATES_EMP2.PERSONNUM_OID = THIS.PERSONNUM AND UNBOUND_EMP2.GLOBALNUM = THIS_SUBORDINATES_EMP2.GLOBALNUM_EID AND UNBOUND_EMP2.PERSONNUM = THIS_SUBORDINATES_EMP2.PERSONNUM_EID) AND UNBOUND_EMP1_1.LASTNAME = ? OR UNBOUND_EMP2_1.LASTNAME = ?" : Column not found: UNBOUND_EMP1_1.LASTNAME in statement [SELECT 'org.jpox.samples.models.company.Manager' AS JPOXMETADATA,THIS_1.AGE,THIS_1.EMAIL_ADDRESS,THIS_1.FIRSTNAME,THIS_1.GLOBALNUM,THIS_1.LASTNAME,THIS_1.PERSONNUM,THIS_2.MANAGER_GLOBALNUM_OID,THIS_2.MANAGER_PERSONNUM_OID,THIS_2.SALARY,THIS_2.SALARY_CURRENCY,THIS_2.SERIAL_NO FROM MANAGER THIS INNER JOIN PERSON THIS_1 ON THIS_1.GLOBALNUM = THIS.GLOBALNUM AND THIS_1.PERSONNUM = THIS.PERSONNUM INNER JOIN EMPLOYEE THIS_2 ON THIS_2.GLOBALNUM = THIS.GLOBALNUM AND THIS_2.PERSONNUM = THIS.PERSONNUM WHERE EXISTS (SELECT 1 FROM EMPLOYEE UNBOUND_EMP1 INNER JOIN PERSON UNBOUND_EMP1_1 ON UNBOUND_EMP1_1.GLOBALNUM = UNBOUND_EMP1.GLOBALNUM AND UNBOUND_EMP1_1.PERSONNUM = UNBOUND_EMP1.PERSONNUM , MANAGER_SUBORDINATES THIS_SUBORDINATES_EMP1 WHERE THIS_SUBORDINATES_EMP1.GLOBALNUM_OID = THIS.GLOBALNUM AND THIS_SUBORDINATES_EMP1.PERSONNUM_OID = THIS.PERSONNUM AND UNBOUND_EMP1.GLOBALNUM = THIS_SUBORDINATES_EMP1.GLOBALNUM_EID AND UNBOUND_EMP1.PERSONNUM = THIS_SUBORDINATES_EMP1.PERSONNUM_EID) AND EXISTS (SELECT 1 FROM EMPLOYEE UNBOUND_EMP2 INNER JOIN PERSON UNBOUND_EMP2_1 ON UNBOUND_EMP2_1.GLOBALNUM = UNBOUND_EMP2.GLOBALNUM AND UNBOUND_EMP2_1.PERSONNUM = UNBOUND_EMP2.PERSONNUM , MANAGER_SUBORDINATES THIS_SUBORDINATES_EMP2 WHERE THIS_SUBORDINATES_EMP2.GLOBALNUM_OID = THIS.GLOBALNUM AND THIS_SUBORDINATES_EMP2.PERSONNUM_OID = THIS.PERSONNUM AND UNBOUND_EMP2.GLOBALNUM = THIS_SUBORDINATES_EMP2.GLOBALNUM_EID AND UNBOUND_EMP2.PERSONNUM = THIS_SUBORDINATES_EMP2.PERSONNUM_EID) AND UNBOUND_EMP1_1.LASTNAME = ? OR UNBOUND_EMP2_1.LASTNAME = ?].
|
| testQueryUsesContainsValueTwiceOnFieldUsingWorkaround | 0.15 |
[JPOX-042007] Error executing JDOQL query "SELECT 'org.jpox.samples.models.fitness.Gym' AS JPOXMETADATA,THIS.GYM_ID,THIS.LOCATION,THIS."NAME",THIS.STRING_KEY,THIS.STRING_VALUE FROM GYM THIS WHERE EXISTS (SELECT 1 FROM GYM_WARDROBES THIS_WARDROBES_W1 , WARDROBE UNBOUND_W1 WHERE THIS_WARDROBES_W1.GYM_ID_OID = THIS.GYM_ID AND THIS_WARDROBES_W1.GYM_ID_OID = THIS.GYM_ID AND UNBOUND_W1.WARDROBE_ID = THIS_WARDROBES_W1.WARDROBE_ID_VID) AND EXISTS (SELECT 1 FROM GYM_WARDROBES THIS_WARDROBES_W2 , WARDROBE UNBOUND_W2 WHERE THIS_WARDROBES_W2.GYM_ID_OID = THIS.GYM_ID AND THIS_WARDROBES_W2.GYM_ID_OID = THIS.GYM_ID AND UNBOUND_W2.WARDROBE_ID = THIS_WARDROBES_W2.WARDROBE_ID_VID) AND UNBOUND_W1.MODEL = ? OR UNBOUND_W2.MODEL = ?" : Column not found: UNBOUND_W1.MODEL in statement [SELECT 'org.jpox.samples.models.fitness.Gym' AS JPOXMETADATA,THIS.GYM_ID,THIS.LOCATION,THIS."NAME",THIS.STRING_KEY,THIS.STRING_VALUE FROM GYM THIS WHERE EXISTS (SELECT 1 FROM GYM_WARDROBES THIS_WARDROBES_W1 , WARDROBE UNBOUND_W1 WHERE THIS_WARDROBES_W1.GYM_ID_OID = THIS.GYM_ID AND THIS_WARDROBES_W1.GYM_ID_OID = THIS.GYM_ID AND UNBOUND_W1.WARDROBE_ID = THIS_WARDROBES_W1.WARDROBE_ID_VID) AND EXISTS (SELECT 1 FROM GYM_WARDROBES THIS_WARDROBES_W2 , WARDROBE UNBOUND_W2 WHERE THIS_WARDROBES_W2.GYM_ID_OID = THIS.GYM_ID AND THIS_WARDROBES_W2.GYM_ID_OID = THIS.GYM_ID AND UNBOUND_W2.WARDROBE_ID = THIS_WARDROBES_W2.WARDROBE_ID_VID) AND UNBOUND_W1.MODEL = ? OR UNBOUND_W2.MODEL = ?].
|
| testQueryUsesContainsValueTwiceOnFieldUsingWorkaroundInverse | 0.16 |
[JPOX-042007] Error executing JDOQL query "SELECT 'org.jpox.samples.models.fitness.Gym' AS JPOXMETADATA,THIS.GYM_ID,THIS.LOCATION,THIS."NAME",THIS.STRING_KEY,THIS.STRING_VALUE FROM GYM THIS WHERE EXISTS (SELECT 1 FROM WARDROBE THIS_WARDROBESINVERSE_W1 WHERE THIS_WARDROBESINVERSE_W1.GYM_GYM_ID_OID = THIS.GYM_ID AND THIS_WARDROBESINVERSE_W1.GYM_GYM_ID_OID = THIS.GYM_ID) AND EXISTS (SELECT 1 FROM WARDROBE THIS_WARDROBESINVERSE_W2 WHERE THIS_WARDROBESINVERSE_W2.GYM_GYM_ID_OID = THIS.GYM_ID AND THIS_WARDROBESINVERSE_W2.GYM_GYM_ID_OID = THIS.GYM_ID) AND THIS_WARDROBESINVERSE_W1.MODEL = ? OR THIS_WARDROBESINVERSE_W2.MODEL = ?" : Column not found: THIS_WARDROBESINVERSE_W1.MODEL in statement [SELECT 'org.jpox.samples.models.fitness.Gym' AS JPOXMETADATA,THIS.GYM_ID,THIS.LOCATION,THIS."NAME",THIS.STRING_KEY,THIS.STRING_VALUE FROM GYM THIS WHERE EXISTS (SELECT 1 FROM WARDROBE THIS_WARDROBESINVERSE_W1 WHERE THIS_WARDROBESINVERSE_W1.GYM_GYM_ID_OID = THIS.GYM_ID AND THIS_WARDROBESINVERSE_W1.GYM_GYM_ID_OID = THIS.GYM_ID) AND EXISTS (SELECT 1 FROM WARDROBE THIS_WARDROBESINVERSE_W2 WHERE THIS_WARDROBESINVERSE_W2.GYM_GYM_ID_OID = THIS.GYM_ID AND THIS_WARDROBESINVERSE_W2.GYM_GYM_ID_OID = THIS.GYM_ID) AND THIS_WARDROBESINVERSE_W1.MODEL = ? OR THIS_WARDROBESINVERSE_W2.MODEL = ?].
|
| testQueryUsesContainsKeyTwiceOnFieldUsingWorkaroundInverse | 0.14 |
[JPOX-042007] Error executing JDOQL query "SELECT 'org.jpox.samples.models.fitness.Gym' AS JPOXMETADATA,THIS.GYM_ID,THIS.LOCATION,THIS."NAME",THIS.STRING_KEY,THIS.STRING_VALUE FROM GYM THIS WHERE EXISTS (SELECT 1 FROM WARDROBE THIS_WARDROBESINVERSE2_W1 INNER JOIN WARDROBE UNBOUND_W1 ON THIS_WARDROBESINVERSE2_W1.WARDROBE_ID = UNBOUND_W1.WARDROBE_ID WHERE THIS_WARDROBESINVERSE2_W1.WARDROBES_INVERSE2_GYM_ID_OID = THIS.GYM_ID AND THIS_WARDROBESINVERSE2_W1.WARDROBES_INVERSE2_GYM_ID_OID = THIS.GYM_ID) AND EXISTS (SELECT 1 FROM WARDROBE THIS_WARDROBESINVERSE2_W2 INNER JOIN WARDROBE UNBOUND_W2 ON THIS_WARDROBESINVERSE2_W2.WARDROBE_ID = UNBOUND_W2.WARDROBE_ID WHERE THIS_WARDROBESINVERSE2_W2.WARDROBES_INVERSE2_GYM_ID_OID = THIS.GYM_ID AND THIS_WARDROBESINVERSE2_W2.WARDROBES_INVERSE2_GYM_ID_OID = THIS.GYM_ID) AND UNBOUND_W1.MODEL = ? OR UNBOUND_W2.MODEL = ?" : Column not found: UNBOUND_W1.MODEL in statement [SELECT 'org.jpox.samples.models.fitness.Gym' AS JPOXMETADATA,THIS.GYM_ID,THIS.LOCATION,THIS."NAME",THIS.STRING_KEY,THIS.STRING_VALUE FROM GYM THIS WHERE EXISTS (SELECT 1 FROM WARDROBE THIS_WARDROBESINVERSE2_W1 INNER JOIN WARDROBE UNBOUND_W1 ON THIS_WARDROBESINVERSE2_W1.WARDROBE_ID = UNBOUND_W1.WARDROBE_ID WHERE THIS_WARDROBESINVERSE2_W1.WARDROBES_INVERSE2_GYM_ID_OID = THIS.GYM_ID AND THIS_WARDROBESINVERSE2_W1.WARDROBES_INVERSE2_GYM_ID_OID = THIS.GYM_ID) AND EXISTS (SELECT 1 FROM WARDROBE THIS_WARDROBESINVERSE2_W2 INNER JOIN WARDROBE UNBOUND_W2 ON THIS_WARDROBESINVERSE2_W2.WARDROBE_ID = UNBOUND_W2.WARDROBE_ID WHERE THIS_WARDROBESINVERSE2_W2.WARDROBES_INVERSE2_GYM_ID_OID = THIS.GYM_ID AND THIS_WARDROBESINVERSE2_W2.WARDROBES_INVERSE2_GYM_ID_OID = THIS.GYM_ID) AND UNBOUND_W1.MODEL = ? OR UNBOUND_W2.MODEL = ?].
|
| testQueryUsesContainsKeyTwiceOnFieldUsingWorkaround | 0.13 |
[JPOX-042007] Error executing JDOQL query "SELECT 'org.jpox.samples.models.fitness.Gym' AS JPOXMETADATA,THIS.GYM_ID,THIS.LOCATION,THIS."NAME",THIS.STRING_KEY,THIS.STRING_VALUE FROM GYM THIS WHERE EXISTS (SELECT 1 FROM GYM_WARDROBES2 THIS_WARDROBES2_W1 , WARDROBE UNBOUND_W1 WHERE THIS_WARDROBES2_W1.GYM_ID_OID = THIS.GYM_ID AND THIS_WARDROBES2_W1.GYM_ID_OID = THIS.GYM_ID AND UNBOUND_W1.WARDROBE_ID = THIS_WARDROBES2_W1.WARDROBE_ID_KID) AND EXISTS (SELECT 1 FROM GYM_WARDROBES2 THIS_WARDROBES2_W2 , WARDROBE UNBOUND_W2 WHERE THIS_WARDROBES2_W2.GYM_ID_OID = THIS.GYM_ID AND THIS_WARDROBES2_W2.GYM_ID_OID = THIS.GYM_ID AND UNBOUND_W2.WARDROBE_ID = THIS_WARDROBES2_W2.WARDROBE_ID_KID) AND UNBOUND_W1.MODEL = ? OR UNBOUND_W2.MODEL = ?" : Column not found: UNBOUND_W1.MODEL in statement [SELECT 'org.jpox.samples.models.fitness.Gym' AS JPOXMETADATA,THIS.GYM_ID,THIS.LOCATION,THIS."NAME",THIS.STRING_KEY,THIS.STRING_VALUE FROM GYM THIS WHERE EXISTS (SELECT 1 FROM GYM_WARDROBES2 THIS_WARDROBES2_W1 , WARDROBE UNBOUND_W1 WHERE THIS_WARDROBES2_W1.GYM_ID_OID = THIS.GYM_ID AND THIS_WARDROBES2_W1.GYM_ID_OID = THIS.GYM_ID AND UNBOUND_W1.WARDROBE_ID = THIS_WARDROBES2_W1.WARDROBE_ID_KID) AND EXISTS (SELECT 1 FROM GYM_WARDROBES2 THIS_WARDROBES2_W2 , WARDROBE UNBOUND_W2 WHERE THIS_WARDROBES2_W2.GYM_ID_OID = THIS.GYM_ID AND THIS_WARDROBES2_W2.GYM_ID_OID = THIS.GYM_ID AND UNBOUND_W2.WARDROBE_ID = THIS_WARDROBES2_W2.WARDROBE_ID_KID) AND UNBOUND_W1.MODEL = ? OR UNBOUND_W2.MODEL = ?].
|
| testQueryUsesContainsTwiceOnFieldWithNamespace | 0.22 |
| testQueryUsesContainsValueTwiceOnFieldWithNamespace | 0.16 |
| testQueryUsesContainsValueTwiceOnFieldWithNamespaceInverse | 0.18 |
| testQueryUsesContainsKeyTwiceOnFieldWithNamespaceInverse | 0.17 |
| testQueryUsesContainsKeyTwiceOnFieldWithNamespace | 0.16 |
| testQueryUsesContainsTwiceOnFieldWithNamespaceInverse | 0.19 |
| testQueryUsesContainsTwiceOnFieldWithNamespaceMtoN | 0.09 |
| testQueryUsesContainsTwiceOnFieldWithNamespace2MtoN | 0.06 |
| testQueryUsesContainsTwiceOnFieldNoNamespace | 0.12 |
[JPOX-042007] Error executing JDOQL query "SELECT 'org.jpox.samples.models.company.Manager' AS JPOXMETADATA,THIS_1.AGE,THIS_1.EMAIL_ADDRESS,THIS_1.FIRSTNAME,THIS_1.GLOBALNUM,THIS_1.LASTNAME,THIS_1.PERSONNUM,THIS_2.MANAGER_GLOBALNUM_OID,THIS_2.MANAGER_PERSONNUM_OID,THIS_2.SALARY,THIS_2.SALARY_CURRENCY,THIS_2.SERIAL_NO FROM MANAGER THIS INNER JOIN PERSON THIS_1 ON THIS_1.GLOBALNUM = THIS.GLOBALNUM AND THIS_1.PERSONNUM = THIS.PERSONNUM INNER JOIN EMPLOYEE THIS_2 ON THIS_2.GLOBALNUM = THIS.GLOBALNUM AND THIS_2.PERSONNUM = THIS.PERSONNUM WHERE EXISTS (SELECT 1 FROM EMPLOYEE UNBOUND_EMP1 INNER JOIN PERSON UNBOUND_EMP1_1 ON UNBOUND_EMP1_1.GLOBALNUM = UNBOUND_EMP1.GLOBALNUM AND UNBOUND_EMP1_1.PERSONNUM = UNBOUND_EMP1.PERSONNUM , MANAGER_SUBORDINATES THIS_SUBORDINATES_EMP1 WHERE THIS_SUBORDINATES_EMP1.GLOBALNUM_OID = THIS.GLOBALNUM AND THIS_SUBORDINATES_EMP1.PERSONNUM_OID = THIS.PERSONNUM AND UNBOUND_EMP1.GLOBALNUM = THIS_SUBORDINATES_EMP1.GLOBALNUM_EID AND UNBOUND_EMP1.PERSONNUM = THIS_SUBORDINATES_EMP1.PERSONNUM_EID AND UNBOUND_EMP1_1.LASTNAME = ?) AND EXISTS (SELECT 1 FROM EMPLOYEE UNBOUND_EMP2 INNER JOIN PERSON UNBOUND_EMP2_1 ON UNBOUND_EMP2_1.GLOBALNUM = UNBOUND_EMP2.GLOBALNUM AND UNBOUND_EMP2_1.PERSONNUM = UNBOUND_EMP2.PERSONNUM , MANAGER_SUBORDINATES THIS_SUBORDINATES_EMP2 WHERE THIS_SUBORDINATES_EMP2.GLOBALNUM_OID = THIS.GLOBALNUM AND THIS_SUBORDINATES_EMP2.PERSONNUM_OID = THIS.PERSONNUM AND UNBOUND_EMP2.GLOBALNUM = THIS_SUBORDINATES_EMP2.GLOBALNUM_EID AND UNBOUND_EMP2.PERSONNUM = THIS_SUBORDINATES_EMP2.PERSONNUM_EID) AND UNBOUND_EMP2_1.LASTNAME = ?" : Column not found: UNBOUND_EMP2_1.LASTNAME in statement [SELECT 'org.jpox.samples.models.company.Manager' AS JPOXMETADATA,THIS_1.AGE,THIS_1.EMAIL_ADDRESS,THIS_1.FIRSTNAME,THIS_1.GLOBALNUM,THIS_1.LASTNAME,THIS_1.PERSONNUM,THIS_2.MANAGER_GLOBALNUM_OID,THIS_2.MANAGER_PERSONNUM_OID,THIS_2.SALARY,THIS_2.SALARY_CURRENCY,THIS_2.SERIAL_NO FROM MANAGER THIS INNER JOIN PERSON THIS_1 ON THIS_1.GLOBALNUM = THIS.GLOBALNUM AND THIS_1.PERSONNUM = THIS.PERSONNUM INNER JOIN EMPLOYEE THIS_2 ON THIS_2.GLOBALNUM = THIS.GLOBALNUM AND THIS_2.PERSONNUM = THIS.PERSONNUM WHERE EXISTS (SELECT 1 FROM EMPLOYEE UNBOUND_EMP1 INNER JOIN PERSON UNBOUND_EMP1_1 ON UNBOUND_EMP1_1.GLOBALNUM = UNBOUND_EMP1.GLOBALNUM AND UNBOUND_EMP1_1.PERSONNUM = UNBOUND_EMP1.PERSONNUM , MANAGER_SUBORDINATES THIS_SUBORDINATES_EMP1 WHERE THIS_SUBORDINATES_EMP1.GLOBALNUM_OID = THIS.GLOBALNUM AND THIS_SUBORDINATES_EMP1.PERSONNUM_OID = THIS.PERSONNUM AND UNBOUND_EMP1.GLOBALNUM = THIS_SUBORDINATES_EMP1.GLOBALNUM_EID AND UNBOUND_EMP1.PERSONNUM = THIS_SUBORDINATES_EMP1.PERSONNUM_EID AND UNBOUND_EMP1_1.LASTNAME = ?) AND EXISTS (SELECT 1 FROM EMPLOYEE UNBOUND_EMP2 INNER JOIN PERSON UNBOUND_EMP2_1 ON UNBOUND_EMP2_1.GLOBALNUM = UNBOUND_EMP2.GLOBALNUM AND UNBOUND_EMP2_1.PERSONNUM = UNBOUND_EMP2.PERSONNUM , MANAGER_SUBORDINATES THIS_SUBORDINATES_EMP2 WHERE THIS_SUBORDINATES_EMP2.GLOBALNUM_OID = THIS.GLOBALNUM AND THIS_SUBORDINATES_EMP2.PERSONNUM_OID = THIS.PERSONNUM AND UNBOUND_EMP2.GLOBALNUM = THIS_SUBORDINATES_EMP2.GLOBALNUM_EID AND UNBOUND_EMP2.PERSONNUM = THIS_SUBORDINATES_EMP2.PERSONNUM_EID) AND UNBOUND_EMP2_1.LASTNAME = ?].
|
| testIsEmptyOredWithContains | 0.03 |
| testContainsResultVariableNestedContains2 | 0.10 |
| testQueryUsesContainsValueRangeVariableAlreadyInQuery | 0.43 |
| testQueryUsesContainsKeyRangeVariableAlreadyInQuery | 0.28 |
| testQueryUsesContainsEntryRangeVariableAlreadyInQuery | 0.38 |
| testQueryUsesContainsSetRangeVariableAlreadyInQuery | 0.26 |
| testQueryUsesContainsListRangeVariableAlreadyInQuery | 0.28 |