Hi, I can give all the details, but let's start with a simple question.
I have a query, and it is returning the wrong number of rows! Not only is the number wrong compared to what I would expect, but, more importantly, when I paste the *exact sql* (except for substituting a param) printed on the console with "echo on" into the mysql prompt, the results are exactly what I would expect. What, if anything, is known to cause the "printed sql" to give a different result then sqlalchemy itself? I am using: sqlalchemy-0.5.5 mysql python 2.6.2 I am using the orm, and I am doing basically: recs = q.all() print "len(recs)=", len(recs) where q is the query. Sample: username = u'steve' subq = SES.query(Feedback).filter(Feedback.username == username).subquery() valias = aliased(Feedback, subq) q = SES.query(Quote, valias).order_by(desc(Quote.n_votes)).outerjoin (Quote.feedback, valias).limit(2) Without the limit(), I get all the records (>1000), which seem correct. *With* the limit, the number of records is completely kookie (to me!). It seems to be always *less* then what the actual limit is. But again, the sql printed on the console gives me the correct results! Any help would be most appreciated! Thank you. I will happily furnish more details if needed. David --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---
