- SQL Editor:
- Added options to trim leading or trailing spaces in the selected text or the whole script (thanks to @seroperson)
- Resolved an issue with incorrect transaction mode display
- Fixed an issue where the transaction monitor showed “N/A” after the toolbar was changed with drag-and-drop (thanks to @xingxing21)
- Fixed an issue where the “Open a separate connection for each editor” preference was not saved (thanks to @xingxing21)
- Fixed the DROP confirmation dialog layout for long SQL queries (thanks to @EastLord)
- AI assistant: Fixed the default temperature value for different AI engines
- Data Editor:
- Fixed an issue where reference tables became empty when fetching the next page in the References panel
- Added an option to show column data type names in column headers (disabled by default) (thanks to @seroperson)
- Fixed an exception when expanding a custom data type value in Record mode
- Data Export: Fixed object list resizing in the Export/Dump window (thanks to @EastLord)
- Connectivity:
- Fixed an issue where cleared driver proxy credentials were still saved (thanks to @EastLord)
- Fixed an issue where testing an SSH connection with a passphrase failed if the passphrase was not saved
- Security: Fixed the high vulnerability (CVE-2026-3505) in the bcpg-jdk18on library. The library was updated to version 1.84.0
- Miscellaneous:
- Added the ability to save SQL to a file from the Generate SQL dialog
- Added the ability to import JetBrains database connections by pasting datasource configuration text directly into the import wizard (thanks to @EastLord)
- Fixed an issue where the splash screen was flipped on macOS 14.x.
- Databases:
- Athena: Added type casting for date values in data filters
- BigQuery: Added a new driver BigQuery (Experimental)
- ClickHouse: Fixed SQL Editor recognition for existing tables with uppercase letters in their names
- Denodo: Added support for custom data types and fixed column names for nested arrays
- DuckDB: Fixed map rendering for GEOMETRY types with CRS parameters (thanks to @EastLord)
- Firebird: Expanded database-specific SQL dialect coverage for the SQL Editor. Added more keywords, built-in functions, and SQL generators (thanks to @fdcastel)
- Greenplum/Cloudberry: Fixed external table recognition in the Database Navigator (thanks to @talmacschen-arch)
- MySQL: Fixed query boundaries recognition in the SQL Editor for scripts with the DELIMITER keyword (thanks to @HellAmbro)
- PostgreSQL:
- Fixed debug configuration dialog layout and datasource saving
- Fixed DDL generation for VIRTUAL generated columns (thanks to @EastLord)
- SAP HANA: Added the ability to reset the license during connection when the database is in license-only mode (thanks to @kc1r74p)
- SQL Server:
- Fixed DDL generation for external tables
- Fixed row limiting for table-valued function queries (thanks to @xingxing21)
- StarRocks: Fixed ADD COLUMN DDL generation (thanks to @EastLord)
- Localization: Localization: Improved Chinese localization (thanks to @EastLord)
DBeaver 26.0.4
Posted in Releases