summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--doc/build/changelog/unreleased_13/5539.rst10
-rw-r--r--lib/sqlalchemy/dialects/mysql/base.py2
2 files changed, 12 insertions, 0 deletions
diff --git a/doc/build/changelog/unreleased_13/5539.rst b/doc/build/changelog/unreleased_13/5539.rst
new file mode 100644
index 000000000..ee3fb134c
--- /dev/null
+++ b/doc/build/changelog/unreleased_13/5539.rst
@@ -0,0 +1,10 @@
+.. change::
+ :tags: change, mysql
+ :tickets: 5539
+
+ Add new MySQL reserved words: `cube`, `lateral`.
+
+ Reference https://dev.mysql.com/doc/refman/8.0/en/keywords.html :
+
+ * CUBE (R); became reserved in 8.0.1
+ * LATERAL (R); added in 8.0.14 (reserved)
diff --git a/lib/sqlalchemy/dialects/mysql/base.py b/lib/sqlalchemy/dialects/mysql/base.py
index 46529636d..bdd9cf5fa 100644
--- a/lib/sqlalchemy/dialects/mysql/base.py
+++ b/lib/sqlalchemy/dialects/mysql/base.py
@@ -983,6 +983,7 @@ RESERVED_WORDS = set(
"convert",
"create",
"cross",
+ "cube",
"cume_dist",
"current_date",
"current_time",
@@ -1074,6 +1075,7 @@ RESERVED_WORDS = set(
"keys",
"kill",
"last_value",
+ "lateral",
"leading",
"leave",
"left",