SQL Editor: Added support for Common Table Expressions (CTE) by semantic analysis and autocompletion
Data Editor: When an inline editor is active and the user starts typing, the grid now automatically scrolls to the cell being edited to avoid unexpected cell editing
Connectivity:
Added an option to update a driver to a recommended version
Fixed an issue with replacing localhost with the IP address when connecting via SSH
Databases:
Clickhouse:
Clickhouse driver was update to version 0.8.5
Data type display was fixed
CUBRID: Added the ability to update user (thanks to @rathana-pvs)
GBase 8s: enhanced support for editing unique constraint and CHECK constraint (thanks to @Wintianis)
Firebird: Fixed native binary presentation (thanks to @niekschoemaker)
PostgreSQL:
Added the ability to backup all database schemas (using the Completed backup option) (thanks to @mikiubo)
Fixed Foreign data wrappers configurator opening
The retrieval of Collation was removed for older PostgreSQL versions (versions earlier than 9.1)
Snowflake driver was updated to version 3.23.0
SQLite: Added information about a table’s Strict mode to the Table Metadata section (thanks to @eusebe-cda)
TDengine driver was updated to the latest version (thanks to @DuanKuanJun)
Filter behavior has been improved for a better user experience
Fixed filters for secondary DBeaver app windows
SQL Editor:
Query cancellation after retry was fixed
When the “Blank Line is Statement Delimiter” option is set to Smart, blank lines are now correctly recognized as script delimiters while executing queries as Script
Fixed missing space after the leading keyword in some cases
Miscellaneous:
Added an option to display the breadcrumbs in either the status bar or at the top of editors
Breadcrumbs now occupy less horizontal space in the status bar
Added the DBeaver icon to aarch64-linux package (thanks to @chirontt)
New Drivers: Added support for Teiid database (thanks to @edulauer)
Databases:
CUBRID:
Added statistics and trace information to the result tab (thanks to @rathana-pvs)
Fixed incorrect script generation when creating a trigger via UI (thanks to @longhaseng52)
Denodo: the connection name was modified to Denodo (thanks to @dlopezc-denodo)
GBase 8s: fixed creation of a table with a primary key (thanks to @Wintianis)
MariaDB: after changing an expired database password, you can now immediately test the connection with the new password
MariaDB/MySQL: fixed creation of auto_increment columns with primary key
Oracle: fixed view creation via Metadata editor
Sap Hana: fixed an issue with name editing when creating a table in Metadata Editor
Snowflake: fixed metadata queries for driver versions 3.13.20 and higher (thanks to @smheaton)
Teradata: fixed an exception that occurred during code completion
Fixed a bug in single-tab mode where script execution displayed results from the previous execution
Fixed the sql formatting for procedure calls with multiple argument
Improved buttons layout in result set view on execution error
Auto-refresh is now stopped if the result is not visible or DBeaver window is collapsed
SQL autocompletion: Fixed the ability to expand columns for table_alias.*
Added the ability to use the “Short object names” code completion option for columns
Command parameters now always highlighted with black
AI assistant: Fixed an issue where a query without a semicolon before @ai was skipped without an error message. Query will be executed even if there is no semicolon
Metadata Editor:
Added the ability to view and edit comments in a popup window for improved user convenience
Fixed an issue where folder content in the Metadata Editor was not displayed immediately after opening an object
Data Editor: Removed options for copying column names and row numbers from the context menu for data cells
Diagram:
Updated the scrollbar color in the Diagram to match the expected design
Connectivity: Resolved the issue related to font rendering in the connection creation window
Security: Added the ability to enable TLS/SSL debug logging
Miscellaneous:
Breadcrumbs now update immediately when any included object is renamed
Popups for version update, Tip of the Day, and Sample Database are now displayed later if other modal windows are open, improving the user experience and reducing interruptions
Fixed the Open File dialog issue on Linux
Databases:
Azure SQL Server: The “CREATE VIEW” statement has been replaced with “CREATE OR ALTER VIEW” in the view DDL for Azure SQL Server v16 and higher
ClickHouse: Fixed issue with reading geometry data
CUBRID:
New column creation was fixed (thanks to @longhaseng52)
Added the ability to create and modify synonyms (thanks to @longhaseng52)
Databend: Fixed an issue with changing catalog names containing special characters (thanks to @rad-pat)
GBase 8s: Added the ability to edit table and column comments (thanks to @Wintianis)
Oceanbase: Diagram display was fixed
Oracle global variables such as SYSDATE and UID are now supported in query validation
PostgreSQL: Fixed an issue where selecting “Exclude auto-generated columns” excluded only identity columns but not other auto-generated columns (thanks to @f-m-t-t-m)
PostgreSQL:
Fixed an issue where the “Show partitions” option was hiding permissions in the DDL view (thanks to @f-m-t-t-m)
Added the ability to cancel queries in the Session manager (thanks to @mikiubo)
Fixed the display of the back slash symbol in comment blocks after refresh
SQLite: BLOB display was improved (thanks to @eusebe-cda)
New autocompletion was enhanced with support for USING, INSERT statements, nested queries, and fixes for multiple issues
You can now use the @ai command followed by a natural language phrase to instantly execute it as a query (requires AI extension)
Icons in SQL Editor toolbar were redesigned
Data Editor:
Dark theme support was improved, selection background was changed
Row hints were redesigned: key information is now displayed, the foreign key editor can be accessed via a right-click on the icon, icon rendering was improved
Context menu for Filters was simplified: all items are now on the same menu level
Data Transfer: Added an option to replace line break character when exporting to CSV
Connectivity:
Title for the Test Connection details was corrected
Fixed an issue with network profile saving
Miscellaneous:
Performance of theme switching was improved to enhance the user experience
Localization files were converted to UTF-8 to improve the localization process and enhance code readability
Numerous minor UI improvements related to editors and dialogs coloring and fonts
Databases:
MySQL/MariaDB: Removed redundant slashes in data export to SQL format
PostgreSQL: Both Asia/Calcutta and Asia/Kolkata time zones are now supported
Teradata driver was updated to version 20.00.00.38