Changes since 22.2.5:

• Data editor:
  • Data export button UI was enhanced
  • Fetch all data and fetch size controls were returned to status bar
  • Lasso tool was added to spatial viewer
  • Bug in spatial viewer initialization was fixed
  • BLOB contents opening in external editor was fixed for MacOS and Linux
  • Browser-based image viewer control was fixed (null or invalid images handle)
• SQL editor:
  • Big SQL files support was improved (automatic disablement of syntax validation)
  • Table auto-completion tooltips UI was redesigned
  • Error on unassociated script opening was fixed
• General:
  • Default SSL truststore selection was fixed (it is now configurable)
  • Connection edit/create dialog performance was improved
  • Database server version is now shown in connections’ tooltip
  • Object delete dialog was redesigned
  • Database create button was removed from the connection dialog for databases which don’t support it
  • Security patch for packaged drivers (additional validation of zip archives was added)
• SSH: tunnel invalidation was fixed for SSHJ
• Tasks: problem with tasks operating with missing (deleted) tables was fixed
• Clickhouse: identifiers quoting was fixed (for non ASCII characters)
• Intersystems Cache: community driver was added again
• MySQL:
  • Hyperlinks navigation was fixed for procedures
  • Complex identifiers quoting was fixed
• Netezza: columns metadataread ws improved
• PostgreSQL:
  • Role create/edit command was fixed
  • PostgreSQL 15 support was improved (new data type category)

• Data editor:
  • Top and bottom action toolbars were redesigned
  • Action buttons now show hints
  • Data export toolbar button is now configurable
  • Image viewer was switched to embedded web-browser mode (configurable)
  • The issue with spatial data viewer was fixed (“no more handles” error)
  • Errors in virtual column definition now handled properly
  • “Count nulls” function was added to the Calc panel
• SQL editor:
  • Auto-completion with TAB key was implemented (!)
  • Hyperlink navigation was fixed for quoted identifiers and identifiers with spaces
  • The issue with keyword case auto-conversion was solved
  • Editor tabs now shows connection state icon (connected/failed)
  • Client-side commands prefix configuration was fixed
  • The issue with cursor position change on mouse right-click was resolved
• Data transfer: tables/column mapping dialog was improved, problems with target column name were fixed
• Database drivers:
  • License information was added to the most drivers
  • It is no longer need to restart DBeaver after driver settings change (bug in recent versions)
• Connections:
  • SSH jump servers support was added for SSHJ implementation
  • Network profile edit UI was fixed
  • Connection error messages
• General UI:
  • Dark theme support was added to XML editor
  • Dialog font settings is now applied to most popup dialogs
  • Database navigator quick filter now supports composite identifiers (thanks to @plotn)
• Clickhouse: driver version was updated, this resolves many issues with different data types support
• Oracle: DATE data type rendering is now configurable
• PostgreSQL: auth role editor was moved to the database level
• SQL server: it is now possible to disable TOP clause in select queries

• SQL editor:
  • SQL script active database/schema restore was fixed
  • Parameters prefix configuration was fixed
  • Issue with cursor change on context menu invocation was fixed
  • Option to disable all code completions/foldings was added
  • Auto completion inside SQL package was fixed
  • Table aliases auto-completion was fixed
  • SQL blocks auto-completion was fixed
  • SQL variables/parameters disable configuration was fixed
• Data editor:
  • Table columns resolution was improved for custom SQL queries
  • Hidden columns restore was fixed
• Data transfer:
  • Columns mapping dialog was redesigned and improved
  • Columns scale/precision mapping was fixed
  • Import from XML format was fixed
• Multiple MFA attempts were resolved (in drivers with MFA authentication)
• Tasks: variable value prompt was added (configurable)
• SSH tunnels: issue with private key password prompt was fixed
• RPM package: issue with remaining symlinks after uninstall was fixed
• UI perspective customization was fixed
• Clickhouse: driver version was updated (solves many data type conversion problems)
• PostgreSQL: inherited roles support was added
• Snowflake:
  • Java 17 support was added
  • Stored procedure and functions management was added
• SQLite: table column delete was fixed

• Data editor:
  • Value display format option was added to grid data view
  • Dictionary view panel now saves its ordering state
  • Row number in the record mode was fixed
  • Ability to open external editors for BLOB values was added
• Database backup: variable ${schema} was added
• SSH:
  • Problem with redundant password prompt was fixed
  • Tunnel config tab is now hidden for databases which don’t support SSH
• Drivers:
  • Driver version auto-update feature added
  • Issue with driver download dialog was fixed (non-clickable dialog)
  • Driver license info button was added to the connection edit page
• Data transfer:
  • Export to XLSX now support different modes for spreadsheet rows append
  • Description column was added to XLSX format (configurable)
  • An additional confirmation is shown if output file will be overwritten
  • Fallback directory was added for data export tasks
• Tasks:
  • Tasks viewer now shows tasks only for the active project
  • New task create command enablement was fixed
  • Running tasks are now checked and confirmation is shown on DBeaver app shutdown
  • Additional logging was added for tasks execution
• Clickhouse: SSL support was fixed
• Greenplum: table list read was fixed for recent GP server versions 6+.
• MariaDB: UUID data type support was fixed
• MySQL/MariaDB: problem with grave accent quoting was fixed
• Oracle: DATE data type rendering was fixed (time part was removed)
• PostgreSQL:
  • Problem with result sets fetch was fixed (OutOfMemory on big results)
  • Driver version was updated to 42.5.0 (security update)
  • Issue with numeric fields formatting in struct types was fixed
• OpenSearch driver configuration was added
• General:
  • Multi-connections behavior configuration was improved. Possibility to forcibly disable or enable additional metadata or SQL editor connections was added.
  • Additional localization was done in many places of application
  • We switched to a new Eclipse platform version (2022-09)

