Latest version 23.2
Release Notes
23.2.5 - Released 2023-10-03
Improvements
Area
Details
SSH
Tool Properties Use relative paths for SSH settings
Tool Properties Use relative paths for SSH settings
Bugs Fixed
Area
Details
Connection Setup
DB Support: Cassandra Changing authentication settings may produce errors when configuring Cassandra connections
DB Support: Cassandra Changing authentication settings may produce errors when configuring Cassandra connections
Contact Support
Adapt dialog size when application font size changes
DB Support: Greenplum
DDL Generator "PARTITION BY" clause is missing from table DDL
DDL Generator "PARTITION BY" clause is missing from table DDL
DB Support: Informix
DDL Generator Incorrect DDL generated for DECIMAL(p) columns
DDL Generator Incorrect DDL generated for DECIMAL(p) columns
DB Support: Snowflake
Inconsistent type information in the Columns tab
Database Objects Tree
DB Support: H2 Multi-column indexes are shown multiple times in the database objects tree for H2
DB Support: H2 Multi-column indexes are shown multiple times in the database objects tree for H2
Driver Manager
Creating driver from template does not work in some cases
File Chooser
OS Support: Windows File chooser crashes for certain types of directories on Windows
OS Support: Windows File chooser crashes for certain types of directories on Windows
Grid Component
Auto resize column widths should be preserved between reloads
Interacting with the table header while reloading may result in errors
Interacting with the table header while reloading may result in errors
SQL Commander
Filtering in SQL Log may result in errors in some cases
SQL History
Sorting in SQL History is slow when there are many entries
SQL Log
Sorting does not work in SQL Log
Table Data Editor
Row is marked as changed after leaving the value editor although no change was made
23.2.4 - Released 2023-08-15
Improvements
Area
Details
DB Support: Google BigQuery
Upgrade the template driver for BigQuery
DB Support: SQL Server
Add the "Script Index" action allowing to generate DDL for the selected indexes
Bugs Fixed
Area
Details
Auto Completion
Potential error when using auto completion while database connection goes down
Connection Setup
A duplicated database connection may connect using the database connection details specified in the original connection even if details are changed in the duplicate
DB Support: DB2 LUW
Imports Wrong rounding when importing decimal numbers from Excel
Imports Wrong rounding when importing decimal numbers from Excel
DB Support: Google BigQuery
Table data editor does not work with recent BigQuery drivers
DB Support: H2
DDL Generator @ddl indexesfortable gives an error in H2 2.x
DDL Generator @ddl indexesfortable gives an error in H2 2.x
23.2.3 - Released 2023-07-13
Improvements
Area
Details
DB Support: Snowflake
Add support for creating JavaScript procedures
Query Builder
SQL Commander "Show SQL Editor" and "Show Query Builder" create a new SQL Commander if necessary
SQL Commander "Show SQL Editor" and "Show Query Builder" create a new SQL Commander if necessary
Bugs Fixed
Area
Details
Auto Completion
"Show Autocomplete" and "Show Editor Templates" actions do not work when triggered from the main menu or the context menu
Check for Update
Improved error handling when trying to upgrade while an upgrade is already in progress
DB Support: DB2 LUW
Using DBMS Output gives too many concurrently open statements
DB Support: DB2 iSeries
SQL Commander Can't select schema in SQL Commander
SQL Commander Can't select schema in SQL Commander
DB Support: Greenplum
DB Support: PostgreSQL Incorrect partitions reported for partitioned tables
DB Support: PostgreSQL Incorrect partitions reported for partitioned tables
DB Support: Oracle
Explain Plan Handle multiple predicates in Oracle's explain plan
Explain Plan Handle multiple predicates in Oracle's explain plan
DB Support: Redshift
Redshift driver artifacts are not compatible with each other
DB Support: Snowflake
Snowflake Create Procedure SQL Preview has bad javascript syntax
Incorrect code generated when creating a procedure or a function
Incorrect code generated when creating a procedure or a function
DB Support: Vertica
Adjust for overloaded procedures-related changes in Vertica 12.0.4
Data tab
Rare error when closing an Object View while the Data tab is being loaded
Database Objects Tree
DB Support: Google BigQuery Exception when expanding tables in the database objects tree
DB Support: Google BigQuery Exception when expanding tables in the database objects tree
Driver Manager
Exception when changing driver name and class
Export/Import User Settings
Exception when exporting user settings and a driver file is missing
General
The link in the "Certificate not trusted" dialog doesn't work
Grid Component
OS Support: macOS Can't paste grid data in some applications on macOS
OS Support: macOS Can't paste grid data in some applications on macOS
Installation/Update Installation
Connections lost after upgrade if running multiple DbVisualizer instances
OS Support: Linux
Main menu is not merged with the window title bar for the first opened DbVisualizer window
OS Support: Windows
SQL Commander DbVisualizer may lag on Windows as a result of the stale file checker accessing a slow file system
SQL Commander DbVisualizer may lag on Windows as a result of the stale file checker accessing a slow file system
SQL Commander
Exception when handling a database error
Vertical scrollbar in SQL Commander is cut off if the window is small enough
Vertical scrollbar in SQL Commander is cut off if the window is small enough
Table Data Editor
Exception when stopping an ongoing save operation in the table data editor, and related improvements
Exception when undoing delete of row
Exception when undoing delete of row
23.2.2 - Released 2023-05-16
Improvements
Area
Details
Database Objects Tree
Include SSH information in the database connection tooltip
Bugs Fixed
Area
Details
@import
Import Exception when importing table data
Import Exception when importing table data
Table Data Editor
The permission checker doesn't issue a warning when updating or deleting rows in the table data editor
23.2.1 - Released 2023-05-10
Bugs Fixed
Area
Details
Table Data Editor
Exception when deleting or updating rows in the table data editor
23.2 - Released 2023-05-09
Improvements
Area
Details
DB Support: DB2 LUW
DB Support: Oracle Add a connection property to enable DBMS output automatically
DB Support: Oracle Add a connection property to enable DBMS output automatically
DB Support: Exasol
Update the driver and add new keywords
DB Support: Greenplum
DB Support: PostgreSQL Generate DDL for foreign tables
DB Support: PostgreSQL Generate DDL for foreign tables
DB Support: Snowflake
Add data views for database, warehouse, server info and user parameters
Database Objects Tree
DB Support: Greenplum
DB Support: PostgreSQL Show foreign tables under foreign servers in the database objects tree
Display foreign servers for each database in the database objects tree
DB Support: Greenplum
DB Support: PostgreSQL Show foreign tables under foreign servers in the database objects tree
Display foreign servers for each database in the database objects tree
Driver Manager
Upgrade template drivers
Separate driver artifacts from driver definitions to allow reuse and improve maintainability
Add folders containing any file type to driver path
Separate driver artifacts from driver definitions to allow reuse and improve maintainability
Add folders containing any file type to driver path
Driver Manager
Tool Properties Add a server availability indicator to the list of Maven repositories in Tool Properties
Tool Properties Add a server availability indicator to the list of Maven repositories in Tool Properties
Export/Import User Settings
Create user drivers automatically when importing connections exported without the driver
SQL Commander
Detect missing WHERE clause in DELETE and UPDATE (controlled using Tool Properties > Permissions)
Workspace
Adjust windows to visible screen area when screen setup changes
Bugs Fixed
Area
Details
Auto Completion
The auto completion popup qualifies table names with database and schema
Improved auto completion for object names with mixed case
Improved auto completion for object names with mixed case
DB Support: PostgreSQL
Error in generated DDL when NO INHERIT is used
DB Support: SQLite
Handle tables with names in mixed case or matching reserved keywords
Driver Manager
Resetting a driver created from a template with downloaded artifacts refers to artifacts in the template
Clear current filter when opening a connection's driver in Driver Manager
Clear current filter when opening a connection's driver in Driver Manager
Export
Improve random data generation in grid export (see "Generating Test Data" in the users guide)
Grid Component
Pasting table content from DbVisualizer into Slack doesn't work
Import
Error when clicking the Table Engine drop-down in Import Table Data
Installation/Update Installation
EULA should only have to be accepted once during upgrade
OS Support: macOS
Clicking on .sql files doesn't open them in DbVisualizer
Performance/Stability
Improve performance of the database objects tree by optimising auto detection of database type
SQL Editor
Tool Properties With the JetBrains Mono font, any change of font size is not preserved between DbVisualizer sessions
Tool Properties With the JetBrains Mono font, any change of font size is not preserved between DbVisualizer sessions