The JPOX unit testcase "testQueryUsesContainsValueTwiceOnFieldUsingWorkaroundInverse" results in the following with MySQL 4.1

Error executing JDOQL query
"SELECT 'org.jpox.samples.fitness.Gym' AS JPOXMETADATA,`THIS`.`GYM_ID`,`THIS`.`LOCATION`,`THIS`.`NAME`,`THIS`.`STRING_KEY`,`THIS`.`STRING_VA
LUE`
FROM `GYM` `THIS`
WHERE EXISTS
(SELECT 1 FROM `WARDROBE` `THIS_WARDROBESINVERSE_W1`
LEFT OUTER JOIN `WARDROBE` `THIS_WARDROBESINVERSE_W1_MODEL` ON `THIS_WARDROBESINVERSE_W1`.`WARDROBE_ID` = `THIS_WARDROBESINVERSE_W1_MODEL`.`WARDROBE_ID` 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`
LEFT OUTER JOIN `WARDROBE` `THIS_WARDROBESINVERSE_W2_MODEL` ON `THIS_WARDROBESINVERSE_W2`.`WARDROBE_ID` = `THIS_WARDROBESINVERSE_W2_MODEL`.`WARDROBE_ID` 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`.`MODEL` = ? OR `THIS_WARDROBESINVERSE_W2_MODEL`.`MODEL` = ?"
Unknown table 'THIS_WARDROBESINVERSE_W1_MODEL' in where clause

MySQL's subselect support in 4.1 doesn't seem complete to me based on this.