diff options
Diffstat (limited to 'test/orm/test_query.py')
| -rw-r--r-- | test/orm/test_query.py | 11 |
1 files changed, 6 insertions, 5 deletions
diff --git a/test/orm/test_query.py b/test/orm/test_query.py index cc2f046cd..65be1e00a 100644 --- a/test/orm/test_query.py +++ b/test/orm/test_query.py @@ -725,7 +725,7 @@ class SliceTest(QueryTest): assert create_session().query(User).filter(User.id==27).first() is None - @testing.fails_on_everything_except('sqlite') + @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. @@ -738,15 +738,15 @@ class SliceTest(QueryTest): q = sess.query(User) self.assert_sql(testing.db, lambda: q[10:20], [ - ("SELECT users.id AS users_id, users.name AS users_name FROM users LIMIT 10 OFFSET 10", {}) + ("SELECT users.id AS users_id, users.name AS users_name FROM users LIMIT :param_1 OFFSET :param_2", {'param_1':10, 'param_2':10}) ]) self.assert_sql(testing.db, lambda: q[:20], [ - ("SELECT users.id AS users_id, users.name AS users_name FROM users LIMIT 20 OFFSET 0", {}) + ("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}) ]) self.assert_sql(testing.db, lambda: q[5:], [ - ("SELECT users.id AS users_id, users.name AS users_name FROM users LIMIT -1 OFFSET 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}) ]) self.assert_sql(testing.db, lambda: q[2:2], []) @@ -3721,7 +3721,8 @@ class SelfReferentialTest(_base.MappedTest, AssertsCompiledSQL): "nodes_1.id = nodes.parent_id JOIN nodes AS nodes_2 " "ON nodes_2.id = nodes_1.parent_id " "WHERE nodes.data = :data_1 AND nodes_1.data = :data_2 AND " - "nodes_2.data = :data_3) AS anon_1 LIMIT 1", + "nodes_2.data = :data_3) AS anon_1 LIMIT :param_1", + {'param_1':1}, use_default_dialect=True ) |