From d74ea26ec3a7f189ec00f6b949fd95082ba5b204 Mon Sep 17 00:00:00 2001
From: Andi Albrecht <albrecht.andi@gmail.com>
Date: Tue, 28 Jan 2014 15:16:12 +0100
Subject: Fix parsing and formatting of statements containing EXCEPT keyword.

---
 tests/test_regressions.py | 15 +++++++++++++++
 1 file changed, 15 insertions(+)

(limited to 'tests')

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
-- 
cgit v1.2.1