When using an inheritance strategy of "new table" I have problems with queries with instanceof and casting.

For example, I have a base class A, with 2 subclasses B and C.
If I create an A,B and C instances and persist and then do the follwoing query:

Query query = pm.newQuery(A.class, "(this instanceof org.jpox.test.B && (org.jpox.test.B)this == b) || (this instanceof org.jpox.test.C && (org.jpox.test.C)this == c)");
query.declareVariables("org.jpox.test.B b; org.jpox.test.C c");

I get no results returned. (obviously in a real use case after the class cast you would query fields particular to that class)

If each part of the OR is carried out in a separate query, they work on their own.

The SQl produced is as follows:

2006-07-19 17:13:34,700 DEBUG main JPOX.RDBMS.SQL -
SELECT `THIS`.`JDOCLASSX`,`THIS`.`JDOIDX`,`THIS`.`NAMEX` FROM `A` `THIS`
INNER JOIN `A` `THIS_NULL` ON `THIS`.`JDOIDX` = `THIS_NULL`.`JDOIDX`
LEFT OUTER JOIN `B` `THIS_B` ON `THIS_B`.`JDOIDX` = `THIS`.`JDOIDX`
INNER JOIN `B` `UNBOUND_B` ON `UNBOUND_B`.`JDOIDX` = `THIS_B`.`JDOIDX`
LEFT OUTER JOIN `C` `THIS_C` ON `THIS_C`.`JDOIDX` = `THIS`.`JDOIDX`
INNER JOIN `C` `UNBOUND_C` ON `UNBOUND_C`.`JDOIDX` = `THIS_C`.`JDOIDX`
WHERE (`THIS`.`JDOCLASSX` = <'org.jpox.test.A'> OR `THIS`.`JDOCLASSX` = <'org.jpox.test.C'> OR `THIS`.`JDOCLASSX` = <'org.jpox.test.B'>) AND (((`THIS_NULL`.`JDOCLASSX` = <'org.jpox.test.B'>) AND `UNBOUND_B`.`JDOIDX` = `THIS_B`.`JDOIDX`) OR ((`THIS_NULL`.`JDOCLASSX` = <'org.jpox.test.C'>) AND `UNBOUND_C`.`JDOIDX` = `THIS_C`.`JDOIDX`)) -- 5 PS parameters


I don't quite see why:
1. It has to check whether JDOCLASSX is A OR B OR C and then limit it to B OR C
2. maybe issue with OR and INNER JOINS

Test case will be attached.