From d7201a14ad7a8876079a31f7b7281ddf5ac47b94 Mon Sep 17 00:00:00 2001
From: Shen Longxing <shenlongxing2012@gmail.com>
Date: Fri, 18 Dec 2015 15:34:52 +0800
Subject: fix issue #215

Add token for 'END WHILE'
---
 sqlparse/lexer.py | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(limited to 'sqlparse/lexer.py')

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),
-- 
cgit v1.2.1