• SQL Editor:
  • 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)
  • SQL Server: Fixed table hints parsing
  • Yellowbrick: Added support for geospatial data

Changes since 24.3.5:

• Data Editor:
  • Added a suggestion to check spatial column visibility when enabling the spatial view
  • Data cells search algorithm fixed (find/replace)
• SQL Editor:
  • The schema selector is now hidden when it is not applicable to the current connection
  • @include command execution was fixed
  • Transaction mode refresh on script database change was fixed
  • Improved performance of reading data in the SQL console
  • Changed default shortcuts for the Result set zoom to Alt+0 and Alt+9 (to avoid conflicts with European layouts)
  • Proposal sorting in code completion was improved: joins are always on the top
  • Joins auto-completion was improved
• AI Assistant: Fixed excessive AI requests when AI is disabled (in the extension)
• Diagrams:
  • Table comments and fully qualified names visiblity was fixed
  • “ER Diagram” tab was renamed to “Diagram”
• Metadata Editor: columns and other objects reordering was fixed
• Navigator: schema indexes and triggers are now sorted in ascending order
• Connectivity: fixed an issue where the connection name was replaced with “localhost”
• Data transfer:
  • Connection recovery was fixed for stuck data transfer jobs
  • CSV export: array formatting was fixed
• Miscellaneous:
  • SQLite database files can be opened directly from OS file explorer (MacOS and Windows) or with CTRL+O shortcut
  • Splash screens were updated
  • Monospace font is now used for HEX, JSON, XML, and other content editors
  • All app settings are reset when the Reset Settings option is selected during installation
  • Blurry application icon in Windows was improved
  • Windows Store application configuration was fixed
  • Fixed issue with saving timezone in Preferences
• Databases:
  • Jennifer driver was updated to version v5.5.3.2
  • MySQL: Fixed an issue with restricted access for users without SHOW DATABASES permission
  • MariaDB:
    • Added the ability to change expired password
    • MariaDB driver was updated to version 3.5.2
  • MySQL: issue with duplicated check constraints was fixed
  • Oracle: Fixed index declaration in Oracle 23.1.0
  • PostgreSQL:
    • Added the ability to replace legacy timezone (on connection dialog)
    • Fixed transaction mode changing after the connection reopen
    • Fixed an issue with display database size after the connection refresh (thanks to @f-m-t-t-m)
    • Added the ability to change the storage strategy (PLAIN , EXTERNAL , EXTENDED) for a column (thanks to @eusebe-cda)
  • Redshift: query performance and stability was significantly improved
  • Snappy driver was updated to version 2.11-1.3.0
• Localization: Fixed typo in Russian localization (thanks to @mikiubo)

• SQL Editor:
  • Added the ability to use multi-line variables in SQL scripts
  • New autocompletion engine was improved and enabled by default:
    • Autocomplete performance was significantly improved
    • Fixed an issue with autocomplete failure after the dot
    • Fixed autocomplete for JOIN conditions
    • Fixed an issue with not executed included scripts
    • Fixed alias case sensitivity in autocomplete
    • Changed an icon for derived column in autocompletion proposals
• ER Diagram: added the ability to generate SQL with INNER JOIN and SIMPLE JOIN from a diagram
• Query Manager: query duration formatting was fixed
• Data Editor:
  • Fixed an issue where unchanged cells were incorrectly marked as updated after pasting data
  • Fixed row coloring when querying multiple tables
• Data transfer: removed the ability to change data type for existing columns in Data Export
• Database Navigator: database object filter was improved. Connection filter is enabled by default
• Miscellaneous:
  • We migrated to the Java 21
  • Added the ability to associate different file types with DBeaver on Windows and macOS
  • Bookmark vew is now working again
  • Font in error messages was changed to monospace
  • Commit/Rollback monitor was fixed
  • Fixed bold font display for theming on macOS
