[sqlalchemy] Re: LIMIT function behavior

2010-01-21 Thread Kent
Unfortunately, in the case I noticed this happen, the join needs to be applied first since the filter's where clause and the order by both depend on the joined tables. Don't think your solution is helpful in that case, but informative nonetheless. I can imagine a DISTINCT helping (I am using

Re: [sqlalchemy] Re: LIMIT function behavior

2010-01-21 Thread Michael Bayer
Kent wrote: Unfortunately, in the case I noticed this happen, the join needs to be applied first since the filter's where clause and the order by both depend on the joined tables. Don't think your solution is helpful in that case, but informative nonetheless. I can imagine a DISTINCT