Make schema-qualified objects sort after non-schema-qualified

1 files changed, 11 insertions, 0 deletions

diff --git a/tests/test_smart_completion_multiple_schemata.py b/tests/test_smart_completion_multiple_schemata.py
index f5a21b41..65f9dc72 100644
--- a/tests/test_smart_completion_multiple_schemata.py
+++ b/tests/test_smart_completion_multiple_schemata.py
@@ -619,6 +619,17 @@ def test_column_alias_search_qualified(completer_aliases_casing,
     cols = ('EntryID', 'EntryTitle')
     assert result[:3] == [column(c, -2) for c in cols]
 
+def test_schema_object_order(completer_all_schemas, complete_event):
+    text = 'SELECT * FROM u'
+    position = len('SELECT * FROM u')
+    result = completer_all_schemas.get_completions(
+        Document(text=text, cursor_position=position),
+        complete_event
+    )
+    assert result[:3] == [
+        table(t, pos=-1) for t in ('users', 'custom."Users"', 'custom.users')
+    ]
+
 def test_all_schema_objects(completer_all_schemas, complete_event):
     text = 'SELECT * FROM '
     position = len('SELECT * FROM ')