21.1.0

June 7 2021
Changes since 21.0:
  • General improvements:
    • Legacy status icons were updated
    • Application launch time was reduced
    • Automatic version upgrade: app restart procedure was improved
    • Application icons were updated
    • Dark theme support was improved (Windows 10 and GTk)
    • AWS profile bug was fixed
    • System notifications support was added on Linux
    • Metadata search now supports search in comments
    • Now all fields are displayed in AWS profile
    • Bundled Java updated to version 11.0.11
    • We migrated to Eclipse 2021-03 platform
    • Eclipse plugin: bug with redundant .dbeaver folders was fixed
    • RMI server was fixed (no more public port listeners)
    • Google Spanner driver configuration was updated
    • APM Jenifer driver configuration was added
    • DuckDB driver configuration was added
    • Many minor UI bugs were fixed
  • Data editor:
    • Column filter UI was improved (value count column)
    • Extra configuration was added to SQL script generator
    • Better support of IE browser in the spatial viewer (GIS)
    • Virtual columns support (rows add/delete) was fixed
    • Cells selection was fixed (MacOS)
    • Automatic app version upgrade was implemented
    • Notification popup rendering in dark theme was fixed
    • Perspective customization UI was fixed
    • Find/replace dialog was improved
    • Virtual unique key create dialog was redesigned
    • References panel was fixed for custom SQL queries
    • Selected rows highlight was fixed
    • Bug with overlapping timestamp and FK values was fixed
    • Find/replace dialog now respects number formatting
    • BLOB viewer shows error dialog on data load errors now
  • Metadata editor:
    • Column delete now checks for dependent objects
    • Constraint/index create command now available in the columns edit tab
    • Problem with deleted object dup was fixed
  • Data transfer:
    • Possibility to disable foreign keys was added (PostgreSQL, Oracle)
    • Numeric data types mappings were improved
    • “Skip all errors” button added in the error dialog
    • Export to flat files now supports columns configuration
    • BOM support was added to CSV import
    • Insert/replace method configuration was fixed
    • Cross-database column data type mapping was improved
  • Data viewer:
    • BLOB viewer now respects content type of cell value
    • Grouping panel: queries with trailing comment now handled properly
    • Custom resultset ordering support was fixed
    • Copy As: format configuration editor was added
    • Extra configuration for filter dialog (performance)
    • Sort by column as fixed (for small fetch sizes)
    • Case-insensitive filters support was added
    • Plaintext view now support top/bottom dividers
    • Data editor was fixed (when column name conflicts with alias name)
    • Duplicate row(s) command was fixed for multiple selected rows
    • Edit sub-menu was returned to the context menu
    • Columns auto-size configuration was added
    • Dictionary viewer was fixed (for read-only connections)
    • Current/selected row highlighting support was added (configurable
  • Connection management:
    • Automatic ending of idle transactions was added
    • Network profiles configuration page was fixed
    • Filters in the connection selector dialog were fixed
    • Connection recovery was improved
  • SSH:
    • SSH Agent support was fixed
    • SSHJ extension install was fixed
    • SSH tunnel infinite reopening cycle was fixed
  • CLI:
    • ReuseWorkspace parameter handler was fixed
    • AWS SSO using CLI integration support was added
  • Database navigator:
    • Quick schema filter was fixed
    • Metadata changes save: single transaction processing was improved
    • Delete object(s) dialog UI was improved
    • Database statistics in simple mode was fixed
    • Legacy search icons were updated
    • Legacy edit toolbar and main toolbar items was removed
    • Columns reorder now supports multiple columns
    • Object lookup function now supports search in comments
    • DBeaver main menus are visible in DBeaver perspective only
    • Boolean properties editor behavior was redesigned
    • Broken shortcuts (F2, F4, etc) in object editor were fixed
    • Redundant help icons removed from standard dialogs
    • Language change validation and documentation was added
    • Quick filter now supports triggers
  • ERD:
    • Export as image: image cropping problem was fixed
    • Export in SVG format was improved
    • Diagram save now forces UTF encoding
    • Tables coloring was fixed
    • Show/hide system object option is now respected
    • Print command enablement was fixed
    • Property view support was fixed, entity/attributes context menu was fixed
  • GIS (spatial) data viewer:
    • Map position preserve after tiles change
    • Support of geometries with Z and M coordinates was added
    • Postgis: DDL for 3D geometry columns was fixed
    • Presto + MySQL geometry type support was added
    • BigQuery now supports spatial data viewer
    • Binary geo json support was improved
    • Geometry export was fixed (SRID parameter)
    • Tiles definition editor was fixed (multi-line definitions + formatting)
  • Data compare:
    • Marking arrays always as modified was fixed
    • Using isolated context by default was fixed
    • Bug with comparing data from the same database was fixed
  • VQB:
    • Duplicating aliases was fixed
    • Aliases cases configuration was added
    • Moving down button availability by sorting expressions was fixed
  • Task scheduler:
    • Now it is possible to schedule a task if start date or time is set in the past
    • Scheduler and workspace corruption was fixed
    • Now Task schedule information is updated after changing it without the need to manually refresh tasks
    • Support for national date formats and unicode was added
  • Project settings: corrupted folders configuration fix was added
  • SQL Editor:
    • Script selector popup panel UIX was improved
    • Hex constants and scientific numbers formatting was fixed
    • Columns alias generation was improved
    • Multi-line comments support was fixed
    • Configuration of open editor action was added
    • Smart auto-completion of column values was improved
    • Problem with ambiguous column name resolution was fixed
    • Hyperlinks detection was fixed
    • Problems with SQL templates view freeze was fixed
    • SQL formatter of case and conditional operators was improved
    • Syntax highlighting for single and double quotes was fixed
    • SQL folding state is now saved for each script
    • Trim spaces command was added
    • Problem with double save/commit confirmations was fixed
    • Auto-completion for objects names with spaces inside was fixed
    • Database objects hyperlinks rendering was fixed
    • Collapsed results panel expand was fixed
    • Auto-completion was fixed for table aliases, joins and asterisks
    • Smart commit now ignores EXPLAIN statements
    • Big updated row count (>2gb) support was added
    • Output log enable/disable button was added
    • Problem with results tab collapse was fixed
    • Dummy NullPointerException and StackOverflowError errors were fixed
  • PostgreSQL:
    • PgBouncer support was fixed (problem with prepared statements)
    • Data types read queries were fixed for older (8.4 and earlier) versions
    • Role permissions editor was fixed
    • Infinity timestamp values support was added
    • Auto-generated columns support was added
    • Role name DDL was fixed
    • Serial data types selector was fixed
    • Column default value editor was fixed
    • Numeric arrays rendering was fixed (number formatting removed)
    • Array data types read was fixed
    • Schema data types read was fixed
    • Sequence editor was implemented
    • Data type rename support was added
    • Constraints and indexes support was added
    • Problem with constantly growing search_path was fixed
    • Fully-qualified table names in foreign keys DDL was fixed
    • PGPASS authentication now can be used with empty user name
    • NaN and Infinity numbers formatting was fixed
    • Data transfer: ON DUPLICATE query generation was fixed
    • Database size statistics was added (configurable, off by default)
    • CREATE DOMAIN DDL was fixed
    • User password change feature was added
    • Domain arrays support was fixed
    • Role DDL now contains permissions information
    • Sequences DDL was fixed
    • VARBIT data type support was fixed
    • Default database switch was fixed
  • MySQL:
    • Column editor was fixed (DEFAULT_GENERATED clause removed)
    • Index editor was added
    • User rename feature was added
  • Oracle:
    • Indexes were added to table DDL
    • Functions folder was added (in addition to Procedures)
    • Jobs support was added (read-only)
    • Data type compile action was fixed
    • Synonyms read was fixed for partitioned tables
    • Table triggers loading performance was improved
    • Trigger disable/enable tool was added
    • Procedure/function dependencies were added
    • Comments for views and view columns were added
    • Data type DDL was fixed for predefined types
    • Procedure body formattign was fixed (for encoded procedures)
    • Procedures/triggers/packages DDL statements processing was fixed
    • Synonyms search is now configurable
  • SQL Server:
    • Default delimiter was changed to ; instead of GO
    • Synonyms support was improved
    • Check constraints added to table DDL
    • Unicode string literals generation was fixed
    • MFA (multi-factor authentication) support was added
    • Calculated columns support was added
    • Extended properties were added to table DDL
    • Default precision and scale for numeric data types was fixed
    • View triggers support was added
    • Extended properties editor was added
    • New row insert for tables with calculated columns was fixed
  • MongoDB:
    • Dissapearance of altered cells was fixed
    • Nashorn was replaced with Rhino
    • OR expressions support was added
    • URL parser issues were fixed
  • Redshift:
    • Table permissions read in table DDL was fixed
    • Datashare objects support was added
    • Problem with read-only resultset was fixed
    • View columns metadata read was fixed, extra data type aliases were added
    • Redshift federated authorization support was added
    • Datashare objects support was added
  • Vertica:
    • Column comments read and update support was added
    • LIMIT clause support was improved
    • Table column create/edit was fixed
    • View constraints read was implemented
    • Unique key creation was fixed
    • Table columns read was fixed for older Vertica versions
    • Sequences support was added
    • View create/edit was fixed
  • Clickhouse:
    • Table data edit support was added
    • Tables and indexed create/drop DDL was fixed
    • Sybase IQ support (server version detection) was fixed
  • Firebird:
    • Procedure parameters’ default value read was fixed
    • View metadata read was improved
    • Data Virtuality driver was added
    • Preferences localization was updated
  • Teradata:
    • Triggers management was added
    • Views metadata read was fixed
  • Informix:
    • Foreign key DDL was fixed
    • SQL error position detector was added
    • Cross-database metadata read was fixed
    • Table statistics feature was added
    • Function parameters read was fixed
  • SAP HANA:
    • Smart completion was improved
    • Public synonyms read was added
    • Metadata object search was redesigned
    • Table columns was fixed for table names with special symbols
    • Hex literal formatting was fixed
  • Sybase IQ:
    • Server version detection was improved
    • SQL dialect support was improved
  • Snowflake:
    • Active catalog/schema selector was fixed
    • Drop procedure function was fixed
    • Metadata read was fixed for case-sensitive schema names
  • DB2:
    • Extra embedded routines support added
    • Stored procedures call generator was improved
    • BEGIN/END blocks support was added
  • MariaDB: TIME data type support was fixed
  • Athena: extra AWS regions added to connection dialog
  • SAP ASE: user function loading was fixed
  • Greenplum: DDL for replicated tables was fixed
  • Exasol: schema refresh was fixed
  • BigQuery: driver version was upgraded
  • DocumentDB: floating point numbers editor was fixed
  • Cassandra: bug with connection invalidation was fixed