21.2.0

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