Fix parsing and formatting of statements containing EXCEPT keyword.

1 files changed, 15 insertions, 0 deletions

diff --git a/tests/test_regressions.py b/tests/test_regressions.py
index 423f2d6..395c2b6 100644
--- a/tests/test_regressions.py
+++ b/tests/test_regressions.py
@@ -218,3 +218,18 @@ def test_issue90():
                             '    "price" = 1,',
                             '    "description" = NULL'])
     assert formatted == tformatted
+
+
+def test_except_formatting():
+    sql = 'SELECT 1 FROM foo WHERE 2 = 3 EXCEPT SELECT 2 FROM bar WHERE 1 = 2'
+    formatted = sqlparse.format(sql, reindent=True)
+    tformatted = '\n'.join([
+        'SELECT 1',
+        'FROM foo',
+        'WHERE 2 = 3',
+        'EXCEPT',
+        'SELECT 2',
+        'FROM bar',
+        'WHERE 1 = 2'
+    ])
+    assert formatted == tformatted