Autocomplete assume database name (feature request)

[erickeniuk]

I am attempting to use autocomplete in the SQLTools + Redshift driver, however it appears to be searching for the incorrect schema.

In this case, I am using the trackman schema (referenced by the select * from trackman., however autocomplete is searching the motus schema for tables.

Similarly, I've noticed it grabbing columns from other tables, but that's perhaps a separate issue.

[erickeniuk]

Similar but different to mtxr/vscode-sqltools#984 as it's successfully querying my tables, but is using the incorrect schema to search. Tested the searchTables function and it seems to work just fine to find tables when I specify it manually in Dbeaver, but SQLtools seems to be broken.

[erickeniuk]

My apologies, it looks like I need to specify the database name in order for the search to work properly.

SELECT * FROM ivydw.trackman. correctly shows only the trackman tables. Is there a feature to allow me to avoid typing the database and still retain autocomplete? Can I turn this into a feature request?