- Fixed bug in Query involving order_by() in conjunction with

multiple aliases of the same class (will add tests in
[ticket:1218])
- Added a new extension sqlalchemy.ext.serializer.  Provides
Serializer/Deserializer "classes" which mirror Pickle/Unpickle,
as well as dumps() and loads().  This serializer implements
an "external object" pickler which keeps key context-sensitive
objects, including engines, sessions, metadata, Tables/Columns,
and mappers, outside of the pickle stream, and can later
restore the pickle using any engine/metadata/session provider.
This is used not for pickling regular object instances, which are
pickleable without any special logic, but for pickling expression
objects and full Query objects, such that all mapper/engine/session
dependencies can be restored at unpickle time.

1 files changed, 2 insertions, 2 deletions

diff --git a/test/orm/query.py b/test/orm/query.py
index e50cacc86..b63c12f09 100644
--- a/test/orm/query.py
+++ b/test/orm/query.py
@@ -1028,7 +1028,7 @@ class JoinTest(QueryTest):
         q = sess.query(User)
         AdAlias = aliased(Address)
         q = q.add_entity(AdAlias).select_from(outerjoin(User, AdAlias))
-        l = q.order_by(User.id, Address.id).all()
+        l = q.order_by(User.id, AdAlias.id).all()
         self.assertEquals(l, expected)
 
         sess.clear()
@@ -1705,7 +1705,7 @@ class MixedEntitiesTest(QueryTest):
         q = sess.query(User)
         adalias = addresses.alias('adalias')
         q = q.add_entity(Address, alias=adalias).select_from(users.outerjoin(adalias))
-        l = q.order_by(User.id, Address.id).all()
+        l = q.order_by(User.id, adalias.c.id).all()
         assert l == expected
 
         sess.clear()