From 403de6fc648ac4e012b60b49161c3f5f36dc944a Mon Sep 17 00:00:00 2001
From: Simon Heisterkamp <she@delegate.dk>
Date: Sun, 19 Sep 2021 11:56:46 +0200
Subject: Fixed bad parsing of create table statements that use lower case

---
 sqlparse/engine/grouping.py | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

(limited to 'sqlparse')

diff --git a/sqlparse/engine/grouping.py b/sqlparse/engine/grouping.py
index d250e18..86d8fc6 100644
--- a/sqlparse/engine/grouping.py
+++ b/sqlparse/engine/grouping.py
@@ -343,9 +343,9 @@ def group_functions(tlist):
     has_table = False
     has_as = False
     for tmp_token in tlist.tokens:
-        if tmp_token.value == 'CREATE':
+        if tmp_token.value.upper() == 'CREATE':
             has_create = True
-        if tmp_token.value == 'TABLE':
+        if tmp_token.value.upper() == 'TABLE':
             has_table = True
         if tmp_token.value == 'AS':
             has_as = True
-- 
cgit v1.2.1