cayenne-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Andrus Adamchik <and...@objectstyle.org>
Subject Re: Query prefetch missing rows
Date Wed, 20 Jul 2011 06:26:22 GMT
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
> 


Mime
View raw message