summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorStefanosChaliasos <stefanoshaliassos@gmail.com>2020-08-27 13:53:35 -0400
committerjonathan vanasco <jonathan@2xlp.com>2020-08-30 16:47:29 -0400
commit3acfaf3ad7030b893b2283fc0355bd273927143c (patch)
treecb6f9ab5a7c10b48a77586ea4977f919b45679fa
parentfe772672b4fc00df0b66aca92e2092779a844a2d (diff)
downloadsqlalchemy-3acfaf3ad7030b893b2283fc0355bd273927143c.tar.gz
Add new MySQL reserved words: `cube`, `lateral`.
Closes: #5539 Pull-request: https://github.com/sqlalchemy/sqlalchemy/pull/5539 Pull-request-sha: 8c228be322023041b11691d93dafa1be090f01a0 Change-Id: Ic756472a19563e793cf7e33b24eb1ad5e913dbc0
-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",