diff options
Diffstat (limited to 'tests/dialects/test_clickhouse.py')
| -rw-r--r-- | tests/dialects/test_clickhouse.py | 16 |
1 files changed, 15 insertions, 1 deletions
diff --git a/tests/dialects/test_clickhouse.py b/tests/dialects/test_clickhouse.py index 5a4461e..19b3ce3 100644 --- a/tests/dialects/test_clickhouse.py +++ b/tests/dialects/test_clickhouse.py @@ -251,7 +251,7 @@ class TestClickhouse(Validator): }, write={ "clickhouse": "SELECT CAST('2020-01-01' AS Nullable(DateTime)) + INTERVAL '500' MICROSECOND", - "duckdb": "SELECT CAST('2020-01-01' AS DATETIME) + INTERVAL '500' MICROSECOND", + "duckdb": "SELECT CAST('2020-01-01' AS TIMESTAMP) + INTERVAL '500' MICROSECOND", "postgres": "SELECT CAST('2020-01-01' AS TIMESTAMP) + INTERVAL '500 MICROSECOND'", }, ) @@ -1245,3 +1245,17 @@ LIFETIME(MIN 0 MAX 0)""", scopes = traverse_scope(parse_one(sql, dialect=self.dialect)) self.assertEqual(len(scopes), 1) self.assertEqual(set(scopes[0].sources), {"t"}) + + def test_window_functions(self): + self.validate_identity( + "SELECT row_number(column1) OVER (PARTITION BY column2 ORDER BY column3) FROM table" + ) + self.validate_identity( + "SELECT row_number() OVER (PARTITION BY column2 ORDER BY column3) FROM table" + ) + + def test_functions(self): + self.validate_identity("SELECT TRANSFORM(foo, [1, 2], ['first', 'second']) FROM table") + self.validate_identity( + "SELECT TRANSFORM(foo, [1, 2], ['first', 'second'], 'default') FROM table" + ) |