From cc01ab2971981bdcbc3cdbb10b36b202b4655a12 Mon Sep 17 00:00:00 2001 From: Andi Albrecht Date: Wed, 23 Jun 2010 07:37:16 +0200 Subject: Improve statement detection for DECLARE statements outside function/procedure definitions. The parser didn't recognized DECLARE statements outside function/procedure definitions correctly and assumed that a non-separating semicolon follows. --- sqlparse/engine/filter.py | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) (limited to 'sqlparse/engine') diff --git a/sqlparse/engine/filter.py b/sqlparse/engine/filter.py index 08ff21d..0f6eec0 100644 --- a/sqlparse/engine/filter.py +++ b/sqlparse/engine/filter.py @@ -41,17 +41,17 @@ class StatementFilter(TokenFilter): return 0 # ANSI - if ttype is not T.Keyword: + if ttype not in T.Keyword: return 0 unified = value.upper() - if unified == 'DECLARE': + if unified == 'DECLARE' and self._is_create: self._in_declare = True return 1 if unified == 'BEGIN': - if self._in_declare: + if self._in_declare: # FIXME(andi): This makes no sense. return 0 return 0 -- cgit v1.2.1