Hi Castor Team.

Having oql like this:

SELECT obj.oid FROM myapp.Child obj WHERE myCodigo.key LIKE "123456"

this returns all oids from class child, and not only that with contais
myCodigo.key like 123456.

simple mappings:

<class name="myapp.Parent" identity="oid" />
<class name="myapp.Codigo" depends="myapp.Parent" identity="oid"/>
<class name="myapp.Child" extends="myapp.Parent" identity="oid"/>

the workarround to avoid this problem is:

SELECT obj.oid FROM myapp.Child obj WHERE myCodigo.key LIKE "123456" AND
myCodigo.myParent.oid = oid

ok, this work fine.

The problem is that first OQL don't join tables Parent and Child

Best regards

Clovis Wichoski
[EMAIL PROTECTED]
Supridatta

----------------------------------------------------------- 
If you wish to unsubscribe from this mailing, send mail to
[EMAIL PROTECTED] with a subject of:
        unsubscribe castor-dev

Reply via email to