Auto-complete suggestions only from selected schema.

[paratus-nam]

Hi,

Using Oracle, it seems that DBCode only includes tables and views of the selected schema in the auto-complete suggestion list.

For example, I have an 'ITEMISED_AMOUNT' in the TAKEON schema, and 'ACCESS_NUMBERS' table in the SUPER schema (with which the connection is established).

With DBCode, selecting SUPER as the schema, I don't get TAKEON's objects in the list:

.... only those of SUPER:

So I am forced to do:

Even though doing the following would be valid syntax (i.e. specifying schema is not required):

Also, the suggestion list after 'ia' does not provide columns from the ITEMISED_AMOUNT table, instead it suggests columns from tables in the SUPER schema:

With Oracle's SQL Developer extension, I get auto-complete for tables and views for all schema's/users:

Coming from Oracle's extension, it makes it hard to want to switch.

Perhaps make the connection selection be able to optionally select the schema, and if not selected provide suggestions from all schemas? You would need to show the schema in the suggestion list next to each object though, for cases where duplicate object names are used in different schemas.
This is particularly an issue with Oracle, which creates a schema for every table owner, unlike e.g. Postgres where users and schemas are independent.

Side issue:

Unlike Oracle's SQL Developer extension, typing a schema in lowercase does not make DBCode select it, hence no suggestions are provided for it.
E.g. the following is listing the SUPER schema's object, not those of the 'takeon' schema:

Case sensitive works:

[mikeburgh]

This has been added to the new language server and released in version 1.17.34.

I am almost ready to switch the new language server over to be the default, but you can try it out before by selecting to enable it from the DBCode settings. It will then be used for the autocomplete and correctly handle schema search paths.