summaryrefslogtreecommitdiff
path: root/tests
diff options
context:
space:
mode:
authorAndi Albrecht <albrecht.andi@gmail.com>2011-02-28 21:12:15 +0100
committerAndi Albrecht <albrecht.andi@gmail.com>2011-02-28 21:12:15 +0100
commit94e33797f7324540e9d64a623fc7c1aa18507318 (patch)
treec02f227ed8c16d0ae0b2cd12a37dc04a3137225d /tests
parenta9559db56679c56c0cf97ba0d5841a52d098a26c (diff)
downloadsqlparse-94e33797f7324540e9d64a623fc7c1aa18507318.tar.gz
Fix formatting issue with extended CASE statements.
Diffstat (limited to 'tests')
-rw-r--r--tests/test_format.py8
1 files changed, 8 insertions, 0 deletions
diff --git a/tests/test_format.py b/tests/test_format.py
index b56ceaf..f9740d5 100644
--- a/tests/test_format.py
+++ b/tests/test_format.py
@@ -186,6 +186,14 @@ class TestFormatReindent(TestCaseBase):
' else 5',
'end']))
+ def test_case2(self):
+ f = lambda sql: sqlparse.format(sql, reindent=True)
+ s = 'case(foo) when bar = 1 then 2 else 3 end'
+ self.ndiffAssertEqual(f(s), '\n'.join(['case(foo)',
+ ' when bar = 1 then 2',
+ ' else 3',
+ 'end']))
+
def test_nested_identifier_list(self): # issue4
f = lambda sql: sqlparse.format(sql, reindent=True)
s = '(foo as bar, bar1, bar2 as bar3, b4 as b5)'