queries, joins and objects

[Florent Guillaume <fg@nuxeo.com>]

Hi,

We've discussed queries and returning objects quite a few times, and  
it's been mentioned several times that when you do a query with a  
JOIN, then you can't get objects returned.

I'd like to stress that the above is true in general, but not always,  
far from it. Here's a common example of a JOIN that will return objects:

   SELECT doc.* FROM Document doc JOIN Relation rel ON ( rel.TargetId  
= doc.ObjectId ) WHERE rel.foo = 123

To me this shows that objects returned from queries, even with JOINs,  
should be treated mostly in the same way as objects returned from  
getChildren (which itself will be implemented as an internal query for  
many vendors).

Florent

-- 
Florent Guillaume, Head of R&D, Nuxeo
Open Source, Java EE based, Enterprise Content Management (ECM)
http://www.nuxeo.com   http://www.nuxeo.org   +33 1 40 33 79 87