summaryrefslogtreecommitdiff
path: root/tests
diff options
context:
space:
mode:
Diffstat (limited to 'tests')
-rw-r--r--tests/test_format.py15
1 files changed, 15 insertions, 0 deletions
diff --git a/tests/test_format.py b/tests/test_format.py
index b77b7a1..b789b17 100644
--- a/tests/test_format.py
+++ b/tests/test_format.py
@@ -326,3 +326,18 @@ def test_truncate_strings_invalid_option():
def test_truncate_strings_doesnt_truncate_identifiers(sql):
formatted = sqlparse.format(sql, truncate_strings=2)
assert formatted == sql
+
+
+def test_having_produces_newline():
+ sql = (
+ 'select * from foo, bar where bar.id = foo.bar_id'
+ ' having sum(bar.value) > 100')
+ formatted = sqlparse.format(sql, reindent=True)
+ expected = [
+ 'select *',
+ 'from foo,',
+ ' bar',
+ 'where bar.id = foo.bar_id',
+ 'having sum(bar.value) > 100'
+ ]
+ assert formatted == '\n'.join(expected)