September 12, 2022

• General improvements:
  • Dummy error messages after saving preferences were eliminated
  • UI was improved for non-applicable columns in the metadata editor
  • The issue with main window minimize was fixed on macOS
  • The issue with connection configuration load and edit was fixed
  • Dialog buttons layout was fixed in different dialogs
  • Authentication profiles configuration UI was fixed
  • SQL formatting settings save and preview were fixed
  • The issue in the full-text search wizard (NullPointer) was resolved
  • Database full-text search: page UI was improved, long lists paging was added
  • SSH configuration page now has scrollbars on small monitors
  • Many minor UI bugs were fixed
  • License check timeout was fixed
  • DC authentication was improved
  • Displaying sequences from all schemas was fixed
  • NPE on table rename in ERD edit mode was fixed
  • Links to colors and fonts in preferences were added
  • The connection could be created with an empty DBeaver profile
  • Eclipse: The bug with the display of navigator and projects was fixed
• General UI:
  • Project configuration load visualization was added
  • Tab quick search was improved (find by substring, fuzzy search)
  • The 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
• Data Editor:
  • Arrays and multi-row data types visualization was added (beta version)
  • Excel-like behavior for the inline editor was added (shift row down, configurable)
  • The bug in the grouping panel was fixed (“duplicates only” option)
  • Inconsistency of NULL value representation in calendar edit control was fixed
  • Bug with inline editor activation with double-click was fixed (gtk)
  • Bug with inline editor deactivation with single-click was fixed (macOS)
  • Arrays and structure data types visualization was fixed and improved
  • Console-like query results viewer was added
  • Support of column aliases in the aggregate panel was fixed
  • The Dictionary panel now supports pagination
  • Pinned columns scrolling was fixed (thanks to @troizet)
  • Binary/hex data viewer was fixed (crash on macOS)
  • Major memory leaks in the string editor panel were eliminated
  • Collection string representation was improved
  • The issue with data read performance was fixed
  • The 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
  • The collection editor was improved (UI in value panel)
  • The issue with the statistics tab open was fixed
  • A major memory leak in the data editor was fixed
  • The issue with grouping panel cleanup was resolved
  • Hex editor now respects the read-only status of columns
  • Find/replace dialog now respects focused control
  • Embedded browser (Edge vs IE) configuration was added
  • Custom data types rendering in record mode was improved
  • SQL Terminal toggle was fixed on Linux/macOS
  • Arrays view/edit UI was improved
  • Multidimensional arrays support was fixed
• Data transfer:
  • Export with “selected columns only” was fixed (wrong column mapping)
  • Target DDL generator now checks for existing non-table objects
  • Export in SQL INSERT format now uses proper table name for complex custom tables
  • Header configuration for CSV and TXT formats was added
  • The issue with super-long CSV files import was fixed (row number visualization)
  • Target file name generation for custom SQL queries was fixed
  • Settings save/load was fixed for saved tasks
  • Target table properties (such as engine, charset, etc) were added in the import wizard
  • CSV import was fixed for files with the invalid value quotation
  • Import from string to geometry columns was fixed
  • task settings loading was fixed
  • Column auto-mapping was fixed for databases with different identifiers case
  • The issue with the old configuration load was fixed
  • Statistics calculation was fixed
  • Make it possible to set the FROM address in SMTP profiles
  • The option to send data export results by email if they are not empty was added
  • Exporting data formatting in PostgreSQL and Microsoft SQL Server 2019 was improved
• SQL editor:
  • Generate DDL from resultset command was added
  • Re-execute queries from the execution log were supported
  • Schema selector was fixed for databases that don’t support schema change (Sybase, SQL Server)
  • Parameters binding for DDL queries were fixed
  • Query error highlighting was improved (+now it can be disabled)
  • Query formatter was fixed (for identifiers starting from digit)
  • Compact formatter was improved
  • The issue with auto-completion of materialized view create/alter queries was fixed
  • Autocomplete of variables with prefix @ was fixed
  • The issue with columns aliases in the grouping panel was resolved
  • SQL console text now can be saved as project script
  • Script to connection association issue was fixed
  • Query parser was fixed (issue with single line comments in select items)
  • Screen coloring by connection type was fixed
  • A button to edit and resend queries was added
• Visual Query Builder:
  • The conditions tab modifies the pasted value and doesn’t add quotes
  • Speсific Self Join isn’t displayed in VQB
  • Elements can be added to VQB without a connection
  • Natural Inner, Left, Right Join support was added
  • The issue with operand values starting with symbols was fixed
  • The issue with switching to text SQL editor and back and deleting objects was fixed
  • The bug with the join presentation on the diagram was fixed
  • Incorrect default join for tables without relation was fixed 
• SQL Terminal:
  • Non-SELECT queries support was added
  • Errors messages are now printed in the console
