diff options
| author | Daniel Baumann <daniel.baumann@progress-linux.org> | 2024-06-03 20:07:58 +0000 |
|---|---|---|
| committer | Daniel Baumann <daniel.baumann@progress-linux.org> | 2024-06-03 20:07:58 +0000 |
| commit | fc2b129d31cbb474bbebfa0baa8537238f6332ed (patch) | |
| tree | 5c6055c1be787787ae2d13b144f280740e235f79 /tests/dialects/test_redshift.py | |
| parent | Adding upstream version 24.0.0. (diff) | |
| download | sqlglot-fc2b129d31cbb474bbebfa0baa8537238f6332ed.tar.xz sqlglot-fc2b129d31cbb474bbebfa0baa8537238f6332ed.zip | |
Adding upstream version 24.1.0.upstream/24.1.0
Signed-off-by: Daniel Baumann <daniel.baumann@progress-linux.org>
Diffstat (limited to 'tests/dialects/test_redshift.py')
| -rw-r--r-- | tests/dialects/test_redshift.py | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/tests/dialects/test_redshift.py b/tests/dialects/test_redshift.py index 3925e32..ccabe2d 100644 --- a/tests/dialects/test_redshift.py +++ b/tests/dialects/test_redshift.py @@ -7,6 +7,13 @@ class TestRedshift(Validator): def test_redshift(self): self.validate_all( + "SELECT SPLIT_TO_ARRAY('12,345,6789')", + write={ + "postgres": "SELECT STRING_TO_ARRAY('12,345,6789', ',')", + "redshift": "SELECT SPLIT_TO_ARRAY('12,345,6789', ',')", + }, + ) + self.validate_all( "GETDATE()", read={ "duckdb": "CURRENT_TIMESTAMP", @@ -473,6 +480,10 @@ FROM ( self.validate_identity("CREATE TABLE table_backup BACKUP YES AS SELECT * FROM event") self.validate_identity("CREATE TABLE table_backup (i INTEGER, b VARCHAR) BACKUP NO") self.validate_identity("CREATE TABLE table_backup (i INTEGER, b VARCHAR) BACKUP YES") + self.validate_identity( + "select foo, bar from table_1 minus select foo, bar from table_2", + "SELECT foo, bar FROM table_1 EXCEPT SELECT foo, bar FROM table_2", + ) def test_create_table_like(self): self.validate_identity( |