summaryrefslogtreecommitdiffstats
path: root/tests/dialects/test_presto.py
diff options
context:
space:
mode:
authorDaniel Baumann <daniel.baumann@progress-linux.org>2024-09-03 07:37:50 +0000
committerDaniel Baumann <daniel.baumann@progress-linux.org>2024-09-03 07:37:50 +0000
commit8b1fb8d8676e832d02b99bb8e69f6897dd10c0f6 (patch)
treed31426ac93b330e755f0b500704e236b9a62dc15 /tests/dialects/test_presto.py
parentReleasing debian version 25.16.1-1. (diff)
downloadsqlglot-8b1fb8d8676e832d02b99bb8e69f6897dd10c0f6.tar.xz
sqlglot-8b1fb8d8676e832d02b99bb8e69f6897dd10c0f6.zip
Merging upstream version 25.18.0.
Signed-off-by: Daniel Baumann <daniel.baumann@progress-linux.org>
Diffstat (limited to '')
-rw-r--r--tests/dialects/test_presto.py10
1 files changed, 1 insertions, 9 deletions
diff --git a/tests/dialects/test_presto.py b/tests/dialects/test_presto.py
index 950c89f..c8e616e 100644
--- a/tests/dialects/test_presto.py
+++ b/tests/dialects/test_presto.py
@@ -634,6 +634,7 @@ class TestPresto(Validator):
},
)
+ self.validate_identity("SELECT a FROM t GROUP BY a, ROLLUP (b), ROLLUP (c), ROLLUP (d)")
self.validate_identity("SELECT a FROM test TABLESAMPLE BERNOULLI (50)")
self.validate_identity("SELECT a FROM test TABLESAMPLE SYSTEM (75)")
self.validate_identity("string_agg(x, ',')", "ARRAY_JOIN(ARRAY_AGG(x), ',')")
@@ -715,9 +716,6 @@ class TestPresto(Validator):
)
self.validate_all(
"SELECT ROW(1, 2)",
- read={
- "spark": "SELECT STRUCT(1, 2)",
- },
write={
"presto": "SELECT ROW(1, 2)",
"spark": "SELECT STRUCT(1, 2)",
@@ -836,12 +834,6 @@ class TestPresto(Validator):
},
)
self.validate_all(
- "SELECT a FROM t GROUP BY a, ROLLUP(b), ROLLUP(c), ROLLUP(d)",
- write={
- "presto": "SELECT a FROM t GROUP BY a, ROLLUP (b, c, d)",
- },
- )
- self.validate_all(
'SELECT a."b" FROM "foo"',
write={
"duckdb": 'SELECT a."b" FROM "foo"',