From 8ffe95af292e0930b7126aae1905a97f7ebdfb24 Mon Sep 17 00:00:00 2001
From: Gavin Wahl <gwahl@fusionbox.com>
Date: Thu, 7 Aug 2014 14:12:46 -0600
Subject: Handle modulo operator without spaces

`x %3` should be interpreted as a modulo operation, not a parameter
marker.

Co-authored-by: Rocky Meza <rmeza@fusionbox.com>
---
 sqlparse/lexer.py | 3 ++-
 1 file changed, 2 insertions(+), 1 deletion(-)

(limited to 'sqlparse')

diff --git a/sqlparse/lexer.py b/sqlparse/lexer.py
index 0d915ac..6bd414f 100644
--- a/sqlparse/lexer.py
+++ b/sqlparse/lexer.py
@@ -180,7 +180,8 @@ class Lexer(object):
             (r'\$([^\W\d]\w*)?\$', tokens.Name.Builtin),
             (r'\?{1}', tokens.Name.Placeholder),
             (r'%\(\w+\)s', tokens.Name.Placeholder),
-            (r'[$:?%]\w+', tokens.Name.Placeholder),
+            (r'%s', tokens.Name.Placeholder),
+            (r'[$:?]\w+', tokens.Name.Placeholder),
             # FIXME(andi): VALUES shouldn't be listed here
             # see https://github.com/andialbrecht/sqlparse/pull/64
             (r'VALUES', tokens.Keyword),
-- 
cgit v1.2.1