summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authormike bayer <mike_mp@zzzcomputing.com>2020-09-03 16:17:23 +0000
committerGerrit Code Review <gerrit@bbpush.zzzcomputing.com>2020-09-03 16:17:23 +0000
commitfd1129efd402679f5200fcd3273f8b88b66bda9b (patch)
tree81f83f36a18cb7b5dfcd2814cd5876dbcd838cea
parentb050169600019ef249a8b315e7435c752623c900 (diff)
parent3acfaf3ad7030b893b2283fc0355bd273927143c (diff)
downloadsqlalchemy-fd1129efd402679f5200fcd3273f8b88b66bda9b.tar.gz
Merge "Add new MySQL reserved words: `cube`, `lateral`."
-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 1003eeca6..49ff0c14a 100644
--- a/lib/sqlalchemy/dialects/mysql/base.py
+++ b/lib/sqlalchemy/dialects/mysql/base.py
@@ -985,6 +985,7 @@ RESERVED_WORDS = set(
"convert",
"create",
"cross",
+ "cube",
"cume_dist",
"current_date",
"current_time",
@@ -1076,6 +1077,7 @@ RESERVED_WORDS = set(
"keys",
"kill",
"last_value",
+ "lateral",
"leading",
"leave",
"left",