- Data viewer:
- Arrays and multi-row data types visualization was added (beta version)
- Excel like behavior for inline editor was added (shift row down, configurable)
- Bug in grouping panel was fixed (“duplicates only” option)
- Inconsistency of NULL value representation in calendar edit control was fixed
- Bug with inline editor activation with double-click was fixed (gtk)
- Bug with inline editor deactivation with single-click was fixed (macos)
- Data transfer:
- Export with “selected columns only” was fixed (wrong column mapping)
- Target DDL generator now checks for existing non-table objects
- Export in SQL INSERT format now uses proper table name for complex custom tables
- Header configuration for CSV and TXT formats was added
- Problem with super-long CSV files import was fixed (row number visualization)
- SQL editor:
- Generate DDL from resultset command was added
- Re-execute queries from execution log was supported
- Schema selector was fixed for databases which don’t support schema change (Sybase, SQL Server)
- Tasks:
- Nested task folders support was added
- Folders rename support was added
- SQL script execute task was fixed (NullPointer error)
- Connections: new connection name pattern now can be customized
- SSH configuration page now has scrollbars on small monitors
- Database full text search: page UI was improved, long lists paging was added
- Metadata editor: columns auto-size command was added to the context menu
- General UI: project configuration load visualization was added
- Clickhouse: enum data types support was added
- Derby: default driver version was set to 10.15 (to avoid Java version problems)
- Netezza:
- Default catalog selection was fixed
- Old drivers support was added (thanks to @rosspb3)
- PostgreSQL:
- Constraints information pre-read option was added
- Enum columns edit support was fixed
- Representation of arrays with NULL elements was fixed
- SQLite: view text edit support was added
- SQL Server:
- DDL for nchar and nvarchar columns was fixed (incorrect length)
- Columns with aliases now can be edited
- Trino: multi-row insert support was added
DBeaver 22.1.1
Posted in Releases