dbeaver / dbeaver/dbeaver

SQL editor results not editable - Unique key: Table Metadata not found.

Open
#37,459 17 comments 2 reactions 1 assignee Claimed by @uslss View on GitHub
x:mssql xf:data xf:metadata xf:sql execution
Dominant language
Java
Stars
51.8k
Forks
4.4k
Avg merge
3d 8h
Merged PRs (30d)
188

Description

### Description

I upgraded from version 24.3.3 to 25.0.0. Also tried early access 25.0.1 and same problem. The following was not happening in 24.3.3. Also tried clean install (removing all folders I could find in my PC related to dbeaver).

1. When querying a simple table "Select * from sample" seems that it is querying the entire results because it takes 10-15 seconds to retrieve results. But on the bottom it says it took 0.323 s (0.146s fetch for example: which is not true. I have it set to retrieve only 200 records.

2. Then I cannot edit any record because I get the orange circle on the top left corner of the results saying "Unique key: Table Metadata not found. Data edit is not possible." My table does have a a unique key.

![Image](https://github.com/user-attachments/assets/ac67970a-b721-42b6-8dae-b6777079948c)

3. I found that if I query the table in brackets or quotes it runs normal, quick results retrieval and green circle indicating records are editable.

![Image](https://github.com/user-attachments/assets/b2729bc3-914e-4c1a-829f-40b229725c15)

4. Other tables in the same database do work fine without brackets but others do not.

![Image](https://github.com/user-attachments/assets/7f420c5a-2c92-422e-bc9b-08cec62c884c)

### DBeaver Version

Community Edition 25.0.1.202503050022

### Operating System

Windows 10

### Database and driver

Microsoft SQL Server 2017 (RTM-CU31) (KB5016884) - 14.0.3456.2 (X64)

Microsoft JDBC Driver for SQL Server
SQLJDBCDriver

### Steps to reproduce

Steps to reproduce are in the description.

### Additional context

I have installed the office extension and works fine in 25.0.0. I tried downgrading to the previous working dbeaver 24.3.3 but found the office extension does not work on this version anymore. Since I use a lot the office extension I am stuck with 25.0.1 but having a hard time remembering to run my queries with tables in brackets.

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.