Skip to content

SQL Server 2017 : Crash processing ON in INNER JOIN (ColumnMetadata object has no attribute 'get_foreign_keys') #198

Closed
@jefflomax

Description

@jefflomax

Windows 10 1703 15063.0
SQL Server 2017
Version: 0.12.0
Connected as -I (Integrated) to local DB

Query:
select * from Employees INNER JOIN "dbo"."Employees_Identities" ON
Tried to display intellisense and returned:

XXXXX> select * from Employees INNER JOIN "dbo"."Employees_Identities" ON Exception in thread Thread-125:
Traceback (most recent call last):
File "C:\Python\Python36\lib\threading.py", line 916, in _bootstrap_inner
self.run()
File "C:\Python\Python36\lib\threading.py", line 864, in runde
self._target(*self._args, **self._kwargs)
File "C:\Python\Python36\lib\site-packages\prompt_toolkit\interface.py", line 865, in run
completions = list(buffer.completer.get_completions(document, complete_event))
File "C:\Python\Python36\lib\site-packages\mssqlcli\mssqlcompleter.py", line 446, in get_completions
matches.extend(matcher(self, suggestion, word_before_cursor))
File "C:\Python\Python36\lib\site-packages\mssqlcli\mssqlcompleter.py", line 618, in get_join_condition_matches
for fk, lcol in fks:
File "C:\Python\Python36\lib\site-packages\mssqlcli\mssqlcompleter.py", line 617, in
fks = ((fk, lcol.name) for lcol in lcols for fk in lcol.get_foreign_keys)
AttributeError: 'ColumnMetadata' object has no attribute 'get_foreign_keys'

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions