June 13, 2022

• General improvements:
  • DBeaver now shows EULA on start (one time)
  • The issue with workspaces on network paths was resolved
  • Kerberos configuration load was fixed on RHEL
  • SSH tunnel: connection timeout/keep-alive parameters change was fixed
  • SSH: problem with connections and corrupted known_hosts file was resolved
  • Command-line: possibility to specify external variables file was added
  • Dark theme: buttons UI now matches OS theme
  • Local timezone configuration was added to preferences
  • Connection type color now affects SQL editor panels
  • Tab selector (CTRL+E) now supports fast/fuzzy search
  • Project rename now updates project name in all linked views
  • Problem with navigator tree refresh was resolved
  • Preference pages now respect font configuration
  • Configuration popup positioning was fixed for low-res monitors
  • Problem with the application starting on some macOS and Linux installations were fixed
  • The read-only connections toggle was redesigned
  • “Copy object name” action was added to the tab context menu
  • ​​Preference pages: problem with the small font size was resolved

• Database navigator:
  • A connection read-only state switcher was added in the main toolbar/menu
  • Support of databases with a big number of schemas was improved
  • Column grouping now shows the number of grouped elements
  • Auto-completion was improved in the properties editor
  • The database selector popup was fixed (null pointer error)

• Connection:
  • Support identity verification using Active Directory was added
  • The bug with configuring Kerberos auth on RHEL and derivatives was fixed
  • Auth models for Microsoft SQL Server were added.

• Data editor:
  • Auto-refresh UI was fixed (stop on error visualization)
  • Array data types handling was improved (PostgreSQL, Clickhouse)
  • Invalid fractional seconds rendering was fixed
  • Filter panel is removed in nonapplicable presentations
  • The number of selected rows calculation was fixed
  • Row colors reset option was added
  • Edit controls enable state was fixed for plaintext view
  • Keyboard shortcuts were fixed in the inline date/time editor
  • The next segment auto fetch was fixed for specific queries
  • Option “show whitespaces” was added
  • Columns reordering in the data filter dialog was fixed
  • Line numbers were added to the plaintext view
  • The value filter now shows the total number of distinct values
  • Search for the whole word was fixed
  • Custom filter value save was fixed
  • The bug with the working of the cancel button for Document databases was fixed
  • The option to show in the parent node of grouping the number of children was added
  • The issue with working with the data grid on macOS was improved
  • Numbers formatting: digit group size option was added
  • Problem with an unexpected change of timestamp values was fixed
  • Smooth scrolling on macOS was improved
  • Color by range now supports foreground color customization
  • Problem with clob/JSON popup editors was resolved
  • Epoch time transformer now supports 4 more modes
  • Grouping panel: problem with GROUP BY query generation was fixed for many analytical databases
  • Date/time inline editor UI was improved

• Data transfer:
  • The “Ignore duplicated rows” option was added
  • Table mapping “re-create” support was improved
  • Skipped columns configuration save was fixed
  • Driver description editor was fixed
  • Maven artifacts version resolution was improved
  • “Append to existing file” feature was improved (for CSV, TXT, and XLSX formats)
  • The export wizard now loads saved properties on demand
  • Export of result set with reordered/hidden columns was fixed
  • Export in SQL format: “split into multiple files” now works correctly
  • Task execution notification was improved
  • SQL script tasks support was fixed (NullPointer error was resolved)
  • Export of many tables into a single target table was fixed
  • Import from CSV was fixed (problem with null handling was resolved)
  • Trim whitespaces option was added for CSV import
  • Table columns mapping UI was fixed on macOS
  • Automatically detected data length from XLSX when generating new columns was added
  • Support UPDATE SET replace method for MySQL in the file was added
  • The bug with data import with “skip bind values” in Redis was fixed. 
  • File encoding was added in the header of an XML file with exported data
  • Data transfer in AWS Keyspaces and Cassandra was improved
  • Default data type mapping was improved (especially for char/varchar columns)
  • Multi-table transfer now opens all target tables
  • Database restore task now requires additional confirmation
  • Output folder parameter now supports additional variables
  • Import task UI was fixed (issue with lost target tables configuration)
  • XML format export was improved (encoding information)

• SQL editor:
  • Data filter injection for custom SQL queries was improved
  • Transaction monitor was fixed (amount of statements in a transaction)
  • Script error visualization is now configurable
  • Block statements (BEGIN, IF, CASE) auto-close was improved
  • Auto-completion was fixed for INSERT queries
  • “Cancel active query” command was added
  • Filtering of aliased columns was fixed
  • Problem with DML queries re-execution on connection lost was fixed
  • Python source code format was added to Copy As command
  • “Hippie” auto-completion was disabled by default (due to performance problems)
  • SQL commands parser/navigation was fixed (thanks to @arvillion)
  • Parameter bindings dialog was disabled for long strings (like $$)
  • CASE/WHEN formatting was fixed
  • Problem with semicolons on a new line was fixed
  • Problem with client-side commands parsing was fixed
  • Tabs close/confirmation behavior was improved
  • Script with multiple @set commands processing was fixed
  • The command for data export automation was added (@export)
  • The toggle comment command was fixed (thanks to @arvillion)
  • SQL script data source association command was fixed
  • Added error display in a specific query in the SQL script
  • The bug with sorting non-simple columns in SQL scripts was fixed
  • The bug with the query executing to rename a table in Netezza was fixed.
  • External tables metadata read was fixed
  • NTLM authentication support was fixed
  • Results tab reuse behavior was fixed + new config option was added
  • Result logging was added for script execute task
  • The redundant “Problems” view popup was removed
  • Keywords highlighting was fixed (problem with identifiers that start with an underscore)
  • Right-click on a script text now changes the cursor position
  • Part divider element visualization was improved
  • Confirmation was added for the “Delete this script” action
  • The dangerous query execution confirmation configuration was fixed

• Data comparison:
  • The option to compare two database objects case-insensitively was added.
  • The highlighting of fields after comparison was fixed. 
  • The issue with comparison tables in MS Access was resolved

• Task manager:
  • Task ordering was fixed (folders on top)
  • The bug with displaying composite tasks multiple times was fixed.
  • A lot of improvements with sending task notifications and reporting.
  • Added a tooltip to shell script task timeout.

• Spatial viewer:
  • The ability to select spatial objects on map and data grid was added
  • The default zoom level option was added

• ERD:
  • Creating new tables in edit mode were fixed.
  • The possibility to remember the last name of the file when saving was added
  • Highlighting comments was fixed 
  • Exporting ERD to SVG was fixed
  • The ability to bind a shortcut for the ‘Save diagram in external format’ action was added
  • The option to not open an external viewer after saving was added
  • Connected entities highlighting was added
  • Entities and columns search was improved
  • New diagram routing was added
  • Problem with unreadable comments was fixed (dark theme)
  • Export in SVG and Graphml formats was improved
  • Pseudo columns were removed from diagrams
  • The diagram re-arrange was fixed
  • Many minor bugs were fixed

• Visual Query Builder:
  • Displaying objects from the selected schema in VQB was fixed
  • Working queries without aliases were fixed
  • Displaying JSON was improved.
  • The bug with using VQB with the opened non-select statement script was fixed

• Cloud explorer:
  • Connection dialog in the Cloud Explorer was improved
  • Creating a new cloud configuration was fixed
  • Refreshing files after adding with drag-n-drop were fixed
  • Google Cloud Platform support was added in Cloud Explorer

• S3 browser:
  • A bug with opening files by double-clicking has been fixed.
  • The issue with copied files from DBeaver with drag and drop was fixed
  • The option to display locations and size of S3 buckets/files was added

• macOS: 
  • An issue with application launch was fixed (problem with plist file modification)
  • The issue with UI freeze after data edit was fixed
  • Problem with embedded dropdown editors was resolved 

• Linux:
  • Problem with workspace load was fixed on some
  • Problem with UI freeze in the connection type editor was fixed

• Windows: DBeaver now supports workspaces on network paths (e.g. \\network-share\workspace)

 

• Localizations:
  • Italian localization was significantly improved
  • Chinese localization was updated

• Google Cloud Platform:
  • The support of GCP authentication was added
  • GCP SSO support was added
  • IAM auth was added to Spanner, BigQuery, and BigTable drivers

• MySQL:
  • Indexes edit support was added
  • Functions executed were fixed
  • An issue with table lock during database dump was fixed
  • Generate SQL for geometry data types was fixed
  • The permission editor was fixed (issue with duplicated permissions)
  • An issue with decimal data types with the zero-fill flag was fixed
  • UPDATE SET replace method was added

• Oracle:
  • Sequences DDL tab was added
  • Scheduler jobs metadata read was fixed
  • Arrays presentation was improved (numbers formatting was fixed)
  • Materialized view save was fixed
  • View source code edit was fixed (issue with view comments was resolved)
  • Table partition metadata read was fixed

• PostgreSQL:
  • View source editor was fixed (redundant ‘create or replace’ clause was removed)
  • Template databases are now visible is specified in connection settings
  • Server version < 8 support was improved
  • Saved backup/restore tasks UI was fixed
  • Nested arrays editor was implemented
  • Functions source code generation was fixed (function signature)
  • Portuguese localization was fixed (thanks to @TiagoValdrich)
  • pg_dump and pg_restore version was upgraded (to PG 14)
  • Script execute task now shows all script errors
  • The issue with SQL generation and JSONB columns was fixed
  • View column edit support was added
  • The default driver version was changed to 42.2.25 due to security reasons
  • SSPI authentication support was added (problem with JNA library conflicts was resolved)
  • Read-only connections support was improved (restrict of DML queries)
  • Scheduled jobs management was added

• Redshift: 
  • Search in procedure definition was fixed
  • The ability to change the password for the newly created role if it does not match the security policy was added

• Vertica:
  • Metadata performance was significantly improved
  • Table/column comments are now read in lazy mode

• Apache Druid, Apache Kylin:
  • Table data read was fixed
  • Data type properties were fixed
  • Indexes read were fixed

• Clickhouse: array data type editor was implemented
• HANA: procedures output parameters fetch was fixed
• DB2: 
  • Query terminator redefine support was added
  • Procedure name auto-completion was fixed

• EDB: Schema compare was improved
• DB2 i:
  • Sequences support was added
  • View definitions read were implemented
  • Unique and check constraints support was added
  • Multiple minor improvements in metadata read were added
  • Keys and foreign keys metadata read was fixed

• H2:
  • System views DDL generation was fixed
  • Geometry data type rendering in the new H2 driver was fixed (thanks to @ebocher)

• Apache Phoenix: connectivity issue was fixed by setting the proper driver version
• CockroachDB: ROWID columns support was added
• Exasol: search in view/procedure source code was implemented
• Snowflake: 
  • Support of LIMIT for custom SQL queries was added (affects performance)
  • Database metadata read performance was significantly improved

• CLI: parameter “create” was fixed for connection opened using -con parameter
• Netezza: 
  • Table rename SQL was fixed
  • Case-sensitive user names support was added

• SQLite: connection settings dialog UI was fixed (Open and Create buttons behavior)
• Microsoft SQL Server:
  • Money data type support was fixed
  • The connection settings dialog was redesigned
  • A lot of minor fixes in application localization
  • The support of money data type was improved
  • External tables metadata read was fixed
  • NTLM authentication support was fixed

• MongoDB/DocumentDB:
  • The support of ‘db.createUser({…})’ command was added
  • The use <db> command was added
  • The issue with applying column arrangement until refresh was fixed
  • The bug with displaying columns in ResultSet was fixed

• MariaDB: Support two-step authentication was added
• DynamoDB:
  • The bug with the update rows after editing keys was fixed
  • The issue with value changes was fixed
  • Data displaying in ResultSet was improved
  • The process of DDL data transfer was improved
  • Sorting for tables with complex data types was improved
  • Drop table statement support was added
  • The displaying arrays in Value Panel were improved
  • Column filtering by multiple values via Column header was fixed
  • Support filtering with OR was added
  • Filter by boolean fields was improved
  • The bug with filtering by Null value was fixed
  • The bug with adding the attribute of type null in the new table was fixed
  • Formatting in the Data Editor was improved
  • Export from DynamoDB to PostgreSQL, MySQL was improved
  • Invalidate/Reconnect option was improved
  • The bug with naming new tables was fixed
  • Sorting of columns after filtering was improved
  • Import data was improved

• Teradata: SQL query limit (TOP) support was added
• Google Bigtable: The bug with displaying the context menu with a disabled instance was fixed
• AWS: 
  • GOV regions support was added
  • The issue with AWS CLI on macOS was fixed

• New drivers:
  • Databricks 
  • Apache Kyuubi