• Databases:
  • Azure Databricks: information_schema was added to Database Navigator
  • Databend: icons were updated
  • CUBRID:
    • Fixed index creation preview
    • Fixed column creation with STRING and similar data types
    • Procedure, function, and view names are now displayed in lowercase
    • Added the ability to change comment for foreign key columns
  • LibSQL: UI for token-based authentication was added
  • Machbase: driver was updated to version 8.0.2
  • MySQL/MariaDB: explain plan now works for all types of SQL queries
  • Oracle:
    • Fixed DDL generation for table spaces
    • Fixed user password changing
  • PostgreSQL: fixed an issue with disappearing ENUM definition after the refresh in Metadata editor
  • Salesforce Data Cloud:
    • Removed the ability of edit database metadata
    • The latest driver version is now downloaded by default
  • SAP HANA: partition view was added
  • SQLite: STRICT mode support was added
  • SQL Server:
    • Index creation was fixed
    • Fixed an issue where the index type couldn’t be changed to unique
  • Teradata:
    • XML column value save was fixed
    • Removed incorrect warning message after executing SHOW and similar queries

• SQL Editor:
  • Added the ability to use multi-line variables in SQL scripts
  • New autocompletion engine was improved and enabled by default:
    • Autocomplete performance was significantly improved
    • Fixed an issue with autocomplete failure after the dot
    • Fixed autocomplete for JOIN conditions
    • Fixed an issue with not executed included scripts
    • Fixed alias case sensitivity in autocomplete
    • Changed an icon for derived column in autocompletion proposals
  • ER Diagram: added the ability to generate SQL with INNER JOIN and SIMPLE JOIN from a diagram
  • Query Manager: query duration formatting was fixed
  • Data Editor:
    • Fixed an issue where unchanged cells were incorrectly marked as updated after pasting data
    • Fixed row coloring when querying multiple tables
  • Data transfer: removed the ability to change data type for existing columns in Data Export
  • Database Navigator: database object filter was improved. Connection filter is enabled by default
  • Miscellaneous:
    • We migrated to the Java 21
    • Added the ability to associate different file types with DBeaver on Windows and macOS
    • Bookmark vew is now working again
    • Font in error messages was changed to monospace
    • Commit/Rollback monitor was fixed
    • Fixed bold font display for theming on macOS
  • Databases:
    • Azure Databricks: information_schema was added to Database Navigator
    • Databend: icons were updated
    • CUBRID:
      • Fixed index creation preview
      • Fixed column creation with STRING and similar data types
      • Procedure, function, and view names are now displayed in lowercase
      • Added the ability to change comment for foreign key columns
    • LibSQL: UI for token-based authentication was added
    • Machbase: driver was updated to version 8.0.2
    • MySQL/MariaDB: explain plan now works for all types of SQL queries
    • Oracle:
      • Fixed DDL generation for table spaces
      • Fixed user password changing
    • PostgreSQL: fixed an issue with disappearing ENUM definition after the refresh in Metadata editor
    • Salesforce Data Cloud:
      • Removed the ability of edit database metadata
      • The latest driver version is now downloaded by default
    • SAP HANA: partition view was added
    • SQLite: STRICT mode support was added
    • SQL Server:
      • Index creation was fixed
      • Fixed an issue where the index type couldn’t be changed to unique
    • Teradata:
      • XML column value save was fixed
      • Removed incorrect warning message after executing SHOW and similar queries
  Tweet

• SQL Editor:
  • Added support for SELECT INTO query smart completion
  • Changed shortcuts for result set zoom: Ctrl+Aalt+0 and Ctrl+Alt+9
  • Fixed the order of completion suggestions in the proposals list
  • New completion engine:
    • Fixed a bug with duplicating alias part during column completion
    • Fixed autocomplete for join conditions when multiple joins are present
    • Proposals list now contains only objects from the next hierarchy level
    • Fixed autocompletion for SELECT statements with table hints for SQL Server
  • Fixed the issue where the old result set tab didn’t close when switching between multiple and single tab modes
  • Fixed a stack overflow error that occurred when a user tried to execute a script for an open result set with row coloring
  • When an error occurs, the last executed query is now displayed next to the error message
  • Fixed an exception that appeared while typing
