Hi, When using the generative limit() offset() or order_by calls on mapper query, the sql generated looks weird.
I get something like select table1.* table2.* from (select table1a.id from table1a limit 20 offset 0 order by table1.col) as table_row, table1 join table2 (on...) .... Notice how the limit and offset is in that subselect ? Is this by design. The query results are not what I would expect either because the subselect doesn't join to the main table (table1). Hope what I"m describing makes sense. Huy --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com 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 -~----------~----~----~----~------~----~------~--~---