• Tasks:
  • Nested task folders support was added
  • Folders rename support was added
  • SQL script execute task was fixed (NullPointer error)
  • Task folder renaming ability was added
  • The ability to run tasks from CLI in password-protected workspaces/projects was added
• Connections:
  • Nested task folders support was added
  • The new connection name pattern can now be customized
  • Multiple connection mode was disabled for non-relational databases
  • The issue with double authentication in a web browser was resolved (all drivers with MFA auth)
• Driver editor: possibility to set the property value to NULL was added
• Metadata editor: columns auto-size command was added to the context menu
• Schema compare: Compare/Migrate bug with a Money type column was fixed
• S3 Browser:
  • Copying files from DBeaver with drag and drop was fixed
  • Choosing an editor from a pop-up to open a file leads to an error
  • Can’t open XML/JSON etc. files (fixed)
• SSH:
  • SSHJ is now the default tunnel implementation
  • SSHJ version was upgraded, ASN1 decoder was added
• Linux:
  • The bug with DBeaver Crontab files parser was fixed
  • The issue with the Debian installer was resolved (configuration files mark removed)
• Clickhouse:
  • Enum data types support was added
  • the issue with the data editor was fixed
  • Table engine and engine parameters (editable) were added to table properties
  • View code editor was fixed
  • 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
  • Boolean data type support was added
  • The issue with timestamp data edit was resolved
  • Improve type mapping when importing data to ClickHouse from the file
  • Performance of data import from file to ClickHouse was improved
• Derby: default driver version was set to 10.15 (to avoid Java version problems)
• PostgreSQL:
  • Constraints information pre-read option was added
  • Enum columns edit support was fixed
  • Representation of arrays with NULL elements was fixed 
  • Database refresh was fixed (issue with active schema mark)
  • Filters for composite data types were fixed
  • PostgreSQL data type by full type name resolution was fixed
• SQLite: view text edit support was added
• SQL Server:
  • DDL for nchar and nvarchar columns was fixed (incorrect length)
  • Columns with aliases can now be edited
  • Table DDL: issue with duplicated index declaration was fixed
  • The issue with GO delimiter evaluation was fixed (also for Sybase)
  • The database name proposal was fixed
  • Execution plan visualization was fixed

• Trino: multi-row insert support was added
• CocroachDB: sequences support was added
• H2: 
  • Schema sequences read were fixed
  • Table metadata and DDL read were fixed

• Hive: view source editor was fixed (issue with a semicolon)
• Kylin: dialect support was improved
• MySQL, MariaDB: privilege editor UI was improved
• Oracle:
  • DDL tab was added to scheduler jobs
  • New table column properties were fixed
  • VARCHAR2 is now the default string data type
  • Trigger DDL was fixed (CREATE keyword)
  • Data type DDL generation was fixed
  • View definition read was fixed for Azure databases
  • nvarchar/nchar column length detection was fixed
  • A password expiration warning was added
  • Generate DDLs for Scheduler Jobs
  • Oracle Cloud database connection issue was fixed
  • ​​The wallet connection issue was fixed
  • The drivers for supporting Oracle Cloud were updated
• Snowflake: issue with BEGIN TRANSACTION query execute was fixed
• Azure SQL: driver version was upgraded, an issue with auth token refresh was resolved
• DB2: dependent views can be excluded from table DDL
• Azure SQL Server, Babelfish: multiple databases support was redesigned
• PostgreSQL, CocroachDB:
  • Row security policy support was added
  • PgPass authentication now supports SSH hosts, and hosts redefine
  • Routines privileges DDL was fixed
  • Extra options were added to explain the plan dialog
  • Data type constraints loading was improved
  • Data type DDL generation was fixed
• Firebird: overloaded procedures loading issue was resolved
• MS Access: diagram loading was fixed
• MongoDB:
  • Filter saving for non-relational databases was fixed
  • The JSON view for tables was improved
  • The incorrect display of arrays was fixed

• MongoDB and DynamoDB:
  • Pinned option in “Customize filters” is [NULL]
• InfluxDB:
  • The data type displayed in the metadata editor was fixed
  • The column header filter was improved
• BigTable:
  • The ability to use web authentication for BigTable was fixed
• Teradata:
  • Performance of import of large CSV files was improved
  • Support Schema Compare was added
• DynamoDB:
  • DynamoDB refresh was fixed
• MySQL:
  • Kerberos support was added
  • An issue with numeric schema names was fixed
• Redshift:
  • Redshift: use the DbUser SAML attribute as a database user
  • Tablespaces and partitions aren’t supported but fields are shown (fixed)
• Redis:
  • Read of Redis keys  in SQL editor issues were fixed
• YugabyteDB: The display of full DDL of Indexes was added