• AI assistant: Fixed syntax issues in queries generated by Azure Open AI
• Data Editor:
  • Added hints for geometries with SRID and for timestamps with time zones
  • Added the ability to configure hint visibility for a table or a datasource
  • Hints presentation was enhanced
  • Added backslash escaping when generating scripts
  • Added an option to disable the dictionary view (set “Maximum amount of elements” to 0)
  • Fixed freezing issues when pasting big number of rows or when performing find/replace
  • Added an option to save XML and JSON files in compressed format
  • Fixed data editor filters for commoт table expressions
• Miscellaneous: Added the ability to create bookmarks from the context menu of object tabs
• Databases:
  • Cloudberry driver was added
  • CUBRID: Fixed view name generation in DDL (thanks to @longhaseng52)
  • MySQL:
    • USAGE privilege is now hidden if any other privilege has been granted
    • Fixed loading of DBA privileges
  • PostgreSQL: Fixed the display of infinity for date values

• SQL Editor:
  • New autocompletion engine was enabled by default
  • 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

• SQL Editor:
  • Added AS before table alias in FROM clause for all relevant databases
  • New autocompletion: added support for USING and some improvements for JOIN condition
  • Fixed indentation behavior when adding a new line
  • Added support for ${time} variable in data source variables for script templates (thanks to @pajonas)
• Data Editor:
  • Cell hints were redesigned. You can configure them on the Context menu
  • Added support for the composite types for Grouping panel
  • Items with the too long text in query history were truncated
• Navigator: Saving filter for database objects was fixed
• Data Transfer: Added the ability to use comma as a delimiter in the Advanced Copy option (thanks to @GFreitasW)
• Connectivity: Proxy configuration loading was fixed
• Miscellaneous:
  • Proper names for catalog/schema are now used for different drivers
  • Added word wrap for hints to controls
  • Search in Preferences was improved
  • Scrolling in the “Tip of the day” window was fixed
  • Metadata configuration files were moved to the .metadata/config folder
  • Localization of basic controls, settings, and menu items was fixed
  • We migrated to Eclipse 2024-12
• Development: Building of IDEA project was fixed
• New Drivers: Databend database was added (thanks to @rad-pat)
• Databases:
  • CUBRID: Added REUSE_OID, COLLATE, and COMMENT to the table DDL (thanks to @longhaseng52)
  • Google BigQuery driver was updated to version 42_1.5.4.1008
  • InterSystem IRIS driver was updated (thanks to @bdeboe)
  • MySQL:
    • Now users can change expired password
    • Added a setting to not export routines (thanks to @pajonas)
  • OpenEdge: query generation was fixed
  • OrientDB driver was updated
  • PostgreSQL:
    • Added default privileges grantor to DDL
    • Syntax error in DDL generated for the role settings was fixed
    • Default privileges for new roles were fixed
  • Salesforce Data Cloud driver was updated
  • Snowflake: Added support for table aliases in autocompletion
  • SQLite: creating new constraint from selection was fixed (thanks to @eusebe-cda)
  • SQL Server: Primary Key ordering in DDL generation is now respected

Changes since 24.2.5:

• Data Editor:
  • Row coloring mapping now respects the visual order of columns
  • Fixed invalid thread access on editing data in multiple results in one tab mode
  • Boolean icons display was fixed
  • Ability to detach result tabs is now limited to tabs with data
• SQL Editor: underscore in identifiers are now supported in query validation
• Navigator:
  • Multiline comment display was fixed
  • Scrolling during drag-n-drop was fixed
• Data Transfer:
  • Commit/rollback behavior during the data import was improved
  • It’s now possible to not specify quote and escape characters during the import of CSV files
• New Drivers: GBase 8s is now supported (thanks to @Wintianis)
• Miscellaneous:
  • Snap build was fixed again
  • Fixed connection creation from the “File” option in the main menu
  • Fixed an issue where reading generic foreign keys
  • Option “Open separate connection setting” on SQL Editor and Metadata pages was disabled for embedded databases
