diff options
| author | Mike Bayer <mike_mp@zzzcomputing.com> | 2015-01-18 20:57:26 -0500 |
|---|---|---|
| committer | Mike Bayer <mike_mp@zzzcomputing.com> | 2015-01-18 20:57:26 -0500 |
| commit | f5d4f2685f30817af493c32d2cf0ac77715bdb46 (patch) | |
| tree | 93a0ca7cdb6a715f1f3c2162f5677b138493930e /test/orm/test_query.py | |
| parent | f49c367ef712d080e630ba722f96903922d7de7b (diff) | |
| download | sqlalchemy-f5d4f2685f30817af493c32d2cf0ac77715bdb46.tar.gz | |
- rework assertsql system, fixes #3293
Diffstat (limited to 'test/orm/test_query.py')
| -rw-r--r-- | test/orm/test_query.py | 9 |
1 files changed, 4 insertions, 5 deletions
diff --git a/test/orm/test_query.py b/test/orm/test_query.py index 354bbe5b1..4c6e16bf2 100644 --- a/test/orm/test_query.py +++ b/test/orm/test_query.py @@ -1484,7 +1484,6 @@ class SliceTest(QueryTest): assert create_session().query(User).filter(User.id == 27). \ first() is None - @testing.only_on('sqlite', 'testing execution but db-specific syntax') def test_limit_offset_applies(self): """Test that the expected LIMIT/OFFSET is applied for slices. @@ -1510,15 +1509,15 @@ class SliceTest(QueryTest): testing.db, lambda: q[:20], [ ( "SELECT users.id AS users_id, users.name " - "AS users_name FROM users LIMIT :param_1 OFFSET :param_2", - {'param_1': 20, 'param_2': 0})]) + "AS users_name FROM users LIMIT :param_1", + {'param_1': 20})]) self.assert_sql( testing.db, lambda: q[5:], [ ( "SELECT users.id AS users_id, users.name " - "AS users_name FROM users LIMIT :param_1 OFFSET :param_2", - {'param_1': -1, 'param_2': 5})]) + "AS users_name FROM users LIMIT -1 OFFSET :param_1", + {'param_1': 5})]) self.assert_sql(testing.db, lambda: q[2:2], []) |