22.0

March 14, 2022
Changes since 21.3:
  • General improvements:
    • Auto-close of idle connections option was added (configurable)
    • Bug with empty editor tabs after the restart was fixed
    • Redundant logging during connection context menu opening was fixed
    • Various database tools: NullPointer error in task wizard was fixed
    • Several minor UI bugs were fixed
    • Files drag-n-drop (between DBeaver and OS file explorer) support was added in the project explorer
    • SSHJ implementation now included in DBeaver Community by default
    • Problem with DBeaver crash was fixed (when workspace path contains spaces)
    • Command-line support: default connection now set for opened SQL scripts
    • Resource manager: cross-project connection drag-n-drop was fixed
    • SQL query generator: string values quotation was fixed
    • BLOB/binary editor: problem with changes saving in hex editor was fixed
  • SQL editor:
    • The issue with app freeze on very complex queries executing was fixed
    • Parameters binding dialog now supports multiline editor
    • Script selector panel UI was fixed
    • New scripts now position the cursor to the end of the script
    • Bug with missing resultset tab focus was fixed
    • Script selector panel now supports “All connections” mode
    • Multiple result tabs refresh was fixed
    • Import file now supports multiple files selection
    • Client-side commands (@set, @include) parser was fixed
    • Auto-completion fix for SELECT .. INTO queries
    • Auto-completion now uses the “hippie” completion algorithm by default
    • Copy as source code: Delphi format was fixed
    • “Copy selected query” command was added
    • Variables and parameters deletion was improved
    • SQL formatting was fixed (redundant empty lines eliminated)
    • Tab context menu was improved (additional items were added)
    • Code folding restore was fixed
    • Multi-cursor edit mode was added
    • “hippie” auto-completion support was added (beta)
    • Auto-completion for tables without alias was fixed
    • Script file name template support was added
    • Binding multiline parameters were improved
  • Data editor:
    • Columns drag-n-drop support was fixed (Linux)
    • Dictionary table editor now supports default column names customization
    • Connection-specific data formatting settings save was fixed
    • Row fetch size now can be set to a small value (up to 1 row)
    • Search in data grid with enabled numbers formatting now works properly
    • Date/time editor calendar presentation now shows proper error messages
    • Data loss on resultset scrolling confirmation was added
    • Option to highlight selected cell value was added
    • Value view panel now supports shortcuts to switch between data formats (configurable)
    • Date/time editor now supports calendar-like UI
    • Column names quoting was fixed in filter clauses
    • Filter for array columns was fixed
    • Gis viewer: SRID switch behavior was fixed
    • Save/Cancel button are now disabled during the data save process
    • Column filter now uses exact match for numeric values
    • Status message now shows execute timestamp
    • Advanced copy now respects quoted column names
    • Auto-completion was fixed in the filters panel
    • XML auto-format was fixed (elements sort was disabled)
    • Filter by column with an alias was fixed
    • Numeric type transformer was fixed
    • Extra tab close action was added (close to the left/right)
    • Arrays presentation in record view was fixed
    • Сolumn filters edit dialog UI was improved
    • The bug with refreshing all tables in the navigator regardless of the changes was fixed
    • Potential XXE vulnerability in XML was removed
    • The bug with display nested attributes in JSON records in grid view was fixed
  • Metadata editor:
    • Table DDL is now auto-updated after new table editing
    • The bug with refreshing objects after rename was fixed
    • Disable grouping panel bug in NoSQL databases was fixed 
  • Navigator:
    • Bug with connection element expansion during connect was fixed
    • Table statistics refresh was fixed
    • Columns configuration (visibility, size, order) save/load was improved
    • “Expand on connect” now expands both database and schema
    • Column reordering now supports multiple columns
    • Object filters now support backslash escape
    • Multiple minor UI bugs were fixed
    • Tree state loading was fixed
    • Database object comments render was added (configurable)
  • Data transfer: 
    • Table re-create option was added
    • XLSX import was improved (problem with column mapping was fixed)
    • Import from CSV now uses approximate column length calculation
    • Append to file mode was fixed
    • Export of columns of composite data types support was added
    • Popup message boxes were replaced with taskbar notifications
    • CSV parser performance was significantly improved
    • Identifiers case configuration was added in SQL export format
    • Option to append results to an existing file was added
    • Date formatting was fixed for JSON format
    • Variables support in saved tasks was fixed
    • Support of arrays import from CSV was added
    • The issue with export wizard buttons enablement was fixed
    • The issue with sending results by email for Outlook users was fixed
    • Incorrect columns names mapping with import XLSX was fixed
  • Driver management:
    • New Java11 modules were added to support new JDBC drivers (java.net.http)
    • Drivers copying was fixed (keep advanced driver settings)
    • Maven artifacts edit dialog was fixed
    • Maven artifacts settings save/load was fixed
    • Maven artifacts import/edit UI was improved
    • Denodo driver configuration was added (thanks to @scruz-denodo)
  • Session manager: 
    • Column grouping was added
    • Group records by any arbitrary column wad added
  • Data compare: 
    • The issue with saving column mappings was fixed
    • A hint that SQL preview shows only the first 1000 rows was added
    • The incorrect script in preview SQL diff if column mapping was changed was fixed
    • The bug with updating changes in the Changes diagram was fixed
  • Connection: 
    • Global user authentication API was added 
    • Password field duplicates username in the Add new SMTP profile dialog was fixed
    • The issue with lost connections data after refusing to re-log with the wrong master pass input was fixed
    • The issue with removing database credentials after changing the project password  was fixed
    • The issue with removing project passwords if properties of the project are opened and saved without changes was fixed
    • The issue with set recovery questions for Master password via Connection dialog was resolved
    • A local client isn’t present in connection settings bug was fixed
    • Connection lock password support was fixed
  • Visual Query Builder:
    • The issue with appearing NPE in case of switching to VQB during query parsing was fixed
    • The bug with adding count condition to the expression on every grouping setting change was fixed
  • Generic driver: 
    • ClassCast error during connection instantiation was fixed
    • Support sequences and synonyms edit/rename was added
  • PostgreSQL:
    • Event triggers support was added
    • Greenplum, EDB: local clients configuration was added
    • Google Cloud driver support was fixed (driver dependencies)
    • Functions signature now include out parameters
    • GIS viewer for columns in complex data types was fixed
    • CIDR data type support was added
    • Deferrable foreign keys create was fixed
    • Identifiers quoting was added for table DDL
    • Database backup now supports “drop if exists” option
    • Row replace method “ON CONFLICT DO UPDATE” support was fixed
    • Error (NullPointerException) in explain execution plan was fixed
    • Role DDL was fixed (connection limit)
  • Task scheduler: 
    • The issue with scheduled task remains in an OS scheduler in case of a project deletion was fixed
    • The issue with launching tasks with the same name from different projects was fixed
    • The issue with producing temporary files when using cron was fixed
  • Scheme compare: 
    • The bug with transforming SMALLSERIAL column to SMALLSERIAL GENERATED BY DEFAULT AS IDENTITY was fixed
    • The issue with the disability to stop the compare process was resolved
  • Task manager: 
    • Statistics for running Composite tasks and Compare tasks was added
    • Summary about successful task run was added
  • Cloud explorer: 
    • Incorrectly place Name title in configuration was fixed
    • The bug with the display folder for a new cloud configuration was fixed
  • Dashboard view: 
    • The problem with memory leaks was resolved
    • The bug with the Dashboard view connection to the database was fixed
  • SSH tunnel:
    • Advanced tunnel configuration UI was improved (window auto-resize)
    • Tunnel test dialog now supports test interruption
    • Private key configuration was fixed for jump servers
    • known_hosts support and validation of target host before connect were added
  • macOS: application termination on detached window close was fixed
  • Localizations:
    • Simplified Chinese localization was significantly updated (thanks to @bianyun1981)
    • Italian localization was updated (thanks to @capitanfuturo)
    • Japanese localization was fixed and updated (thanks to @yoshinorin)
  • Trino: problem with corrupted navigator tree after long connect was fixed
  • Firebird: columns autoincrement option editor was added
  • Clickhouse:
    • A new driver was added. The old driver was renamed Legacy.
    • LIMIT clause support was added for data read queries
    • The issue with access to read-only connections was fixed
    • Typed arrays support was added
  • Exasol: execution plan save/load was implemented
  • MySQL/MariaDB: permission editor was redesigned, grant option support was fixed
  • MariaDB:
    • New driver (3.x) support was added
    • Packages and sequences support was added
  • Oracle:
    • Table constraints load performance was significantly increased (thanks to @skybber)
    • PL/SQL syntax support was improved (packages and procedures parser was fixed)
    • WITH clause parser was improved
    • The native quoting parser was fixed
  • Redshift:
    • New view create was fixed
    • Driver version was updated to 2.1
    • The issue with cannot creating a role via UI was fixed
  • Eclipse plugin: 
    • History navigation shortcuts support was fixed
    • The issue with throwing an exception in the latest DBeaver plugin 21.3.1 was fixed
  • SAP HANA: 
    • Hyperlink navigation was fixed
    • Public schema presentation was changed (thanks to @kai-morich)
    • SSO was added
  • SQL Server: 
    • Database metadata read fix (problem with is_external column)
    • SQL Server Synapse support was improved (metadata reading)
    • External tables support was added
    • Column data type modifiers generator was fixed
    • The bug with incorrectly showing job objects was fixed
    • The issue with the display Administer tab was fixed
  • AWS:
    • AWS Athena: driver version was updated, an issue with column filters was resolved
    • AWS S3 browser was added
    • AWS Elasticache services support was added
  • Babelfish:
    • Synonyms, sequences, and triggers were removed from the metadata navigator
    • Cross-database access was disabled, only the default database is visible
  • Derby: check constraints support for remote server driver was fixed
  • DB2: table organization property was added
  • PostgreSQL, Greenplum, Redshift:
    • Permission editor UI was fixed (redundant GRANT/REVOKE commands merge)
    • Composite data types support was fixed
    • Execution plan rendering was fixed (“Parallel” scan)
    • Partition tables statistics read was fixed
  • SQLite: table foreign keys editor was added
  • Cassandra:
    • Support secondary indexes for Cassandra was added
    • The issue with creating a new table in data import was fixed
    • The issue with import from file to table with BLOB column was fixed
  • MongoDB: 
    • Add support for filtering by NULL
    • The issue with the wrong column type when the first row contains NULL was fixed
    • Support mongo shell queries for MongoDB 4+ was added
  • MaxDB: The issue with table cache load after data transfer was fixed
  • Liquibase: Added option to disable permanent objects names quoting in the result DDL 
  • Couchbase: 
    • The bug with the column header filter creating the wrong query was fixed
    • The bug with appearing data exported with selected rows only as NULL was fixed
  • Redis: 
    • The bug with the execution SELECT command was fixed
    • Sorting key by name was added
    • Add default database setting
    • Key divider dropdown was fixed
    • The issue with the visible of keys in Elasticache was fixed
    • The bug with working the key hierarchy was fixed
  • Teradata: 
    • Database navigation redesign
    • TLS driver support was added
  • Snowflake: Support Key Pair Authentication was added
  • New database drivers:
    • Apache Calcite Avatica
    • Apache Druid
    • Apache Kylin
    • Salesforce CDP
    • EDB
    • Denodo