DBeaver
Replies: 4 comments 5 replies
-
|
@xzl-5039 please translate your ticket into English. |
Beta Was this translation helpful? Give feedback.
This comment has been hidden.
This comment has been hidden.
-
|
I see the same behavior — field comments only appear after opening the
table structure first.
…On Thu, Apr 2, 2026, 9:46 PM 西瓜酱 ***@***.***> wrote:
*xzl-5039* left a comment (dbeaver/dbeaver#40650)
<#40650 (comment)>
*Oracle database does not display field comments after executing a query*
When I use Oracle database, the field descriptions do not display in the
SQL editor when executing a query statement; it is necessary to open the
table structure first and then execute the SQL to display the field
descriptions.
image.png (view on web)
<https://github.com/user-attachments/assets/99645462-6ccd-4f22-8ddb-ff546ec00821>
*In fact, there are comments in the table structure.*
image.png (view on web)
<https://github.com/user-attachments/assets/f0fd92e6-343d-4dc0-8df5-08fc4279703b>
When I open the table structure as shown in the image above and then
execute the SQL again, the comments are displayed again, so it is necessary
to check the table structure first and then execute the query to display
the comments.
image.png (view on web)
<https://github.com/user-attachments/assets/ed8b74de-4988-4339-b97d-19f05f366e6d>
—
Reply to this email directly, view it on GitHub
<#40650?email_source=notifications&email_token=CAFV24SZ62J3333YP7YGEK34T4QZFA5CNFSNUABFM5UWIORPF5TWS5BNNB2WEL2JONZXKZKDN5WW2ZLOOQXTIMJYGE2TANJSGEZ2M4TFMFZW63VKON2WE43DOJUWEZLEUVSXMZLOOSWGM33PORSXEX3DNRUWG2Y#issuecomment-4181505213>,
or unsubscribe
<https://github.com/notifications/unsubscribe-auth/CAFV24WACUEYYL4GC2LOGPT4T4QZFAVCNFSM6AAAAACXHKNKPKVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHM2DCOBRGUYDKMRRGM>
.
You are receiving this because you are subscribed to this thread.Message
ID: ***@***.***>
|
Beta Was this translation helpful? Give feedback.
-
|
This is expected behavior. To show comments in the results, you need to open this table. This is technical requirements; we can't load so much metadata, as it will affect performance |
Beta Was this translation helpful? Give feedback.
-
|
So, is it expected behavior only in Oracle databases? Why is it normal in other databases, such as PostgreSQL? |
Beta Was this translation helpful? Give feedback.
-
|
What puzzles me is, for the same table structure, why can field comments be displayed in Postgresql queries； |
Beta Was this translation helpful? Give feedback.
-
|
I believe metadata reads for Oracle are just way more expensive than in other databases. It's the only reason, I think. |
Beta Was this translation helpful? Give feedback.
-
|
Can a configuration item be added for the Oracle database to allow users to decide whether to enable it? |
Beta Was this translation helpful? Give feedback.
-
|
Could you please create a new ticket regarding this? Sorry for the inconvenience |
Beta Was this translation helpful? Give feedback.
Uh oh!
There was an error while loading. Please reload this page.
Uh oh!
There was an error while loading. Please reload this page.
-
Description
Oracle database does not display field comments after executing a query
When I use Oracle database, the field descriptions do not display in the SQL editor when executing a query statement; it is necessary to open the table structure first and then execute the SQL to display the field descriptions.
In fact, there are comments in the table structure.
When I open the table structure as shown in the image above and then execute the SQL again, the comments are displayed again, so it is necessary to check the table structure first and then execute the query to display the comments.
DBeaver Version
Operating System
Win 11 25H2
Database and driver
Steps to reproduce
No response
Additional context
No response
Beta Was this translation helpful? Give feedback.
All reactions