[MS SQL Server] SQL editor incorrectly reads metadata for tables from all schemas except dbo about dbeaver HOT 18 CLOSED

We recently made some changes and expect that it may solve this issue. Please try Early Access version and let me know if the issue is still actual. You can download this version here https://dbeaver.io/files/ea/

from dbeaver.

from dbeaver.

It's expected behavior in several cases.
If it's a fresh new table, that you just created a moment ago, then you need to refresh schema/tables/... in navigator by selecting the parent node and pressing Refresh (F5).

Also please translate your issue to English.

from dbeaver.

I'm experiencing the same issue. After the last update, a lock icon appeared. I haven't added any new columns or tables. I tried refreshing the table and the parent node, but this didn't resolve the issue.

I also attempted the 'Reset Settings' option, uninstalled the app, and deleted the 'DBeaverData' folder located in 'C:\Users\MYUSER\AppData\Roaming\DBeaverData'. Unfortunately, none of these steps fixed the problem.

from dbeaver.

Please provide clear steps you follow to.

from dbeaver.

@AbdullahNUROGLU
Could you provide some minimal example to reproduce the issue?
Also we appreciate if you could provide an example of SELECT query, on which you reproduce this bug.

from dbeaver.

Also does this table have a primary key?

from dbeaver.

Hi there, I am facing same issue, and I believe this bug was introduced in the latest 24.1.1 release. I rollback to 24.1.0 and it doesn't occur.

Affected Dbeaver Community Release: 24.1.1

Database:
MS SQL Server (PostgreSQL doesn't seem to be affected for me)

Observation:
When executing script (ie: SELECT * FROM {Schema.TableName}), the result grid is not editable. Attempting to edit result in the following error:

The result grid also seem "locked" where there is a "lock" icon at the top left corner (this is new in 24.1.1)

A same transaction screenshot from 24.1.0 below:

Further troubleshooting effort:
I tried to navigate to the target table (by ctrl + left click) and the grid is editable with a "pencil" icon at the top left corner

Another effort is by including the database name in the select statement (ie: SELECT * FROM {DatabaseName.Schema.TableName}) will also allow editing directly from the result grid. Similarly, a
"pencil" icon can be seen at the top left corner.

Hope this clarifies!

from dbeaver.

The top left icon changed, and I am able to see more information.

Issue persists whereby I can't edit directly from query result grid without specifying the Database Name even though I have selected the target Database in the "Active catalog/schema (ctrl+0)" from the top of the screen.

Perhaps some changes on using Fully Qualified Name causing it the Database Name to not be detected correctly?

On side note, UPDATE query script that was generated came with the correct Database Name in v24.1.0 when editing directly via result grid.

from dbeaver.

As @lilbruthal mentioned earlier, this error started to occur after the last update. It's happening in all select queries. However, if I navigate to a table from the 'Database Navigator' and double-click it, the error doesn't occur in the 'Data' tab, and I can edit the data there.

from dbeaver.

@lilbruthal It doesn't reproduce fore me

Can you please include what version of the database do you use, the whole DDL of any table that is afflicted and a screenshot of this page

from dbeaver.

Hello, the bug appeared in the last update (24.1.1)
You can rollback to the former version 24.1.0 to fix this (until they fix the issue in a next update).

Former version can be downloaded here: https://github.com/dbeaver/dbeaver/releases/tag/24.1.0

It fixed it for me.
Have a good one guys

from dbeaver.

Unfortunately, we're uable to reproduce the issue. So, we need your help in investigation. Please answer @Matvey16 's questions #34537 (comment)

from dbeaver.

My DB version is

a DDL example:

`

CREATE TABLE job.JobDescription (
Id bigint IDENTITY(1,1) NOT NULL,
StatusId int NOT NULL,
CreaDate datetime NOT NULL,
CreaUserId int NOT NULL,
ModifDate datetime NOT NULL,
ModifUserId int NOT NULL,
Name nvarchar(100) COLLATE Turkish_CI_AS NOT NULL,
ScheduledTimeCron nvarchar(50) COLLATE Turkish_CI_AS NOT NULL,
PluginName nvarchar(250) COLLATE Turkish_CI_AS NOT NULL,
EmailNotificationActive bit NOT NULL,
EmailNotificationReceivers nvarchar(1000) COLLATE Turkish_CI_AS NOT NULL,
Active bit DEFAULT 0 NOT NULL,
AllowTrigger bit DEFAULT 0 NOT NULL,
Module varchar(100) COLLATE Turkish_CI_AS NULL,
CONSTRAINT PK_JobDescription PRIMARY KEY (Id)
);
`

from dbeaver.

Hello, as said in #34452, adding DB name as prefix solves the issue.
But it's not a permanent solution.

from dbeaver.

@AbdullahNUROGLU Thank you for your info. I've reproduced it.

Note for developers: It is not reproducible if the database and the schema have the same name, also not reproducible specifically in dbo schema

from dbeaver.

The bug was caused by #23203
Fixed

Fix will included in the next release (24.1.2)

from dbeaver.

from dbeaver.