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 wrote:
> It really shouldn't make a difference.
>
> So if you fetch the data outside Cayenne using MySQL client, whic
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 `sc
I solved the issue by setting JOINT_PREFETCH_SEMANTICS on the
prefetch. Why should this make a difference?
--
Thanks!
Tad
I'm having an issue where prefetching a flattened relationship seems
to skip rows or fetch them from a stale cache. In my test case, I can
verify via mysql that the join table has 5 rows, yet prefetching only
returns 4.
DB layout:
customer has-many positions
customer has-many employees
employees
