summaryrefslogtreecommitdiffstats
path: root/tests/test_transpile.py
diff options
context:
space:
mode:
authorDaniel Baumann <daniel.baumann@progress-linux.org>2024-01-31 05:44:37 +0000
committerDaniel Baumann <daniel.baumann@progress-linux.org>2024-01-31 05:44:37 +0000
commit5f8be2e0852f3c925fb873a48946caee3050899f (patch)
tree1f31666277e226f47180321c08be7ebbedc2780e /tests/test_transpile.py
parentAdding upstream version 20.9.0. (diff)
downloadsqlglot-5f8be2e0852f3c925fb873a48946caee3050899f.tar.xz
sqlglot-5f8be2e0852f3c925fb873a48946caee3050899f.zip
Adding upstream version 20.11.0.upstream/20.11.0
Signed-off-by: Daniel Baumann <daniel.baumann@progress-linux.org>
Diffstat (limited to 'tests/test_transpile.py')
-rw-r--r--tests/test_transpile.py40
1 files changed, 40 insertions, 0 deletions
diff --git a/tests/test_transpile.py b/tests/test_transpile.py
index 51805d9..fdbf2e0 100644
--- a/tests/test_transpile.py
+++ b/tests/test_transpile.py
@@ -5,6 +5,7 @@ from unittest import mock
from sqlglot import parse_one, transpile
from sqlglot.errors import ErrorLevel, ParseError, UnsupportedError
from sqlglot.helper import logger as helper_logger
+from sqlglot.parser import logger as parser_logger
from tests.helpers import (
assert_logger_contains,
load_sql_fixture_pairs,
@@ -736,6 +737,45 @@ FROM base""",
with self.subTest(sql):
self.assertEqual(transpile(sql)[0], sql.strip())
+ def test_command_identity(self):
+ for sql in (
+ "ALTER AGGREGATE bla(foo) OWNER TO CURRENT_USER",
+ "ALTER DOMAIN foo VALIDATE CONSTRAINT bla",
+ "ALTER ROLE CURRENT_USER WITH REPLICATION",
+ "ALTER RULE foo ON bla RENAME TO baz",
+ "ALTER SEQUENCE IF EXISTS baz RESTART WITH boo",
+ "ALTER SESSION SET STATEMENT_TIMEOUT_IN_SECONDS=3",
+ "ALTER TABLE integers DROP PRIMARY KEY",
+ "ALTER TABLE s_ut ADD CONSTRAINT s_ut_uq UNIQUE hajo",
+ "ALTER TABLE table1 MODIFY COLUMN name1 SET TAG foo='bar'",
+ "ALTER TABLE table1 RENAME COLUMN c1 AS c2",
+ "ALTER TABLE table1 RENAME COLUMN c1 TO c2, c2 TO c3",
+ "ALTER TABLE table1 RENAME COLUMN c1 c2",
+ "ALTER TYPE electronic_mail RENAME TO email",
+ "ALTER VIEW foo ALTER COLUMN bla SET DEFAULT 'NOT SET'",
+ "ALTER schema doo",
+ "ANALYZE a.y",
+ "CALL catalog.system.iceberg_procedure_name(named_arg_1 => 'arg_1', named_arg_2 => 'arg_2')",
+ "COMMENT ON ACCESS METHOD gin IS 'GIN index access method'",
+ "CREATE OR REPLACE STAGE",
+ "CREATE SET GLOBAL TEMPORARY TABLE a, NO BEFORE JOURNAL, NO AFTER JOURNAL, MINIMUM DATABLOCKSIZE, BLOCKCOMPRESSION=NEVER (a INT)",
+ "EXECUTE statement",
+ "EXPLAIN SELECT * FROM x",
+ "GRANT INSERT ON foo TO bla",
+ "LOAD foo",
+ "OPTIMIZE TABLE y",
+ "PREPARE statement",
+ "SET -v",
+ "SET @user OFF",
+ "SHOW TABLES",
+ "TRUNCATE TABLE x",
+ "VACUUM FREEZE my_table",
+ ):
+ with self.subTest(sql):
+ with self.assertLogs(parser_logger) as cm:
+ self.assertEqual(transpile(sql)[0], sql)
+ assert f"'{sql[:100]}' contains unsupported syntax" in cm.output[0]
+
def test_normalize_name(self):
self.assertEqual(
transpile("cardinality(x)", read="presto", write="presto", normalize_functions="lower")[