Hi, > When you're talking about MySQL, adding a WHERE clause on the foreign > key is almost always identical to performing an inner join. I don't see > this behavior as incorrect at all. A left outer join is never the > default join type, so it *should* have to be explicitly specified.
Unfortunately the symfony documentation is misleading there: "There is no difference in the result returned by a doSelect() call and a doSelectJoinXXX() method; they both return the same array of objects (of class Article in the example)." [1] I brought this issue up some time ago [2], but unfortunately some of my comments there weren't taken into account. Maybe someone would like to correct the documentation, create a patch and open another ticket. Martin [1]http://www.symfony-project.com/book/1_0/18-Performance#Minimizing%20the%20Number%20of%20Queries%20with%20Joins [2]http://trac.symfony-project.com/trac/ticket/1640 --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "symfony users" group. To post to this group, send email to symfony-users@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/symfony-users?hl=en -~----------~----~----~----~------~----~------~--~---
