From 45121c389f375b73f03c5ccd775f082e0e8187d2 Mon Sep 17 00:00:00 2001 From: Mike Bayer Date: Thu, 12 Jul 2007 18:34:48 +0000 Subject: [PATCH] added some order_bys to eager relations, which otherwise load with different ordering on PG. we might want to get eager relations on m2m to handle default order-by differently --- test/orm/eager_relations.py | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) diff --git a/test/orm/eager_relations.py b/test/orm/eager_relations.py index 3f3b743612..37b5ecdf7e 100644 --- a/test/orm/eager_relations.py +++ b/test/orm/eager_relations.py @@ -108,7 +108,7 @@ class EagerTest(QueryTest): mapper(Keyword, keywords) mapper(Item, items, properties = dict( - keywords = relation(Keyword, secondary=item_keywords, lazy=False), + keywords = relation(Keyword, secondary=item_keywords, lazy=False, order_by=keywords.c.id), )) q = create_session().query(Item) @@ -314,7 +314,7 @@ class EagerTest(QueryTest): }) mapper(Item, items) mapper(Order, orders, properties = dict( - items = relation(Item, secondary=order_items, lazy=False) + items = relation(Item, secondary=order_items, lazy=False, order_by=items.c.id) )) q = create_session().query(User) @@ -356,7 +356,7 @@ class EagerTest(QueryTest): self.assert_sql_count(testbase.db, go, 1) def test_wide(self): - mapper(Order, orders, properties={'items':relation(Item, secondary=order_items, lazy=False)}) + mapper(Order, orders, properties={'items':relation(Item, secondary=order_items, lazy=False, order_by=items.c.id)}) mapper(Item, items) mapper(User, users, properties = dict( addresses = relation(mapper(Address, addresses), lazy = False), -- 2.47.3