March 14, 2022

• 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