From 775ce5baf7197f18640471f50957651e22f2a897 Mon Sep 17 00:00:00 2001 From: StefanosChaliasos Date: Thu, 27 Aug 2020 13:53:35 -0400 Subject: [PATCH] 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 --- doc/build/changelog/unreleased_13/5539.rst | 10 ++++++++++ lib/sqlalchemy/dialects/mysql/base.py | 2 ++ 2 files changed, 12 insertions(+) create mode 100644 doc/build/changelog/unreleased_13/5539.rst diff --git a/doc/build/changelog/unreleased_13/5539.rst b/doc/build/changelog/unreleased_13/5539.rst new file mode 100644 index 0000000000..ee3fb134c8 --- /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 b3bcb11417..181faf8fee 100644 --- a/lib/sqlalchemy/dialects/mysql/base.py +++ b/lib/sqlalchemy/dialects/mysql/base.py @@ -939,6 +939,7 @@ RESERVED_WORDS = set( "convert", "create", "cross", + "cube", "cume_dist", "current_date", "current_time", @@ -1030,6 +1031,7 @@ RESERVED_WORDS = set( "keys", "kill", "last_value", + "lateral", "leading", "leave", "left", -- 2.39.5