From 89676b2452a1b621da373cfa672d801a00888e5c Mon Sep 17 00:00:00 2001 From: Mike Bayer Date: Thu, 17 Jun 2010 10:13:23 -0400 Subject: [PATCH] add a test for query.order_by(None) --- test/orm/test_query.py | 14 ++++++++++++++ 1 file changed, 14 insertions(+) diff --git a/test/orm/test_query.py b/test/orm/test_query.py index d3c5c75f77..63e9a8de0f 100644 --- a/test/orm/test_query.py +++ b/test/orm/test_query.py @@ -222,6 +222,20 @@ class GetTest(QueryTest): 'SELECT users.id AS users_id, users.name AS users_name FROM users WHERE users.id = ?' ) +class OrderByTest(QueryTest, AssertsCompiledSQL): + def test_cancel_order_by(self): + s = create_session() + + q = s.query(User).order_by(User.id) + self.assert_compile(q, + "SELECT users.id AS users_id, users.name AS users_name FROM users ORDER BY users.id", + use_default_dialect=True) + + q = q.order_by(None) + self.assert_compile(q, + "SELECT users.id AS users_id, users.name AS users_name FROM users", + use_default_dialect=True) + class InvalidGenerationsTest(QueryTest): def test_no_limit_offset(self): s = create_session() -- 2.47.2