From 09de892c3b4e14d9b1a765d44e4824ec88e7e0eb Mon Sep 17 00:00:00 2001 From: Adam Greenhall Date: Sat, 12 Sep 2015 01:14:44 -0700 Subject: Fix/Test Limit statements --- sqlparse/filters.py | 2 +- tests/test_format.py | 2 ++ 2 files changed, 3 insertions(+), 1 deletion(-) diff --git a/sqlparse/filters.py b/sqlparse/filters.py index 0d0be5c..2f0e3b9 100644 --- a/sqlparse/filters.py +++ b/sqlparse/filters.py @@ -340,7 +340,7 @@ class AlignedIndentFilter: 'FROM', 'JOIN', 'ON', 'WHERE', 'AND', 'OR', - 'GROUP', 'HAVING', + 'GROUP', 'HAVING', 'LIMIT', 'ORDER', 'UNION', 'VALUES', 'SET', 'BETWEEN', 'EXCEPT', ) diff --git a/tests/test_format.py b/tests/test_format.py index 7bec955..9548dc3 100644 --- a/tests/test_format.py +++ b/tests/test_format.py @@ -119,6 +119,7 @@ class TestFormatReindentAligned(TestCaseBase): where c is true and b between 3 and 4 or d is 'blue' + limit 10 """ self.ndiffAssertEqual( self.formatter(sql), @@ -135,6 +136,7 @@ class TestFormatReindentAligned(TestCaseBase): ' where c is true', ' and b between 3 and 4', " or d is 'blue'", + ' limit 10', ])) def test_case_statement(self): -- cgit v1.2.1