summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--sqlparse/filters.py2
-rw-r--r--tests/test_format.py2
2 files changed, 3 insertions, 1 deletions
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):