21.3

December 6 2021
Changes since 21.2:
  • General improvements:
    • Dark theme: bug with mismatching colors was fixed on MacOS
    • Problem with missing file extensions was fixed (Windows)
    • Problem with SQL script preview dialog was fixed on MacOS
    • Error “PKIX path building failed” was fixed on Windows (OS certificate storage is now the default)
    • Full-text search now keeps original table filters
    • Currupted projects auto-recovery feature was added
    • Legacy error/warning icons were replaced with new ones
    • Task management UI was redesigned for data transfer, admin tasks and SQL tasks
    • DBeaver for MacOS X for M1/Silicon/ARM was released
    • Generic drivers: problem with wrong table schema recognition was fixed
    • Windows installer: default install location was changed to current user
    • UI rendering for HighDPI monitors was fixed
    • Properties editor UI was fixed (possibility to delete custom property)
    • Tables UI was fixed for multiline cells (Linux)
    • Bundled Java was upgraded to OpenJDK 11.0.12
    • Command-line support: running app instance detection was fixed
    • Booleans view was improved (font weight is now configurable)
    • SSL encryption algorithms were replaced by BouncyCastle
    • TLS 1.0/1.1 support was fixed
    • XML-parser related security issues were fixed
    • Base platform was changed to Eclipse 2021-09
    • Task wizard buttons enable/disable was fixed
    • SSH tunnel test: system variables support was added
    • Issue with installing the DBeaver extension on older Eclipse versions was fixed
    • The confirmation dialog was redesigned
    • Indexes tab in Object Editor was removed
    • EE entities configurations were improved
    • JRE binaries on Windows was improved
    • Security: Potential XXE vulnerability in XMLUtils was removed
    • Document view: define data type option for document fields was added
    • Visible of existing foreign keys in case Show all tables in a single list is enabled was fixed
    • New option: Configure the default SRID for a specific datasource
    • Added a shared workspace for users
    • Working of checkboxes for the group selection on the Regions tab was fixed
    • CSV: Database metadata is now read-only
  • Data editor:
    • Expression parser was fixed in grouping panel
    • Geometry values copy-paste operation was fixed
    • Gis viewer: object tooltips were fixed
    • Problem with invalid SRID was resolved
    • Copy from row above/below command was added
    • JSON function were added to virtual columns definition
    • Image viewer flickering was fixed
    • Row count calculation was fixed (bug with distinct select)
    • Composite data types support was fixed (arrays of composite type)
    • Dark theme support was improved
    • Booleans editor rendering was fixed
    • Find/replace for BLOB/CLOB columns was fixed
    • Data editing in zset with replacing and creating row was fixed
    • Incorrect work of Save button for JSON documents was fixed
  • Data viewer:
    • Filters configuration dialog UI was fixed (MacOS)
    • Found occurrences highlighting was fixed (find/replace)
    • Problem with long columns resize was fixed
    • Problem with overlapping column icons was fixed
  • Data compare:
    • Changelog, progress bar, and SQL diff generation were added
    • Rows treating was improved
    • Refactor data compare editor was added
    • Mapping & Visibility dialog for columns was improved
    • Column mappings saving was fixed
  • Version auto-upgrade:
    • Incorrect package type detection was fixed
    • Incorrect architecture (M1/ARM/x86) detection was fixed
  • ERD:
    • Diagram viewer: connections auto-layout was fixed
    • Palette icons were updated
    • Dark theme support was improved
    • Columns search was implemented
    • Reverting changes option after disabling edit mode was fixed
    • Generating the wrong script for constraints on edit mode was fixed
    • The highlighting button on edit mode was fixed
    • The table creating option was improved
    • Showing connections when creating foreign keys issues was fixed
  • Driver editor:
    • URL template edit support was added for all drivers
    • Maven artifacts import/edit UI was improved
  • SQL editor:
    • New script template was added (configurable)
    • Tooltip for execution plan explain tab was fixed
    • Client-side command @include was fixed
    • Bug with hanging SQL parser on long queries was fixed
    • Auto-completion was fixed for a number of cases
    • Schema selector in SQL consoles was fixed
    • Statement text extraction was fixed in “block selection” mode
    • Schema detection for auto-complete was fixed
    • Intelli-sense proposals detection was fixed for queries with variables
    • Files copy into new project was fixed
  • Data transfer:
    • Export results and send them to email automatically
    • Simplified the preferences dialog and improved performance
    • Bulk load (COPY) support was added for PostgreSQL
    • Cross-database data type mapping was improved for PostgreSQL, Oracle and Sybase
    • Additional variables were added for file name patterns (${year}, ${month}, ${day}, etc)
    • Several fixes in data transfer wizard
    • Data export now respects columns order and visibility
    • Exported files are highlighted in OS file explorer
    • XML export/import support between Oracle and PostgreSQL was added
    • CSV parser was fixed (unexpected input file read termination)
    • CSV export format: column header format configuration was added
    • CSV export: quotation of NULL values was fixed
    • Import from XML: column mapping was improved
    • Additional variables were introduced for target file name pattern
    • Redundant table name quotation was fixed
    • Output files split option was fixed (problem with extra empty file)
    • XLSX format: column values are now trimmed to 32kb
    • CSV driver: aggregated functions support was fixed
    • Wrong column mappings when importing from XLSX was fixed
    • Import from XML: columns mapping was improved
    • New feature: you can export the results and send them to your email
  • Metadata editor:
    • Editor flickering after mode change was fixed
    • Navigator refresh was fixed
    • Schema-level index create was fixed
    • Administer tab to a database object was added
  • SQLite:
    • Table indexes create/delete support was added
    • Driver updated to version 3.36
  • SQL Server:
    • Auto-completion and hyperlinks were fixed in stored procedures
    • Auto-completion for synonyms was added
    • Square brackets escape was fixed
    • Upgraded SQL Server driver
    • MFA authentication (browser-based) works on MacOS and Linux was improved
  • Visual Query Builder:
    • Sort column alphabetically option was added
    • Select all columns option was added
    • The problem with opening the Joins tab if tables don’t have a relation to query was fixed
  • ODBC:
    • App crash on editor open was fixed
    • App crash during database connection was fixed for several drivers
  • Navigator:
    • Quick filter value is now saved between application starts
    • Command line handler was fixed (problem with -reuseWorkspace)
    • Boolean editor UI was fixed (trimmed labels)
    • UI freeze during metadata editors re-open was fixed
    • Database metadata refresh speed was significantly increased
    • Create new connection from JDBC URL command was added
    • Objects from datashare seeing r issue was fixed
  • Clickhouse:
    • Table statistics read was fixed (thanks to @den-crane)
    • SQL dialect definition was improved (extra keywords)
  • QMDB:
    • QMDB working issue with the latest H2 driver was fixed
    • Updated QMDB schema to support a multi-user environment
    • QMDB backup issues was fixed
  • Redshift:
    • Geometry edit support was added
    • Driver 2.x support was fixed (proper data types handle was added)
    • Table truncate command was fixed
    • Session and lock managers were added
  • Snowflake:
    • Driver version was updated (fixes problems with MFA)
    • Saving the primary key issue was fixed
  • Sybase:
    • Database statistics info was added
    • “Encrypt password” option was added to the connection page
  • MySQL/MariaDB:
    • Tables metadata load performance was improved
    • Backup/restore wizard UI was fixed
  • Greenplum:
    • Permission editor was fixed for older GP versions
    • Session and lock managers were added
  • PostgreSQL:
    • Database structure was redesigned (all cluster-level entities moved to the top level)
    • Multirange data types support was added
    • Exclusive schema filters support was fixed
    • Support of JSON columns in unique keys was added
    • Data import via hidden Copy command
    • Version 13 support was improved (rare problem with data types metadata read was fixed)
    • Composite data types support was improved
    • Database backup wizard UI was fixed
    • Foreign key settings edit was implemented
    • Array value parser was fixed
    • Roles names quote was fixed in grant/revoke commands
  • Exasol:
    • Extra keywords were added to SQL dialect
    • Geometry data types support was fixed
  • HANA:
    • Begin/end blocks parser was fixed
    • Alter table syntax was fixed
  • Netezza:
    • Table editor for non-default database was fixed (problem with wrong schema recognition was resolved)
    • Import/export to/from non-default database support was added
    • Create user list option was added
    • Sequences renamed option was fixed
    • Show owner in full table name option was added
    • Netezza schema compare issues was fixed
    • “Show all databases” settings was added to connection page
  • Oracle:
    • Full-text search for functions and procedures was implemented
    • Option “show only current schema objects” was implemented
    • Updating spatial data via DBeaver UI was added
    • Oracle session manager was improved
  • Teradata:
    • Default schema detection was fixed
    • DBeaver supports special extensions for Teradata
    • Support for triggers: now, you can rename and delete them, as well as add or change comments to them
    • You can TLS when connecting to Teradata
    • Updated the driver to version 17.10
  • MongoDB:
    • Colorize data types was fixed
    • Performing Invalidate/Reconnect to the database was improved
    • ‘Retry Reads’ and ‘Retry Writes’ options support via DBeaver UI
    • Export data with enabled “selected columns only” issue was fixed
    • SQL generation issue was fixed
  • Liquibase:
    • Incorrect changed object status was fixed
    • License Key activation Liquibase Pro via DBeaver UI was added
  • Couchbase:
    • Performing Invalidate/Reconnect was improved
    • Export data with enabled “selected columns only” issue was fixed
  • Redis:
    • Problem with working multi-character key dividers was fixed
    • Performing Invalidate/Reconnect was improved
  • Athena:
    • Show all tables in a single list option was fixed
    • Database native authentication was added
    • Database metadata is now read-only
  • CockroachDB: query results limit was added
  • DynamoDB: support tables names with special characters in table name
  • Hive: backslash escape support was added
  • Oracle/MariaDB: Authentication profiles list was improved
  • New databases:
    • Babelfish
    • OceanBase