diff options
Diffstat (limited to 'tests/dialects/test_teradata.py')
| -rw-r--r-- | tests/dialects/test_teradata.py | 28 |
1 files changed, 16 insertions, 12 deletions
diff --git a/tests/dialects/test_teradata.py b/tests/dialects/test_teradata.py index b5c0fe8..14703c4 100644 --- a/tests/dialects/test_teradata.py +++ b/tests/dialects/test_teradata.py @@ -148,18 +148,21 @@ class TestTeradata(Validator): self.validate_all("a MOD b", write={"teradata": "a MOD b", "mysql": "a % b"}) def test_abbrev(self): - self.validate_all("a LT b", write={"teradata": "a < b"}) - self.validate_all("a LE b", write={"teradata": "a <= b"}) - self.validate_all("a GT b", write={"teradata": "a > b"}) - self.validate_all("a GE b", write={"teradata": "a >= b"}) - self.validate_all("a ^= b", write={"teradata": "a <> b"}) - self.validate_all("a NE b", write={"teradata": "a <> b"}) - self.validate_all("a NOT= b", write={"teradata": "a <> b"}) - - self.validate_all( - "SEL a FROM b", - write={"teradata": "SELECT a FROM b"}, - ) + self.validate_identity("a LT b", "a < b") + self.validate_identity("a LE b", "a <= b") + self.validate_identity("a GT b", "a > b") + self.validate_identity("a GE b", "a >= b") + self.validate_identity("a ^= b", "a <> b") + self.validate_identity("a NE b", "a <> b") + self.validate_identity("a NOT= b", "a <> b") + self.validate_identity("a EQ b", "a = b") + self.validate_identity("SEL a FROM b", "SELECT a FROM b") + self.validate_identity( + "SELECT col1, col2 FROM dbc.table1 WHERE col1 EQ 'value1' MINUS SELECT col1, col2 FROM dbc.table2", + "SELECT col1, col2 FROM dbc.table1 WHERE col1 = 'value1' EXCEPT SELECT col1, col2 FROM dbc.table2", + ) + self.validate_identity("UPD a SET b = 1", "UPDATE a SET b = 1") + self.validate_identity("DEL FROM a", "DELETE FROM a") def test_datatype(self): self.validate_all( @@ -187,3 +190,4 @@ class TestTeradata(Validator): "": "STR_TO_DATE('1992-01', '%Y-%d')", }, ) + self.validate_identity("CAST('1992-01' AS FORMAT 'YYYY-DD')") |