Fix/Test Joins

1 files changed, 26 insertions, 0 deletions

diff --git a/tests/test_format.py b/tests/test_format.py
index 9548dc3..dccc3ec 100644
--- a/tests/test_format.py
+++ b/tests/test_format.py
@@ -139,6 +139,32 @@ class TestFormatReindentAligned(TestCaseBase):
                 ' limit 10',
             ]))
 
+    def test_joins(self):
+        sql = """
+            select * from a
+            join b on a.one = b.one
+            left join c on c.two = a.two and c.three = a.three
+            full outer join d on d.three = a.three
+            cross join e on e.four = a.four
+            join f using (one, two, three)
+            """
+        self.ndiffAssertEqual(
+            self.formatter(sql),
+            '\n'.join([
+                'select *',
+                '  from a',
+                '  join b',
+                '    on a.one = b.one',
+                '  left join c',
+                '    on c.two = a.two',
+                '   and c.three = a.three',
+                '  full outer join d',
+                '    on d.three = a.three',
+                ' cross join e',
+                '    on e.four = a.four',
+                '  join f using (one, two, three)',
+            ]))
+
     def test_case_statement(self):
         sql = """
             select a,