Releases: dbeaver/dbeaver
Releases · dbeaver/dbeaver
24.1.5
- SQL Editor:
- Added semantic analysis and Outline viewer support for CREATE and ALTER TABLE queries
- Added presentation for warnings in semantic analysis results
- Data type icons were redesigned
- SQL error presentation was redesigned
- 'Execute SQL Script' option behavior was fixed
- SQL Output for SQL scripts was fixed
- Output panel opening was fixed
- Column aliases can now be copied with Advanced Copy option (thanks to @dstivanov)
- Column validation for UPDATE SET clause was fixed
- Issue with invalid table name was fixed
- If all tabs with query results are pinned, a new tab with a new query result is created
- Data Editor: Paste into the table with no foreign key was fixed
- Database Navigator:
- Connection visualization was fixed
- Navigator icons were redesigned
- Connectivity: Connection page for custom drivers with the URL template was fixed
- General:
- Opening links to local files has been restricted due to a security issue discovered by @LuskaBol
- Improved error handling when trying to use not allowed characters in project name
- Databases:
- Altibase: Non-schema objects like Job, Database Link, Directory, and Library are now supported (thanks to @zennken)
- BigQuery: Database monitoring dashboards were added
- GaussDB driver was updated to version 4-1.1 (thanks to @GaussDB-Fans)
- MariaDB: Geometry data type is now supported
- Ocient: Incorrect DDL generation was fixed (thanks to @mjsterckx)
- SQLite: Full text search was improved
- SQL Server: Saving changes in procedures was fixed
24.1.4
- SQL Editor:
- Problem markers with semantic error descriptions were added. You can click on the problem description in the tooltip to find out what is wrong with the query.
- INSERT, DELETE, UPDATE, DROP, CREATE, and ALTER statements execution in read-only mode was prohibited
- Smart mode for Blank line state delimiter was improved
- Simultaneous query execution was fixed: if a query is already being executed, you can execute another query in a new tab only
- Composite type field color became visible in the Dark theme
- Completion analyzer performance was enhanced
- Data Editor:
- Inline editing of geometry fields was fixed
- New keyboard shortcut Ctrl+Shift+Alt+C has been added to use the advanced copy option with the latest settings, without opening a popup window
- Metadata Editor: Generate SQL option in the context menu was fixed
- Connectivity: Closing idle connections and default timeout were fixed
- General:
- Users can import connections from SQL Workbench and DbVizualizer
- Wayland support on Linux was fixed
- Several code improvements have been made (thanks to @KonstantinRight)
- Databases:
- GaussDB driver was added (thanks to @GaussDB-Fans)
- Couchbase: Legacy Couchbase driver was removed
- CUBRID:
- Execution plan was enhanced (thanks to @rathana-pvs)
- Issue with Null datatype was fixed (thanks to @longhaseng52)
- Creating partition option was removed (thanks to @longhaseng52)
- InterSystems IRIS driver was updated to version 2024.1 (thanks to @isc-rsingh)
- PostgreSQL: If the database name is empty, it will be set to the same as the username
- SAP Hana: Additional system table prefix was added (thanks to @kai-morich)
- SQL Server: Ability to upgrade/install the driver was fixed
24.1.3
- SQL Editor:
- Added ability to disconnect from the datasourse when all associated editors were closed (configurable)
- New autocompletion engine was significantly enhanced
- Autocompletion for derived columns in sub-queries was improved
- Autocomplete suggestions inside literals in INSERT INTO were disabled
- Execution of the corrected SQL script was fixed
- 'Recent SQL script' was renamed to the 'Last edited SQL script'
- Short/long object names completion configuration was redesigned
- Metadata editor: Composite data types presentation was added for table columns
- Data editor: JSON and XML panels performance was enhanced
- Data transfer:
- Compress option behavior was fixed
- Wizard window auto-size was fixed
- Task management: Broken exported file extension after the task editing was fixed
- Dashboards: Project dashboard UX was improved
- Connectivity:
- Connections invalidation after sleep mode was added
- Idle connections timeout was fixed
- General:
- Establishing connection visualization was added to Database Navigator and Projects
- Tooltip delay on macOS was reduced and became configurable
- Saving script outside the Script folder was fixed
- SVG extension was moved to the PRO version
- Authentication in embedded browser was temporarily disabled on Linux
- Databases:
- Altibase:
- Added the ability to compile procedure, function, or package from the UI as well as truncate table and refresh materialized view (thanks to @zennken)
- Added status of the view, materialized view, procedure, function, or package (thanks to @zennken)
- Execution plan parsing error was fixed (thanks to @zennken)
- Clickhouse:
- DateTime32 formatting was fixed
- IPV6 data presentation was added (thanks to @asifjoardar)
- Complex structure display in the Data grid was fixed
- CUBRID:
- View creation was added to the UI (thanks to @longhaseng52)
- Supported keywords for SQL Editor were reviewed and updated (thanks to @rathana-pvs)
- Ability to edit Serial using UI was added (thanks to @longhaseng52)
- DuckDB: Data edit was fixed
- Microsoft Azure driver was updated to version 12.7.0
- Oracle: DDL generation for Oracle Tablespaces was added (thanks to @pandya09)
- PostgreSQL:
- Specific functions were supported in the SQL Editor (thanks to @EastLord)
- Metadata read was fixed
- Redshift:
- Metadata reading for indexes was disabled
- Problems with broken connection were resolved
- SAP IQ: Duplicated output messages were fixed
- Teradata: Database name became optional for connection
- Vertica: Incorrect query execution with the cursor at the end was fixed
- Localization:
- Italian localization was updated (thanks to @Gnafu)
24.1.2
- SQL Editor:
- Performance in Smart mode of Blank line as a statement delimiter was enhanced
- Ability to show all SQL scripts from the main toolbar was added
- Syntax highlighting for functions with multiple arguments was fixed
- SQL datatype color use was corrected
- DROP statement support was added to Outline
- Metadata Editor: Foreign Key creation dialog UIX was improved
- Data Editor:
- Indication of the table read-only/editable mode was added
- Information about active unique key used for data edit was added
- Customise and Save filter buttons were moved to the dropdown
- Issue with too small Result Set Order/Filter Settings window was resolved
- Rollback timer flickering was fixed
- Query Manager: information about database schema and catalog was added to the detailed record view
- Simple Structure Compare: issue with long file names was resolved
- Connectivity:
- Issue with default SSH connection timeout was resolved
- Driver downloading problem reporting was fixed
- General:
- Incorrect button behavior in the confirmation dialog was fixed
- Security credential encryption was enhanced (thanks to @longhaseng52)
- Toolbar and Data Editor background on the Dark theme was improved
- Smart commit mode indication was fixed
- Issue with metadata cache reading was resolved
- Automatic resize of connection dialog and tasks dialogs was fixed
- Databases:
- Clickhouse:
- Complex structures handling was fixed
- Clickhouse driver was updated to version 0.6.1
- CUBRID: 'db_server' information was added to the Database Navigator
- Oracle: Connection error in the application downloaded from the Microsoft Store was fixed
- PostgreSQL: Dollar-quoted string parsing was fixed
- SQL Server:
- Issue with resultset primary key detection was resolved
- Duplicated output when running stored procedures was fixed
- NTLM Authentication was fixed
- Datetime datatype representation was fixed
24.1.1
- AI: GPT-4o model was supported
- SQL Editor:
- Auto-save editor setting was enabled by default
- ILIKE keyword was supported
- Support for unsigned numbers in GROUP BY clause was added
- Syntax highlighting and outline viewer support parameter changes in SQL Processing settings
- Links to the SQL Editor and Visual Query Builder were added to the Context menu
- Buttons in the right toolbar were renamed
- Print mode in ER Diagrams and Execution plan was fixed
- Saving Diagram outside the workspace was fixed
- Data Editor:
- Information about table unique key is displayed in the grid
- BETWEEN and LIKE keywords were added to filetr autocomplection
- Data transfer:
- Export of data with backticks was fixed (thanks to @diashalabi)
- Export of binary columns in JSON format was fixed
- General:
- Ability to restore default settings was fixed in SQL Editor Formatting settings, SQL Editor settings, SQL Editor Commit type, Error handling settings, and Hex Editor default width
- Creating a view from the UI was fixed
- Buttons display when creating new dashboard was fixed
- New table creation was fixed
- The following drivers were updated:
- Firebird to version 5.0.4
- Redshift to 2.1.0.29
- Informix to 4.50.JC10W1
- Databases
- Altibase: Search for server properties was added (thanks to @zennken)
- BigQuery: Ability to see bytes billed in Statistics panel in the Data Editor was added
- Cubrid:
- Execution plan coloring was enhanced (thanks to @hwany7seo)
- Ability to create a table via UI was added (thanks to @longhaseng52)
- DDL display for a view was added together with the ability to display the list of indexes, synonyms, serials, triggers, and procedures (thanks to @longhaseng52)
- Ping query for keep connection alive was added (thanks to @rathana-pvs)
- Partition display was added (thanks to @rathana-pvs)
- PostgreSQL:
- If database field in connection settings is empty, user name is used as a database name
- Work of 'Use fully qualified names' setting was fixed for views
- Redis: Key settings were fixed
- Redshift: Constraint creation was fixed
- Vertica: Stored procedures handling in SQL Editor was fixed
24.1.0
Changes since 24.0.5:
- SQL Editor: issue with extra linefeed during autocompletion was fixed
- Data Editor: loading data when fast scrolling using the keyboard was fixed
- Database tasks:
- Maximum execution time option was added
- Tasks running from non-default workspace was fixed
- Connectivity:
- 'Azure AD' was renamed to 'Microsoft Entra ID'
- Links to database support documentation were added for many databases
- Automatical termination of the shell command script 'Before connect' was fixed
- General:
- Crash when closing detached editor tab in another window was fixed
- 'Restore default' for Metadata read, Client identification settings was fixed
- .projects and .settings folders became findable in Projects when the application is used as an Eclipse plugin
- Truncated notifications were fixed
- Projects:
- Disconnecting a database from the Project view was fixed
- Opening a bookmark after changing the application language was fixed (thanks to @SASUKE38)
- ERD: loading diagrams for drivers with broken foreign keys support was fixed
- Database Navigator:
- Color of the table statistics was changed to visible in the dark theme and became configurable
- Deleting connection option in the context menu was renamed to 'Delete connection'
- Databases:
- CrateDB: table DDL was fixed
- Databricks: authentication with personal access token was added
- DB2i: procedure creation was fixed
- DuckDB: aliases autocompletion was fixed
- H2: foreign keys presentation was fixed
- Oracle: JSON data type support was improved
- PostgreSQL: support of fully qualified names in DDL was fixed
- Localization:
- German localization was updated (thanks to @maxbobse)
24.0.5
- SQL Editor:
- Smart mode for statement delimiter was improved
- Default option for the setting 'Blank line is statement delimiter' was changed to 'Always'
- Cursor behavior during autocompletion was improved
- Code highlighting issue with a quoted identifier in case of no connection was fixed
- High CPU usage for large script was fixed
- Metadata Editor:
- Highlighting for created entities was changed to green
- Virtual foreign keys: reference table container selector was fixed
- Database Navigator: CTRL+C and other shortcuts behavior after the application startup were fixed
- AI (extension): custom scope performance was improved
- General:
- Opening editors for files with special symbols in names was fixed
- Portable distribution of the application was fixed (config files location)
- Licensing for some source files was fixed
- Eclipse plugin: new database objects create was fix
- Databases
- DuckDB: Spatial data visualization support was added
- Oracle:
- Partition type display was added
- Materialized view refresh was fixed
- SQL Server: Default IDENTITY was changed to (1,1) (thanks to @Sgierek106)
- Vertica: LOOP - END LOOP as a block and DECLARE were added to the syntax analyser
24.0.4
- SQL Editor:
- Smart mode for Blank line is statement delimiter setting was fixed
- Vertical button alignment was fixed
- ER Diagrams: Keep layout selection was fixed
- Data transfer:
- Import from CSV with duplicated columns names was fixed
- Parallel data transfer monitoring/cancellation were fixed
- Dashboards:
- Ability to drag and drop charts to another dashboard was added
- Number of minor UI improvements were added
- Connectivity:
- SSH parameters validation on the Connection page was added
- Editing of 'Local host' and 'Remote host' fields in the Port Forwarding section was fixed
- Database connection timeout notification was fixed
- Development: Redundant tests were disabled
- Databases
- MariaDB:
- GRANT OPTION privilege persistence was fixed
- Schema privileges representation was fixed
- SQL Server: trigger deletion was fixed
- Teradata: link to the referenced table in the Metadata editor was added
- Localization: French translation was updated (thanks to @Jean-BaptisteC)
- General:
- Language configuration in Windows installer was fixed
- We have migrated to Eclipse 2024/06
24.0.3
- General:
- Migration from Toad for Oracle was supported
- Sensitive information in the log files is now masked
- SQL Editor:
- Smart mode for 'Blank line as statement delimiter' option was added (enabled by default)
- Sub-select autocompletion was added
- Highlighting of column references in INSERT queries was fixed
- Outline viewer opening was fixed
- Issue with hidden text on macOS was fixed
- Connectivity:
- Space trimming when saving user credentials was added
- Saving SSH configuration with missing AWS private key was fixed
- Reconnecting via SSH tunnel was fixed
- ER Diagrams: foreign keys presentation was fixed
- AI:
- AI assistant is enabled by default
- Database metadata collection was fixed
- Dashboards: disappearance of custom dashboards after version update was fixed
- Connectivity:
- Space trimming when saving user credentials was added
- Saving SSH configuration with missing AWS private key was fixed
- Reconnecting via SSH tunnel was fixed
24.0.2
- Connectivity:
- Using multiple jumps tunnels when connecting via SSH was supported
- Enable tunnel sharing option was added
- Test connection was fixed
- SQL Editor:
- WHERE TRUE and SELECT UNIQUE support was added
- Error with single quoted string was fixed
- Syntax highlighting after active schema change was fixed
- Data Editor:
- Automatic row count option was added (thanks to @utsav1704)
- Metadata editor:
- Deleting table comments was fixed
- Linking with the editor was fixed
- General:
- Ability to collect log files from the interface was added
- Transaction rollback behavior was fixed
- Metadata changes were removed from the commit counter
- Autocommit in production databases was fixed
- Data transfer:
- Ability to specify header case in the target file was added
- Typo in the confirmation dialog was fixed
- Databases:
- Cubrid: Query plan feature was added (thanks to @rathana-pvs)
- Old MySQL drivers were repacked
- PostgreSQL: Jobs, roles, and system information were hidden in the Hide Folders mode
- SQLite: Deleting columns was fixed