Fix(mysql): delete redundant keywords (#3646)

toms · georgesittas · web-flow · commit 88c49651ecc9 · 2024-06-13T12:36:16.000+03:00
* Feat(bigquery,presto): improve transpilation of INTERVAL (plural to singular)

* Feat(bigquery,presto): improve transpilation of INTERVAL (plural to singular)

* Feat(bigquery,presto): improve transpilation of INTERVAL (plural to singular)

* fix(doris) , mysql group_concat function different doris , it is not support separator keyword

* fix(doris) , mysql group_concat function different doris , it is not support separator keyword

* fix(doris) , mysql group_concat function different doris , it is not support separator keyword

* fix(doris) , mysql group_concat function different doris , it is not support separator keyword

* fix(doris) , mysql group_concat function different doris , it is not support separator keyword

* Update tests/dialects/test_doris.py

* Update sqlglot/dialects/doris.py

* Update sqlglot/dialects/doris.py

* Update sqlglot/dialects/doris.py

* fix(presto to hive) , TIMESTAMP_TRUNC function to trunc function

* fix(presto to hive) , TIMESTAMP_TRUNC function to trunc function

* fix(presto keyword) DIV

* fix (mysql) delete redundant keywords

* github

---------

Co-authored-by: Jo &lt;46752250+georgesittas@users.noreply.github.com&gt;
diff --git a/sqlglot/dialects/mysql.py b/sqlglot/dialects/mysql.py
@@ -1093,29 +1093,6 @@ class Generator(generator.Generator):
             "xor",
             "year_month",
             "zerofill",
-            "cume_dist",
-            "dense_rank",
-            "empty",
-            "except",
-            "first_value",
-            "grouping",
-            "groups",
-            "intersect",
-            "json_table",
-            "lag",
-            "last_value",
-            "lateral",
-            "lead",
-            "nth_value",
-            "ntile",
-            "of",
-            "over",
-            "percent_rank",
-            "rank",
-            "recursive",
-            "row_number",
-            "system",
-            "window",
         }
 
         def array_sql(self, expression: exp.Array) -> str:
