From adc789cdc6ea66d73925e2a819ea70e60ec282e4 Mon Sep 17 00:00:00 2001
From: Sean Bright <sean@seanbright.com>
Date: Fri, 15 Mar 2024 13:36:12 -0400
Subject: [PATCH] mysql: Add new reserved words from MySQL 8.3.

Adds the following new keywords from MySQL 8.3:

* `intersect`
* `parallel`
* `qualify`

Sourced from https://dev.mysql.com/doc/refman/8.3/en/keywords.html

Fixes: #11166
---
 lib/sqlalchemy/dialects/mysql/reserved_words.py | 4 ++++
 1 file changed, 4 insertions(+)

diff --git a/lib/sqlalchemy/dialects/mysql/reserved_words.py b/lib/sqlalchemy/dialects/mysql/reserved_words.py
index 009988a608..04764c17e7 100644
--- a/lib/sqlalchemy/dialects/mysql/reserved_words.py
+++ b/lib/sqlalchemy/dialects/mysql/reserved_words.py
@@ -282,6 +282,7 @@ RESERVED_WORDS_MARIADB = {
     }
 )
 
+# https://dev.mysql.com/doc/refman/8.3/en/keywords.html
 # https://dev.mysql.com/doc/refman/8.0/en/keywords.html
 # https://dev.mysql.com/doc/refman/5.7/en/keywords.html
 # https://dev.mysql.com/doc/refman/5.6/en/keywords.html
@@ -403,6 +404,7 @@ RESERVED_WORDS_MYSQL = {
     "int4",
     "int8",
     "integer",
+    "intersect",
     "interval",
     "into",
     "io_after_gtids",
@@ -468,6 +470,7 @@ RESERVED_WORDS_MYSQL = {
     "outfile",
     "over",
     "parse_gcol_expr",
+    "parallel",
     "partition",
     "percent_rank",
     "persist",
@@ -476,6 +479,7 @@ RESERVED_WORDS_MYSQL = {
     "primary",
     "procedure",
     "purge",
+    "qualify",
     "range",
     "rank",
     "read",
-- 
2.47.2