diff options
| author | Daniel Baumann <daniel.baumann@progress-linux.org> | 2024-12-23 19:51:10 +0000 |
|---|---|---|
| committer | Daniel Baumann <daniel.baumann@progress-linux.org> | 2024-12-23 19:51:10 +0000 |
| commit | a95fd7b7de8c3492d8267b2007508d579ff50848 (patch) | |
| tree | f17b76df363f98cda7ec9e8327e7c78a4c7f7803 /tests/dialects/test_starrocks.py | |
| parent | Releasing debian version 26.0.0-1. (diff) | |
| download | sqlglot-a95fd7b7de8c3492d8267b2007508d579ff50848.tar.xz sqlglot-a95fd7b7de8c3492d8267b2007508d579ff50848.zip | |
Merging upstream version 26.0.1.
Signed-off-by: Daniel Baumann <daniel.baumann@progress-linux.org>
Diffstat (limited to '')
| -rw-r--r-- | tests/dialects/test_starrocks.py | 5 |
1 files changed, 5 insertions, 0 deletions
diff --git a/tests/dialects/test_starrocks.py b/tests/dialects/test_starrocks.py index bf72485..1b7360d 100644 --- a/tests/dialects/test_starrocks.py +++ b/tests/dialects/test_starrocks.py @@ -18,6 +18,8 @@ class TestStarrocks(Validator): "DISTRIBUTED BY HASH (col1) PROPERTIES ('replication_num'='1')", "PRIMARY KEY (col1) DISTRIBUTED BY HASH (col1)", "DUPLICATE KEY (col1, col2) DISTRIBUTED BY HASH (col1)", + "UNIQUE KEY (col1, col2) PARTITION BY RANGE (col1) (START ('2024-01-01') END ('2024-01-31') EVERY (INTERVAL 1 DAY)) DISTRIBUTED BY HASH (col1)", + "UNIQUE KEY (col1, col2) PARTITION BY RANGE (col1, col2) (START ('1') END ('10') EVERY (1), START ('10') END ('100') EVERY (10)) DISTRIBUTED BY HASH (col1)", ] for properties in ddl_sqls: @@ -31,6 +33,9 @@ class TestStarrocks(Validator): self.validate_identity( "CREATE TABLE foo (col0 DECIMAL(9, 1), col1 DECIMAL32(9, 1), col2 DECIMAL64(18, 10), col3 DECIMAL128(38, 10)) DISTRIBUTED BY HASH (col1) BUCKETS 1" ) + self.validate_identity( + "CREATE TABLE foo (col1 LARGEINT) DISTRIBUTED BY HASH (col1) BUCKETS 1" + ) def test_identity(self): self.validate_identity("SELECT CAST(`a`.`b` AS INT) FROM foo") |