Ignore AND after BETWEEN when reindenting statements (fixes issue14).

1 files changed, 8 insertions, 0 deletions

diff --git a/tests/test_format.py b/tests/test_format.py
index 88693c0..32e8bef 100644
--- a/tests/test_format.py
+++ b/tests/test_format.py
@@ -104,6 +104,14 @@ class TestFormatReindent(TestCaseBase):
                                                'select *',
                                                'from bar;']))
 
+    def test_keywords_between(self):  # issue 14
+        # don't break AND after BETWEEN
+        f = lambda sql: sqlparse.format(sql, reindent=True)
+        s = 'and foo between 1 and 2 and bar = 3'
+        self.ndiffAssertEqual(f(s), '\n'.join(['',
+                                               'and foo between 1 and 2',
+                                               'and bar = 3']))
+
     def test_parenthesis(self):
         f = lambda sql: sqlparse.format(sql, reindent=True)
         s = 'select count(*) from (select * from foo);'