On 6/14/07, John Siracusa <[EMAIL PROTECTED]> wrote:
On 6/13/07 9:29 PM, Cees Hek wrote: > Could you not just join the locations table twice?Actually, in the latest version, I don't think you can do that. But I wonder if I should (re)allow it. Opinions?
Well, joining the same table twice is a valid SQL construct (similar to doing a self join), and it can be useful in certain situations. So I would vote to keep it... Was there a specific reason that it was changed? Or did it just happen as part of refactoring the code? Cheers, Cees ps If you wanted to test to see if it fails with the current version, I have attached the script I used to test it. I tested it with Rose::DB::Object 0.763 and Rose::DB 0.733
rose_double_join_test.pl
Description: Perl program
------------------------------------------------------------------------- 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