September 7 2021
Changes since 21.1:
- General improvements:
- Taiwan localization was added
- Test connection dialog now shows connection detailed information
- Last workspace location is now restored after DBeaver version upgrade
- Redundant P2 plugins were removed from the standalone version
- TLS 1.0 and TLS 1.1 support configuration was fixed
- Procedure body read now re-established connection on demand
- Shell commands now support quoted parameters (Linux, MacOS)
- Debian/RPM package installers now use different directories for community and commercial versions
- Simple schema compare wizard UI was fixed
- SQL queries which contains passwords were removed from logs
- Driver editor dialog enhancements
- Connection driver settings: problem with non-editable properties was fixed
- DBeaver icons duplication on Ubuntu was fixed
- Row count bug after DBeaver restart was fixed
- Option to show all tables (with FQN) in a single folder was added
- Current user password change tool was added
- Many minor UI and database-specific bugs were fixed
- Data editor:
- Row coloring now supports LIKE and other operators
- Read-only columns mark was redesigned
- Confirmation dialog was added for column filters
- References panel UI was fixed (rows highlighting)
- Spatial data viewer now remembers selected SRID for particular columns
- Row insert with default values was improved
- Data filter popup now visualizes loading process
- Pin column now works for multiple selected columns
- Filters dialog now supports column pin/unpin
- Auto-complete in grouping panel was fixed
- Plaintext record mode switch was fixed
- Toolbar commands enablement handler was fixed
- Detached text/binary editor was fixed
- Row coloring: LIKE and REGEX filter value editor was fixed
- Metadata editor:
- Metadata search now supports search in procedures/views definition
- Object info refresh was fixed
- Table triggers loading performance was significantly improved for most databases
- Data transfer:
- Custom transformations were added for table column mapping
- Referential integrity disablement was added for MySQL, SQL Server and Exasol
- Column mappings page supports reordering now
- Data export task editor was fixed (task re-configuration support)
- Query based data export task now supports query editing
- Export in HTML format was fixed (extra line breaks)
- Columns auto-assign button behavior was fixed
- Execute process after data transfer supports multiple tables export now
- Mixed case columns auto-mapping was fixed
- Several problems with NullPointerException during editor opening were fixed
- Multi-row insert support was added
- Data transfer performance significantly improved
- Unnecessary commit/rollback in source connection were removed
- Table/column name case conversion was fixed
- Ambiguous column name mapping was fixed
- Value binding mode switcher was added (affects performance)
- Automatic columns mapping was fixed
- Import from files/relational tables into document oriented databases was fixed
- Column length detection was improved
- Excel import was fixed (NULL cells support was added)
- Special characters escape was fixed in HTML and JSON formats
- Data viewer:
- Record mode now supports multiple records view
- Double-click behavior in filters popup was fixed
- Spatial viewer now allows to copy point coordinates
- Source tables resolution was fixed for CTE queries and sub-selects
- Data filter for enum data types was fixed
- Data edit support for queries with joins
- Timestamp value render: timezone configuration was added
- Value transformers: save last transformer configuration
- Cell color highlight add/reset was fixed
- Data refresh was fixed in multi-row record mode
- SSO authentication:
- AWS Redshift SSO UI was improved
- Possibility to refresh SSO sessions was added
- Database navigator:
- Quick search now supports multiple object names
- Entity editor preferences for active tab configuration were improved
- Object rename dialog was fixed
- Metadata refresh UI was fixed
- Quick filter was fixed (show connected only)
- “Set connection from navigator” action behavior was fixed
- Open file: last opened folder is saved between app launches
- Object filter: special characters escaping was added
- Show tables from different schemas in a single list (optional)
- ERD editor:
- Properties panel was added for diagram elements
- Diagram drag tool was added
- Entity search UI was improved
- Diagram refresh now asks confirmation
- Table column navigation was fixed
- GraphML export was improved (notes, styles)
- Arrange diagram now respect grid alignment
- Export ERD in XML (.erd) format was added
- Cross-project entity drag-n-drop was restricted
- Forward engineering in entity diagrams (ERD) was added
- Tasks management view:
- Possibility to modify composite task inside another composite task was added
- Connection to RDS through IAM auth and SSH tunnel was fixed
- Ability to organize tasks in folders was added
- SSH tunnel: jump server support was added
- SQL Editor:
- Problem with active schema reset after connection invalidate was fixed
- Problem with focus lost on query execution was fixed
- Auto-completion for quoted identifiers was fixed
- Embedded SQL editors performance was greatly improved
- Problem with @set command was fixed
- Problem with Find/Replace window and NullPointerException was fixed
- Several problems with hanging UI after complicated SQL execute were fixed
- Auto-completion for identifiers with special characters was fixed
- SQL console now opens for selected schema
- Table columns are shown in original order for auto-completion
- Formatting of queries with embedded comments was fixed
- Local variables coloring was added (Sybase, SQL Server, MySQL)
- Output/Execution Log panels layout was changed
- Variables/parameters management panel was added
- SQL template variables completion was fixed
- Command for assigning query results to variable was added
- Action buttons tooltips were fixed (keyboard shortcuts)
- Extraction of queries from source code on paste: problem with line feeds was fixed
- Multibyte unicode numbers handler was improved (app hang fixed)
- Main windows title now shows proper information about the current editor
- PostgreSQL:
- Column data type editor was redesigned
- Infinity timestamps handler was fixed
- Array and interval data types editor was fixed
- Foreign tables DDL was fixed (missing OPTIONS)
- Cross-schema references rendering was fixed
- Data type fully-qualified name now used instead of scale/precision
- Custom data types (including geometry) resolution was improved
- Database backup/restore in custom format was fixed
- Database backup validates output file existence
- Bit string editor was fixed
- PG 13 backup/restore support was added
- Column rename DDL was fixed
- INSERT queries for OID data types were fixed
- Composite data type edit was fixed
- Additional PostGIS data type support was added
- Connection user role handle was fixed
- Multi-column foreign keys navigation was fixed
- Auto-completion for quoted identifiers was improved
- Active schema detection was fixed
- Floating point numbers formatting was fixed
- MySQL:
- Foreign key edit support was added
- Execution plan explain for CTE queries was fixed
- Use password escape was fixed
- Data import performance was significantly improved
- TLS 1.0 and 1.1 support added
- User password change was fixed
- Oracle:
- Table DDL was fixed (missing semicolons)
- Timestamp columns editor was fixed
- Function-based indexes column read was fixed (duplicated rows removed)
- Package loading performance was greatly improved
- View indexes reading was fixed
- TNS aliases resolution was improved
- Data export in SQL format was fixed
- View triggers read was fixed
- Now spatial data can be changed in Oracle using Shift+Enter or Value panel
- SQL Server:
- Cross-schema foreign keys support was fixed
- Detailed triggers metadata read was added
- Temporary table support was improved (metadata load, SQL auto-suggest)
- datetime data type DDL was fixed
- Active schema selector was fixed
- BEGIN/END blocks support was added
- Active schema selector was fixed
- User management was added
- MongoDB:
- Load column value enumeration was added
- BETWEEN criteria support was added
- HAVING on count(*) with alias was fixed
- Export from Mongo to flat file” attributes order bug was fixed
- Export from query to MongoDB/DocumentDB was added
- Redshift:
- Permission editor was added
- Problem with case-sensitive object names was fixed
- Data transfer performance was significantly increased (up to x10000)
- Tables and procedures DDL was improved (security definer was added)
- Stored procedures search and auto-completion was fixed
- Timestamp value editor was fixed (in native date formatting mode)
- Vertica:
- Flex tables metadata was fixed
- Function body parser was fixed
- Clickhouse:
- Table DDL was fixed
- Nested comments support was added
- Data edit (update/delete) queries generator was fixed
- Liquibase:
- Possibility to swap source and target database was added
- Compare types filter logic was changed
- Migration to Liquibase 4.4.3
- Liquibase Pro features support was added
- Snowflake:
- $$ parser was improved
- Driver configuration was fixed (JNA dependencies)
- DynamoDB: Using query statements for table data read with filters was added
- Yugabyte CQL:Invalidate/reconnect button bug was fixed
- Teradata: triggers and procedures DDL was fixed (extra linefeeds were removed)
- DB2 iSeries: schemas with long names loading was fixed
- Hive: constraints definition was fixed
- PrestoDB/Trino: data and metadata editors were improved
- SAP HANA: stored procedures results loader was improved (multiple cursors + atomic values)
- Firebird: query execution plan explain was fixed
- Athena: data editing was disabled