Releases: dbeaver/dbeaver
Releases · dbeaver/dbeaver
24.3.3
- 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 commom 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
24.3.2
- 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
24.3.1
- 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:
- .gitignore for IDEA files was configured (thanks to @anton-erofeev)
- Building 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
24.3.0
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
24.2.5
- 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
24.2.4
- 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)
24.2.3
- SQL Editor:
- "Show values setting" in the autocompletion section is disabled by default due to performance issues
- Added highlighting and validation of synonyms
- Semantic error style was changed
- Fixed issues with highlighting that occurred when saving the script
- Metadata: Fixed and exception that appeared on right click on table properties
- Connectivity:
- Fixed an issue where script execution would not stop when disconnected
- Added an ability to export driver files from the "Edit driver" dialog
- Fixed user name display in SSH profile
- Miscellaneous:
- Added additional Java configuration file independent of the product version update
- Added the ability to disable Windows Defender at startup, which speeds up application loading
- Some SWT errors were fixed
- Darkest Dark theme installation was fixed
- Added the ability to work with OS usernames containing special characters
- Git extension installation was fixed
- Eclipse license text was updated
- Fixed exception that appeared when loading procedure
- Databases:
- BigQuery: Array and JSON display was improved
- Db2 z/OS: Fixed broken configuration for generic drivers
- DuckDB: BLOB display was fixed
- MySQL: Added support for table name in backticks for SQL Editor
- PostgreSQL: Permission editor was fixed
24.2.2
- SQL Editor:
- 'Cmd+Enter' shortcut was added in addition to 'Ctrl+Enter' on macOS due to the conflict with new system hot keys in Sequoia
- Fixed an error in multiple tab mode execution when the new execution results replaced old ones
- The amount of problems being displayed per script query was limited
- Complicated table qualifiers (database.catalog.schema.user) are now supported
- Fixed incorrect highlighting after the database disconnect
- Query execution time is now displayed in seconds/minutes
- Added an ability to select the text between brackets using 'Ctrl+Shift+]' hot key
- Background Tasks view now shows progress of autocompletion engine
- Data Editor:
- Presentation and editing of struct and array data types was significantly improved
- DBeaver can now correctly display negative dates in MySQL databases
- Data Transfer: changed icons for collapsed sections to improve the interface readability
- Connectivity: fixed error handling when a user loads a driver and has an error with certificates
- Navigator:
- Table filters in Simple view were fixed
- Disabled the ability to delete the currently active project
- Miscellaneous
- Incorrect sorting in Execution log was fixed
- Issue with not working boolean setting editor was fixed
- Databases
- Altibase: added display of the list of tables and indexes within a tablespace (thanks to @zennken)
- CUBRID:
- Added the ability to create, edit, and drop Server via UI (thanks to @longhaseng52)
- Added an ability to create, update, and delete users. (thanks to @rathana-pvs)
- Oracle:
- Added highlighting and validation of public synonyms
- Table autocompletion was fixed
- Virtuoso: replaced static jar file with Maven artifact
24.2.1
- SQL Editor:
- Smart syntax highlighting was significantly improved
- Pseudo columns highlighting was improved
- Table aliases were fixed in smart completion
- Issue with pinned tabs was resolved
- Syntax highlighting fixed for single quoted strings (thanks to @tlm365)
- SQL console save was redesigned (it now asks for confirmation)
- Data editor:
- Commit/rollback buttons now enabled only when transactions are applicable
- Column description rendering was improved for dark theme
- Database navigator: horizontal scrolling was fixed, now action icons are always visible
- Object editor: bottom toolbar layout was unified for all tabs
- Data transfer:
- CSV parameters documentation was added
- Database backup/restore dialog layout ws fixed
- General:
- Snapcraft image now includes additional fonts
- Embedded browser support was added for Linux/GTK
- App command line parameters logging was was disabled because of security concerns
- Issue with splash screen and error message overlapping was resolved
- Resource leak detection logging was added by default
- We migrated to Eclipse 2024-09 platform
- Databases:
- Altibase: database replication metadata was supported (thaks to @zennken)
- Azure SQL: "show all databases" option was removed
- CUBRID:
- Index drop command generation wad fixed (thanks to @longhaseng52)
- Procedure create dialog was added (thanks to @longhaseng52)
- List of reserved keywords was updated (thanks to @rathana-pvs)
- DolphinDB driver was added (thanks to @peeyee)
- MySQL: NULL geometry values handle was fixed (thanks to @EastLord)
- Salesforce CDP: connection dialog layout was fixed
- SAP HANA:
- Connection dialog was improved for HANA Cloud (thanks to @kai-morich)
- Expired password change feature was added (thanks to @kai-morich)
- Trino: issue with long cursor reading was fixed (thanks to @schaffino)
- Localization:
- Arabic localization was added (thanks to @AliElamir)
- Brazilian Portuguese localization was updated (thanks to @brlarini)
24.2.0
Changes since 24.1.5:
- SQL Editor:
- Fixed highlighting of block $$ for functions and procedures when the semantic analysis option is enabled
- Warning and errors handling and presentation was improved
- Subquery semantic analysis was enhanced
- Improved CREATE and DROP queries handling
- Autocompletion for fully qualified names was fixed
- Duplication of proposals with new completion engine enabled was fixed
- Incorrect suggestions with new completion engine enabled were fixed
- AI Assistant:
- Added new model 'gpt-4o-mini'
- Removed deprecated model 'gpt-3.5-turbo-16K'
- Fixed query generation when enabled formatting
- Data Editor:
- Some datatypes icons were changed
- Fixed filtering on columns with spaces
- Added an ability to render geometry shapes in their assigned color if a 'color' column is present in the result set
- Improved handling of fully qualified names in Grouping panel according to SQL dialect
- Local links opening was restricted
- Datatransfer: Data transfer windows width was fixed
- Connectivity: Fixed verification of the 127.0.01 host when connecting via SSH
- General:
- Fixed flipping splash screen on macOS Sequoia
- Foreign Data wrappers configurator was fixed
- 'Open auth links in embedded browser' setting was disabled by default
- Search in Preferences was improved: added keywords for reopen, open, Hippie, autosave, and others
- Fixed selection of wrong database when changing connection for database with similar names
- Folder display in Simple view was fixed
- Numeric (DWORD) type parameters in Windows Registry are now supported
- 'Ctrl+Alt+Left / Right' hotkeys for 'Previous Edit Location' and 'Next Edit Location' were fixed
- Databases:
- Clickhouse: Filtering by the Date data type was fixed
- MySQL: Error/output log dump was fixed
- PostgreSQL:
- Ordering by interval datatypes in the Data grid was fixed
- Added regexp functions support in SQL Editor (thanks to @anton-erofeev)
- Redshift:
- Connection stability was significantly improved
- DDL presentation was fixed
- Role, User, and Group presentation was fixed
- SQL Server:
- SQL Server driver was updated to version 12.8.0
- Fixed DDL and column display with custom data types
- Localization: French localization was updated (thanks to @KawtharAlakri)