Re: [sqlalchemy] subqueryload - off-by-one issue?

2016-05-12 Thread Mike Bayer
make sure you are always using order_by if you're doing any kind if limit/offset (including if you call the first() accessor), see the notes at http://docs.sqlalchemy.org/en/rel_1_0/orm/loading_relationships.html#the-importance-of-ordering and

[sqlalchemy] subqueryload - off-by-one issue?

2016-05-12 Thread Marco
Greetings, [SQLAlchemy 1.0.12] We have observed situations in which the first in a list of objects returned by a query with options(subqueryload(Class.relationship)) or with lazy=subquery will have a missing relationship. This is some pseudocode [...] class Parent(Base): id =