diff options
-rw-r--r-- | tests/test_smart_completion_multiple_schemata.py | 6 | ||||
-rw-r--r-- | tests/test_smart_completion_public_schema_only.py | 4 |
2 files changed, 5 insertions, 5 deletions
diff --git a/tests/test_smart_completion_multiple_schemata.py b/tests/test_smart_completion_multiple_schemata.py index 868a69ca..f89db20f 100644 --- a/tests/test_smart_completion_multiple_schemata.py +++ b/tests/test_smart_completion_multiple_schemata.py @@ -366,14 +366,14 @@ def test_wildcard_column_expansion_with_table_qualifier(completer, complete_even assert expected == completions -def test_wildcard_column_expansion_with_two_tables_and_parent(completer, complete_event): - sql = 'SELECT * FROM public."select" JOIN custom.users u ON true' +def test_wildcard_column_expansion_with_two_tables(completer, complete_event): + sql = 'SELECT * FROM public."select" JOIN custom.users ON true' pos = len('SELECT *') completions = completer.get_completions( Document(text=sql, cursor_position=pos), complete_event) - col_list = '"select".id, "select"."insert", "select"."ABC", u.id, u.phone_number' + col_list = 'users.id, users.phone_number, "select".id, "select"."insert", "select"."ABC"' expected = [Completion(text=col_list, start_position=-1, display='*', display_meta='columns')] diff --git a/tests/test_smart_completion_public_schema_only.py b/tests/test_smart_completion_public_schema_only.py index bab462c2..68d7cf33 100644 --- a/tests/test_smart_completion_public_schema_only.py +++ b/tests/test_smart_completion_public_schema_only.py @@ -594,14 +594,14 @@ def test_wildcard_column_expansion_with_table_qualifier(completer, complete_even assert expected == completions -def test_wildcard_column_expansion_with_two_tables_and_parent(completer, complete_event): +def test_wildcard_column_expansion_with_two_tables(completer, complete_event): sql = 'SELECT * FROM "select" JOIN users u ON true' pos = len('SELECT *') completions = completer.get_completions( Document(text=sql, cursor_position=pos), complete_event) - col_list = '"select".id, "select"."insert", "select"."ABC", u.id, u.phone_number' + col_list = '"select".id, "select"."insert", "select"."ABC", u.id, u.email, u.first_name, u.last_name' expected = [Completion(text=col_list, start_position=-1, display='*', display_meta='columns')] |