• Data editor:
  • “Hide all empty columns” action was added
  • References panel now has a button to open target table
  • Ordering by multiple columns was fixed
  • Filtering by spatial columns was fixed
  • URL transformer was fixed (original value edit is now supported)
  • LOB editor opening performance was significantly improved
  • SQL terminal now shows server output log
  • Column comments are now visible in record mode
  • Complex data types visualization was fixed for record mode
• Data transfer: bug in CSV export with custom header format was fixed
• SQL editor:
  • Problem with NULL column names in custom queries was fixed
• Database drivers:
  • Problem with driver jars re-download was fixed
  • It is now possible to disable Windows certificate storage usage
• Athena: driver version updated to 2.0.30
• Clickhouse: datetime64 data type support was added
• DB2: driver version was updated to 11.5.7
• Exasol: user list read read was fixed (thanks to @allipatev)
• Greenplum: prepared statements usage was disabled
• MySQL:
  • Default database client was changed onto version 8+
  • JSON columns now can be used in filters and as keys
• Oracle: schema full DDL was added
• PostgreSQL:
  • Problem with missing primary key in new tables was fixed
  • Table DDL for partitioned tables was fixed
  • Role comments are now visible/editable
• German localization was improved (thanks to @dan-schneider)

• Data editor:
  • URL transformer was fixed (for edit mode)
  • Grouping panel behavior was fixed
  • BLOB/CLOB viewer now shows smart warnings
  • NullPointer error was fixed in spatial viewer
• SQL editor: “Open in new tab” behavior was fixed
• Connections:
  • URL-based configuration support was added to PostgreSQL, SQL Server and Generic drivers
  • SSH user name is now optional (current user name is used)
  • SSH: problems with credentials prompt were resolved
• Data transfer: columns auto-mappings was improved (case-insensitive search)
• Diagrams: association creation was fixed
• Metadata editor: schema refresh performance was significantly increased
• Eclipse plugin: a lot of DBeaver-related warnings in error log were resolved
• i18n:
  • Chinese localization was improved (thanks to @fengchao)
  • German localization was improved (thanks to @bulldog98)
• Apache Hive: default schema detection was implemented
• Clickhouse:
  • SSL connection configuration support was added
  • UUID data type support was added
• Greenplum: proper client app name is now sent to the server
• MariaDB: problem with data transfer was fixed
• PostgreSQL: box data type support was improved
• SQL Server: problem with sequence value selection was fixed
• Vertica: default driver upgraded to version 12
• Many minor UI bugfixes

Changes since 22.1.5:

• Data editor:
  • Embedded browser (Edge vs IE) configuration was added
  • Custom data types rendering in record mode was improved
  • Console viewer toggle was fixed on Linux/MAcOS
  • Arrays view/edit UI was improved
  • Multidimensional arrays support was fixed
• Data transfer:
  • Column auto-mapping was fixed for databases with different identifiers case
  • Problem with old configuration load was fixed
  • Statistics calculation was fixed
• SQL editor:
  • Query parser was fixed (issue with single line comments in select items)
  • Screen coloring by connection type was fixed
• SSH:
  • SSHJ now is the default tunnel implementation
  • SSHJ version was upgraded, ASN1 decoder was added
• Connection:
  • Issue with double authentication in web browser was resolved (all drivers with MFA auth)
• Clickhouse:
  • Boolean data type support was added
  • Issue with timestamp data edit was resolved
• Firebird: overloaded procedures loading issue was resolved
• MS Access: diagram loading was fixed
• Oracle: password expiration warning was added
• PostgreSQL:
  • Extra options were added to explain plan dialog
  • Data type constraints loading was improved
  • Data type DDL generation was fixed

• SQL editor: script to connection association problem was fixed
• Data editor:
  • Major memory leak in data editor was fixed
  • Issue with grouping panel cleanup was resolved
  • Hex editor now respects read-only status of columns
  • Find/replace dialog now respects focused control
• General:
  • Issue with connection configuration load and edit was fixed
  • Dialog buttons layout was fixed in different dialogs
  • Authentication profiles configuration UI was fixed
• SQL Server:
  • View definition read was fixed for Azure databases
  • nvarchar/nchar column length detection was fixed
• MySQL: issue with numeric schema names was fixed
• Oracle:
  • Trigger DDL was fixed (CREATE keyword)
  • Data type DDL generation was fixed
• PostgreSQL: filters for composite data types were fixed

• Data editor:
  • Dangerous operation detector was improved (delete … returning)
  • Export of sorted rows was fixed
  • Status messages formatting and UI were improved
  • Filter by enum value was fixed
  • Collection editor was improved (UI in value panel)
  • Problem with statistics tab open was fixed
• Console view:
  • Non-SELECT queries support was added
  • Errors messages are now printed in console
• Driver editor: possibility to set property value to NULL was added
• SQL formatting settings save and preview was fixed
• Data transfer: task settings loading was fixed
• Azure SQL Server, Babelfish: multiple databases support was redesigned
• Clickhouse:
  • Table list load was fixed for older server versions
  • Data type mapping was improved for cross-database data transfer
  • Multirow insert support was added
  • 64-bit integers support was fixed
• H2: table metadata and DDL read was fixed
• PostgreSQL, CocroachDB:
  • Row security policy support was added
  • PgPass authentication now support SSH hosts and host redefine
  • Routines privileges DDL was fixed
• General UI:
  • Default embedded browser was changed to Microsoft Edge
  • Properties editor: value save on focus change was fixed
  • Tip of the day dialog layout was fixed (thanks to @troizet)
  • Many minor UI bugs were fixed