Datagrip does not properly show suggestions with sysbase databases
Hello, i have some sybase database whom default schema is not dbo. All tables i need are inside dbo, so i uncheck the default schema and check only dbo in the connection property.
The problem is that in the console the tables are not properly suggested and they are marked red if I manually write them, but queries gets executed without any error.
In order to fix this i have to change the File Resolve Mode from Playground to Script and place “use [dbname]” at the top of the file (I don't need to execute it), in this way the autocompletion works fine and I don't get any error.
Are there some settings i'm missing? I don't think this is the intended behaviour
Please sign in to leave a comment.
The console mode script/playground should not affect how the tables are resolved unless they are within the scope. Please provide examples of tables not being resolved and the database / schema you're connecting to in the query console. We also need to know your current IDE version and the database you have configured as data source.
We'll have a look.
In playground mode i have always to indicate the dbo schema even if it's the only one selected.
In Script mode it's the same except if “use dbname” is added at the top of the console file, in that case the dbo. prefix is not needed
The version i'm running is the latest stable one
DataGrip 2023.3.4
Build #DB-233.14015.137, built on January 31, 2024
Runtime version: 17.0.9+7-b1087.11 amd64
With the driver to connect to sybase DB
DBMS: sql server (ver. 12.50)
Case sensitivity: plain=exact, delimited=exact
Driver: jTDS Type 4 JDBC Driver for MS SQL Server and Sybase (ver. 1.3.1, JDBC3.0)
Effective version: Sybase ASE (ver. 12.5.4)
Thanks for the update.
We're seeing if we can reproduce this issue. In the meantime, can you switch to DataGrip 2024.1 and see if this issue is present?
For now, as a workaround, you may set the Qualify Objects With option to Always in File | Settings | Editor | General | Code Completion. Doing so, a table will always be accompanied with a schema once selected in code completion.