summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--test/orm/test_froms.py6
1 files changed, 3 insertions, 3 deletions
diff --git a/test/orm/test_froms.py b/test/orm/test_froms.py
index 707f11426..30579b93f 100644
--- a/test/orm/test_froms.py
+++ b/test/orm/test_froms.py
@@ -697,10 +697,10 @@ class MixedEntitiesTest(QueryTest, AssertsCompiledSQL):
adalias = aliased(Address)
q2 = q.join(adalias, 'addresses').\
- filter(User.name.like('%e%')).\
+ filter(User.name.like('%e%')).order_by(adalias.email_address).\
values(User.name, adalias.email_address)
- eq_(list(q2), [(u'ed', u'ed@wood.com'), (u'ed', u'ed@bettyboop.com'),
- (u'ed', u'ed@lala.com'), (u'fred', u'fred@fred.com')])
+ eq_(list(q2), [(u'ed', u'ed@bettyboop.com'), (u'ed', u'ed@lala.com'),
+ (u'ed', u'ed@wood.com'), (u'fred', u'fred@fred.com')])
q2 = q.values(func.count(User.name))
assert q2.next() == (4,)