- query.order_by().get() silently drops the "ORDER BY" from

the query issued by GET but does not raise an exception.

1 files changed, 6 insertions, 0 deletions

diff --git a/test/orm/query.py b/test/orm/query.py
index 26903edf1..a1d7aacd6 100644
--- a/test/orm/query.py
+++ b/test/orm/query.py
@@ -92,6 +92,9 @@ class GetTest(QueryTest):
         q = s.query(User).join('addresses').filter(Address.user_id==8)
         self.assertRaises(sa_exc.InvalidRequestError, q.get, 7)
         self.assertRaises(sa_exc.InvalidRequestError, s.query(User).filter(User.id==7).get, 19)
+        
+        # order_by()/get() doesn't raise
+        s.query(User).order_by(User.id).get(8)
 
     def test_unique_param_names(self):
         class SomeUser(object):
@@ -223,6 +226,9 @@ class InvalidGenerationsTest(QueryTest):
         q = s.query(User).join('addresses')
         self.assertRaises(sa_exc.InvalidRequestError, q.select_from, users)
         
+        q = s.query(User).order_by(User.id)
+        self.assertRaises(sa_exc.InvalidRequestError, q.select_from, users)
+        
         # this is fine, however
         q.from_self()