Remove new test I added and edit the existing ones to cover the same case instead

As suggested by darikg

1 files changed, 10 insertions, 4 deletions

diff --git a/tests/test_smart_completion_public_schema_only.py b/tests/test_smart_completion_public_schema_only.py
index 36ca6203..19641af5 100644
--- a/tests/test_smart_completion_public_schema_only.py
+++ b/tests/test_smart_completion_public_schema_only.py
@@ -344,8 +344,11 @@ def test_suggested_tables_after_on_right_side(completer, complete_event):
         Completion(text='users', start_position=0, display_meta='table alias'),
         Completion(text='orders', start_position=0, display_meta='table alias')])
 
-def test_join_using_suggests_common_columns(completer, complete_event):
-    text = 'SELECT * FROM users INNER JOIN orders USING ('
+@pytest.mark.parametrize('text', [
+    'SELECT * FROM users INNER JOIN orders USING (',
+    'SELECT * FROM users INNER JOIN orders USING(',
+])
+def test_join_using_suggests_common_columns(completer, complete_event, text):
     pos = len(text)
     result = set(completer.get_completions(
         Document(text=text, cursor_position=pos), complete_event))
@@ -354,8 +357,11 @@ def test_join_using_suggests_common_columns(completer, complete_event):
         Completion(text='email', start_position=0, display_meta='column'),
         ])
 
-def test_join_using_suggests_columns_after_first_column(completer, complete_event):
-    text = 'SELECT * FROM users INNER JOIN orders USING (id,'
+@pytest.mark.parametrize('text', [
+    'SELECT * FROM users INNER JOIN orders USING (id,',
+    'SELECT * FROM users INNER JOIN orders USING(id,',
+])
+def test_join_using_suggests_columns_after_first_column(completer, complete_event, text):
     pos = len(text)
     result = set(completer.get_completions(
         Document(text=text, cursor_position=pos), complete_event))