summaryrefslogtreecommitdiff
path: root/sqlparse/lexer.py
diff options
context:
space:
mode:
authorAndi Albrecht <albrecht.andi@gmail.com>2015-12-22 05:31:44 +0100
committerAndi Albrecht <albrecht.andi@gmail.com>2015-12-22 05:31:44 +0100
commita72f04cd1a3030dd1ac0a34b8fb6dba1b808fe97 (patch)
tree2bd9000dc8eb0b32c8739890bfad3a75bf5e7e49 /sqlparse/lexer.py
parent7dd158b772e15ab7adc5fdd5350c2cef285f651e (diff)
parentd0124b877739501187c76b6587856d86396123a7 (diff)
downloadsqlparse-a72f04cd1a3030dd1ac0a34b8fb6dba1b808fe97.tar.gz
Merge pull request #216 from shenlongxing/master
fix issue #215
Diffstat (limited to 'sqlparse/lexer.py')
-rw-r--r--sqlparse/lexer.py2
1 files changed, 1 insertions, 1 deletions
diff --git a/sqlparse/lexer.py b/sqlparse/lexer.py
index d0f8e3b..7dd013e 100644
--- a/sqlparse/lexer.py
+++ b/sqlparse/lexer.py
@@ -201,7 +201,7 @@ class _Lexer(object):
(r'(?<![\w\])])(\[[^\]]+\])', tokens.Name),
(r'((LEFT\s+|RIGHT\s+|FULL\s+)?(INNER\s+|OUTER\s+|STRAIGHT\s+)?'
r'|(CROSS\s+|NATURAL\s+)?)?JOIN\b', tokens.Keyword),
- (r'END(\s+IF|\s+LOOP)?\b', tokens.Keyword),
+ (r'END(\s+IF|\s+LOOP|\s+WHILE)?\b', tokens.Keyword),
(r'NOT NULL\b', tokens.Keyword),
(r'CREATE(\s+OR\s+REPLACE)?\b', tokens.Keyword.DDL),
(r'DOUBLE\s+PRECISION\b', tokens.Name.Builtin),