• Databases:
  • Azure SQL Server: restored the “Show all databases” option in the Connection dialog. And added an error message to guide users on creating a new connection to access other visible databases
  • BigQuery: Procedures handling is now supported in SQL editor, including LOOPS, IFs, BEGIN END, and CASE
  • MySQL: Fixed an issue with table refresh when the “Server-side object filters” option is disabled
  • Oracle: BOOLEAN type is now supported in Data Editor
  • PostgreSQL:
    • Schema permission editing was fixed
    • Default privileges rendering was fixed
  • RisingWave: array handling was improved
  • SQLite:
    • Fixed an issue with duplicate primary key generation in SQL scripts (thanks to @eusebe-cda)
  • Fixed an issue with deleting a column without a data type (thanks to @eusebe-cda)
  • CSV driver was renamed to CSV Basic

• New drivers: New LibSQL/Turso driver was added
• SQL Editor:
  • Fixed script execution on disconnected state
  • New autocompletion behavior was enhanced
  • Added execution time in statistics result (thanks to @tlm365)
• Query manager: Time column now orders chronologically
• Metadata: Indexes have been returned to the unique constraint list, and the proper data type is now set when creating a new column for a new foreign key
• Data Editor:
  • Fixed an issue with crash caused by too long tooltips
  • Row coloring mapping was fixed
• Data Transfer: “Minimum column length” was renamed to “Default column length”
• Connectivity: “Driver properties” tab in the driver editing dialog was renamed to “Default properties”
• Charts and Dashboards: Fixed charts COUNT for single value
• Miscellaneous:
  • Windows Server 2016, Windows Server 2012, and Windows 8.1 are supported again
  • Snap build was fixed
  • Eclipse extension installation was fixed
  • Query execution canceling was redesigned
  • Issues with unexpectedly closing connections were resolved
  • Added references to the actual boolean editor in Preferences
• Databases:
  • Added support for Hive 4
  • Altibase: Lock manager has been added (thanks to @zennken)
  • CUBRID:
    • Added the ability to create and edit triggers (thanks to @longhaseng52)
    • Added sargs, edge and Query parameters to the Execution plan (thanks to @rathana-pvs)
  • Oracle: Fixed highlighting for public schemas
  • PostgreSQL:
    • Added date picker and fixed data saving in the Role editor
    • Fixed highlighting for public schemas
    • Connection to custom schemas was fixed
    • Fixed data change saving in Value Panel
  • Teradata:
    • Multi-row insert was fixed in data import
    • Fixed incorrect display of PERIOD data type
    • Max rows handling was improved

• SQL Editor:
  • A warning is now shown instead of an error when a DROP TABLE statement contains IF EXISTS and the table does not exist
  • Fixed script execution on disconnected state
  • New autocomplete engine now expands the * symbol in SELECT statements when using “Ctrl + Space”
  • New autocomplete no longer suggests query-start keywords in the middle of queries
  • Metadata requests are no longer sent while typing a query when “Auto-activate on typing” is enabled
• Data Editor: exception on disconnection was fixed
• Navigator:
  • Added the ability to refresh the database connection
  • Filters were fixed
• Data Transfer: Added the ability to export JSON values as embedded JSON
• Connectivity:
  • Presentation of driver download errors has been improved for better clarity and user experience
  • Finding class in the Driver manager was fixed
• Miscellaneous: the Export Window now advances properly when pressing the Enter key
• Databases:
  • Altibase: Module Memory Usage was added to the system information folder in the navigator tree (thanks to @zennken)
  • ClickHouse: Array syntax highlighting has been improved
  • CUBRID: “Use SQL to limit fetch size” was set to true (thanks to @hwany7seo)
  • Fixed an exception that occurred when creating a column without specifying a data type
  • Ingres: driver download was fixed
  • Redshift: access to external databases was fixed
• Localization: Brazilian Portuguese localization was enhanced (thanks to @brlarini)