dbeaver
dbeaver copied to clipboard
dbeaver
MISSING GENERATES SQL -> INSERT
Description
When I select Query and after the query result when I right it doest not appear. However on my other other SQL script it is showing
On this script it is missing, does not show (ORACLE)
However on the other script it appears (ORACLE)
DBeaver Version
Dbeaver Community Edition 22.3.3.202301211053
Operating System
Windows 11
Database and driver
No response
Steps to reproduce
No response
Additional context
No response
+1 for postgresql build on basic select statements on the same version of mac build. Coworker on windows build is not experiencing it
Can be reproduced on sample query like
SELECT 1, 2, 3 from Album a;
It seems that the issue happens if the result set is readonly (marked with a golden lock in the left top corner).
SELECT 1, 2, 3 from Album a; doesn't contain any columns from original table, it doesn't make sense to use such queries.
Can we reproduce it somehow else?
Hello @MaddoCXX
Generate SQL dialog can't appear because your result columns are read-only. Yellow lock says about it. So, the question is - does it expected behavior for you - that this result is read-only? If not, please provide your query for testing/
Hello @MaddoCXX
Generate SQL dialog can't appear because your result columns are read-only. Yellow lock says about it. So, the question is - does it expected behavior for you - that this result is read-only? If not, please provide your query for testing/
@LonwoLonwo So how to disable this lock? so meaning if i disable the lock it will now show the GENERATE-> INSERT?
Maybe yor database have read-only status? If not - please provide query for testing. Without a query I can't help.
There have been no updates for a long time. If the issue is still actual - feel free to reopen it.
