- Added small DESC exercise to test_order_by.

1 files changed, 14 insertions, 0 deletions

diff --git a/test/sql/query.py b/test/sql/query.py
index 470d11a29..904303db7 100644
--- a/test/sql/query.py
+++ b/test/sql/query.py
@@ -273,6 +273,11 @@ class QueryTest(PersistTest):
             datetable.drop()
 
     def test_order_by(self):
+        """Exercises ORDER BY clause generation.
+
+        Tests simple, compound, aliased and DESC clauses.
+        """
+        
         users.insert().execute(user_id=1, user_name='c')
         users.insert().execute(user_id=2, user_name='b')
         users.insert().execute(user_id=3, user_name='a')
@@ -308,6 +313,15 @@ class QueryTest(PersistTest):
                     order_by=[users.c.user_id]),
              [(1, 1, 'c'), (2, 2, 'b'), (3, 3, 'a')])
 
+        a_eq(users.select(distinct=True, order_by=[desc(users.c.user_id)]),
+             [(3, 'a'), (2, 'b'), (1, 'c')])
+
+        a_eq(select([users.c.user_id.label('foo')],
+                    distinct=True,
+                    order_by=[users.c.user_id.desc()]),
+             [(3,), (2,), (1,)])
+
+
     def test_column_accessor(self):
         users.insert().execute(user_id=1, user_name='john')
         users.insert().execute(user_id=2, user_name='jack')