search

kj-9 / sqltools-redshift-driver

redshift driver for vscode sqltools extention
MIT License
4 stars 1 forks source link

Autocomplete assume database name (feature request) #10

Open erickeniuk opened 6 months ago

erickeniuk commented 6 months ago

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.

Screenshot 2024-03-20 at 2 29 32 PM

erickeniuk commented 6 months ago

Similar but different to https://github.com/mtxr/vscode-sqltools/issues/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 commented 6 months ago

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?