summaryrefslogtreecommitdiff
path: root/sqlparse
diff options
context:
space:
mode:
authorShen Longxing <shenlongxing2012@gmail.com>2015-12-18 15:34:52 +0800
committerShen Longxing <shenlongxing2012@gmail.com>2015-12-18 15:34:52 +0800
commitd7201a14ad7a8876079a31f7b7281ddf5ac47b94 (patch)
treefb835d4e3f485067d193bd83073c10234ed014db /sqlparse
parent454f80d80f6fb98da9b9e5e9fcf10bf15207f3d9 (diff)
downloadsqlparse-d7201a14ad7a8876079a31f7b7281ddf5ac47b94.tar.gz
fix issue #215
Add token for 'END WHILE'
Diffstat (limited to 'sqlparse')
-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),