diff options
| author | Daniel Baumann <daniel.baumann@progress-linux.org> | 2024-07-13 11:12:05 +0000 |
|---|---|---|
| committer | Daniel Baumann <daniel.baumann@progress-linux.org> | 2024-07-13 11:12:05 +0000 |
| commit | 6d546bfddf465f629d17ee52f78b477eb632fd91 (patch) | |
| tree | 525fd07ca45a5972930252d7f6c9ff5566be9ee7 /tests/dialects/test_teradata.py | |
| parent | Releasing debian version 25.1.0-1. (diff) | |
| download | sqlglot-6d546bfddf465f629d17ee52f78b477eb632fd91.tar.xz sqlglot-6d546bfddf465f629d17ee52f78b477eb632fd91.zip | |
Merging upstream version 25.5.1.
Signed-off-by: Daniel Baumann <daniel.baumann@progress-linux.org>
Diffstat (limited to 'tests/dialects/test_teradata.py')
| -rw-r--r-- | tests/dialects/test_teradata.py | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/tests/dialects/test_teradata.py b/tests/dialects/test_teradata.py index 74d5f88..3945ca3 100644 --- a/tests/dialects/test_teradata.py +++ b/tests/dialects/test_teradata.py @@ -5,6 +5,13 @@ class TestTeradata(Validator): dialect = "teradata" def test_teradata(self): + self.validate_all( + "RANDOM(l, u)", + write={ + "": "(u - l) * RAND() + l", + "teradata": "RANDOM(l, u)", + }, + ) self.validate_identity("TO_NUMBER(expr, fmt, nlsparam)") self.validate_identity("SELECT TOP 10 * FROM tbl") self.validate_identity("SELECT * FROM tbl SAMPLE 5") @@ -212,6 +219,8 @@ class TestTeradata(Validator): ) def test_time(self): + self.validate_identity("CAST(CURRENT_TIMESTAMP(6) AS TIMESTAMP WITH TIME ZONE)") + self.validate_all( "CURRENT_TIMESTAMP", read={ |