| 834 | ) |
| 835 | |
| 836 | def test_limit(self): |
| 837 | t = sql.table("t", sql.column("col1"), sql.column("col2")) |
| 838 | |
| 839 | self.assert_compile( |
| 840 | select(t).limit(10).offset(20), |
| 841 | "SELECT t.col1, t.col2 FROM t LIMIT %s, %s", |
| 842 | {"param_1": 20, "param_2": 10}, |
| 843 | ) |
| 844 | self.assert_compile( |
| 845 | select(t).limit(10), |
| 846 | "SELECT t.col1, t.col2 FROM t LIMIT %s", |
| 847 | {"param_1": 10}, |
| 848 | ) |
| 849 | |
| 850 | self.assert_compile( |
| 851 | select(t).offset(10), |
| 852 | "SELECT t.col1, t.col2 FROM t LIMIT %s, 18446744073709551615", |
| 853 | {"param_1": 10}, |
| 854 | ) |
| 855 | |
| 856 | @testing.combinations( |
| 857 | (String,), |