Version 23.2
Release Notes 23.2
You are currently viewing an old version of DbVisualizer. We recommend that you check out our latest 25.1.3 version.
23.2.6 - Released 2024-01-08
Bugs Fixed
Area
Details
Connection Setup
Revert Selected Category does not affect open tabs when used in "Color and Border" under connection properties
Exception when toggling boolean connection properties
Exception when toggling boolean connection properties
Connection Setup
Driver Manager Unsaved driver properties warning is displayed even when there are no changes
Driver Manager Unsaved driver properties warning is displayed even when there are no changes
Connection Setup
Tool Properties Unintuitive unsaved changes warning
Tool Properties Unintuitive unsaved changes warning
Create/Alter Table
Alter Table generates commands in the wrong order for certain combinations of column changes
DB Support: Azure SQL
DB Support: SQL Server Latest driver for Azure SQL and SQL Server shows an unnecessary error on connect
DB Support: SQL Server Latest driver for Azure SQL and SQL Server shows an unnecessary error on connect
DB Support: Cassandra
SQL Commander Choosing schema in SQL Commander has no effect
SQL Commander Choosing schema in SQL Commander has no effect
DB Support: ClickHouse
Tables from all databases are displayed under Tables when using the latest ClickHouse driver
DB Support: DB2 LUW
Columns should not be qualified with table name by default when auto-completing
DB Support: DB2 z/OS
Warnings reported by JDBC via ResultSet are still not displayed
Show warnings reported by JDBC via ResultSet
Show warnings reported by JDBC via ResultSet
DB Support: Greenplum
DB Support: PostgreSQL
DDL Generator SET statements with multiple values in function and procedure definitions do not work properly
SET statements in functions and procedures are lost when generating DDL
DB Support: PostgreSQL
DDL Generator SET statements with multiple values in function and procedure definitions do not work properly
SET statements in functions and procedures are lost when generating DDL
DB Support: Microsoft Access
Columns tab is empty and the DDL tab is corrupt for tables containing underscore in the name
DB Support: Oracle
Internal columns in the objects tree, generated DDL and table data editor
Source code is displayed without line breaks in Java Sources
Source code is displayed without line breaks in Java Sources
DB Support: Redshift
Column ordering for external tables in Redshift
DB Support: Redshift
Procedure Editor Procedure editor removes OUT parameters
Procedure editor doesn't display the NONATOMIC keyword
Procedure Editor Procedure editor removes OUT parameters
Procedure editor doesn't display the NONATOMIC keyword
DB Support: SQLite
Export Export generates ADD CONSTRAINT statements unsupported by SQLite
Export Export generates ADD CONSTRAINT statements unsupported by SQLite
DB Support: SQLite
Import Error when importing table data in SQLite
Import Error when importing table data in SQLite
Database Objects Tree
DB Support: Snowflake Tables are displayed as views in the objects tree when using the generic profile
DB Support: Snowflake Tables are displayed as views in the objects tree when using the generic profile
Driver Manager
Driver Manager should ask about saving when closing
Export/Import User Settings
Exception when importing user settings
Grid Component
Tool Properties Changing grid font doesn't affect open non-editable data tabs
Tool Properties Changing grid font doesn't affect open non-editable data tabs
OS Support: macOS
Downgrade to Java 17.0.1 on macOS due to a bug in 17.0.2 and later versions
Windows occasionally fail to close on macOS
Windows occasionally fail to close on macOS
Performance/Stability
SQL Commander Disabling stale files warning should reduce latency on slow drives
SQL Commander Disabling stale files warning should reduce latency on slow drives
Query Builder
"Remove Join" is not enabled
SQL Commander
"Ask" permissions have no effect when script preprocessing is off
Cannot format the "now" value when using a custom timestamp format in variable declarations
Permissions for UPDATE and DELETE overridden by permissions for missing WHERE
Cannot format the "now" value when using a custom timestamp format in variable declarations
Permissions for UPDATE and DELETE overridden by permissions for missing WHERE
Tool Properties
The details pane for selected node in Tool Properties->Database may show data for another database type
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