John Siracusa wrote: >> Doesn't putting 'b' in the 'with_objects' set make 'b' records desired >> -- but, critically, optional -- for the query result? In which case, >> while the behaviors regarding foreign keys with full referential >> integrity enabled are appropriate in determining what 'b' records (and >> 'c' records) show up in the result, it should not influence whether an >> 'a' record can or cannot be returned? That's the point of my email; >> this relationship between b and c and its surrounding rules are >> preventing the 'a' records from showing up, when I've asked for 'b' >> records in a "give 'em if you've got 'em" fashion (as opposed to the >> "only give 'em if its got 'em" approach of 'require_objects'). >> >> Does that make more sense? >> > > Yes, thanks. It's supposed to be doing what you expect it to do, but > it's not doing it due to a bug. I'll think about the best way to fix > it. I could of course just remove the optimization, but I have a few > other ideas. Thanks for the report. > >
Thanks for validating my sanity. :) For what it's worth, based on my code read of this stuff, it looks like this foreign key logic optimization wouldn't be invoked at all if I pulled in just table "b" without pulling "c" along with it, meaning I could arguably get "invalid" b records (if any existed) if I simply didn't bother with table c in this case. Given that limitation, it does beg the question of whether the optimization is worth the trouble. But I'm accustomed to database schemas that will not permit garbage, so of course this is my opinion. :) Thanks again. Rose::DB::Object is terrific. - Ethan -- Ethan Rowe End Point Corporation [EMAIL PROTECTED] ------------------------------------------------------------------------- This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ _______________________________________________ Rose-db-object mailing list Rose-db-object@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/rose-db-object
