From 3d9389fcafbdd9300070b37c4fe71e1d03707f9d Mon Sep 17 00:00:00 2001 From: Mike Bayer Date: Wed, 8 Apr 2009 04:14:16 +0000 Subject: [PATCH] test multi-level eager load without the limiting subquery --- test/orm/eager_relations.py | 14 ++++++++++++++ 1 file changed, 14 insertions(+) diff --git a/test/orm/eager_relations.py b/test/orm/eager_relations.py index 1876eca258..87c2442cc4 100644 --- a/test/orm/eager_relations.py +++ b/test/orm/eager_relations.py @@ -892,6 +892,20 @@ class SelfReferentialEagerTest(_base.MappedTest): n1.children[1].append(Node(data='n123')) sess.add(n1) sess.flush() + sess.expunge_all() + def go(): + d = sess.query(Node).filter_by(data='n1').all()[0] + assert Node(data='n1', children=[ + Node(data='n11'), + Node(data='n12', children=[ + Node(data='n121'), + Node(data='n122'), + Node(data='n123') + ]), + Node(data='n13') + ]) == d + self.assert_sql_count(testing.db, go, 1) + sess.expunge_all() def go(): d = sess.query(Node).filter_by(data='n1').first() -- 2.47.3