I can't reproduce it using disjoint prefetch semantics anymore. I suspect my Eclipse/Tomcat instance was at fault.
-- Thanks, Tad On Tue, Jul 19, 2011 at 8:26 PM, Andrus Adamchik <and...@objectstyle.org> wrote: > It really shouldn't make a difference. > > So if you fetch the data outside Cayenne using MySQL client, which row is > missing if you fetch > > SELECT `t0`.*, `t2`.`employee_id` > FROM `scheduler_position` `t0` > JOIN `scheduler_employee_position` `t1` ON (`t0`.`position_id` = > `t1`.`position_id`) > JOIN `scheduler_employee` `t2` ON (`t1`.`employee_id` = `t2`.`employee_id`) > WHERE (`t2`.`customer_id` = ?) AND (`t2`.`is_enabled` = ?) > > vs. just > > SELECT `t0`.* FROM `scheduler_position` `t0` > > ? > > Thanks, > Andrus > > On Jul 20, 2011, at 12:06 AM, Tad wrote: > >> I solved the issue by setting JOINT_PREFETCH_SEMANTICS on the >> prefetch. Why should this make a difference? >> >> -- >> Thanks! >> Tad >> > >
