Version 24.2
Release Notes 24.2
You are currently viewing an old version of DbVisualizer. We recommend that you check out our latest 24.3.1 version.
24.2.4 - Released 2024-11-27
Bugs Fixed
Area
Details
Auto-Completion
An extra delimiter may be inserted when auto-completing qualified table names
Auto-completion doesn't always work in CASE statements
Auto-completion doesn't always work in CASE statements
Connection Setup
Unable to revert driver property when there is no default value
DB Support: Hive
Exception when connecting to Apache Hive using Kerberos
DB Support: JavaDB/Derby
The application falls back on the generic profile when connecting to Derby
Database Objects Tree
Possible exception when accessing a non-default database
Database Profile: Actions
It is possible to issue multiple create schema commands when using the Create Schema action
Export/Import User Settings
Proxy password may not be imported correctly
Import
Exception when executing import on a disconnected database
Possible exception when importing table data
Possible exception when importing table data
Query Builder
QueryBuilder fails to load a valid query if identifier case differs from the metadata
SQL Editor
Exception in the code editor
24.2.3 - Released 2024-10-28
Improvements
Area
Details
DB Support: PostgreSQL
Add an action to create types in PostgreSQL
Add an action to create domains in PostgreSQL
Add an action to create domains in PostgreSQL
Bugs Fixed
Area
Details
Auto-Completion
Auto-completion may pick up value instead of name for constant columns
Auto-completion doesn't work following a JDBC date expression
Auto-completion doesn't work following a JDBC date expression
Client side commands
@echo does not handle empty input
Connection Setup
Exception when saving changes to multiple database connections at once
DB Support: Azure SQL
DB Support: Redshift Multiple authentication popups when using SSO with Amazon Redshift and Azure SQL Database
DB Support: Redshift Multiple authentication popups when using SSO with Amazon Redshift and Azure SQL Database
DB Support: Greenplum
DB Support: PostgreSQL
DDL Generator "WITH" clause is missing in index DDL
DB Support: PostgreSQL
DDL Generator "WITH" clause is missing in index DDL
DB Support: MariaDB
"Alter Table" may generate incorrect DDL for MariaDB
DB Support: SingleStore
An error occurs when showing databases in SingleStore when sql_mode is set to ANSI
"Max Rows" is not handled in the SingleStore database driver
"Max Rows" is not handled in the SingleStore database driver
DB Support: Snowflake
User-related actions may generate incorrect SQL in Snowflake
Missing table name in script actions in Snowflake
Missing table name in script actions in Snowflake
Driver Manager
Editing driver artifacts may reset connection parameters for related connections
Export
"Quote Text Value" is incorrectly set to "None" when exporting table data
SQL Commander
Should not be able to play a macro while recording
SQL Editor
T-SQL variables may break syntax coloring in the editor
Tool Properties
When duplicating settings in Tool Properties, some of the copied values may be incorrect
24.2.2 - Released 2024-08-30
Improvements
Area
Details
SQL Commander
Display execution duration in the tooltip of the result tab
Bugs Fixed
Area
Details
DB Support: Azure SQL
DB Support: Azure Synapse
DB Support: SQL Server
DB Support: Sybase ASE "Max Rows" should not be applied to updates within undelimited statement blocks in SQL Server
DB Support: Azure Synapse
DB Support: SQL Server
DB Support: Sybase ASE "Max Rows" should not be applied to updates within undelimited statement blocks in SQL Server
DB Support: MariaDB
Exception in "Drop Package"
DB Support: MariaDB
DB Support: SingleStore "Alter Table" doesn't work for certain versions of MariaDB and SingleStore
DB Support: SingleStore "Alter Table" doesn't work for certain versions of MariaDB and SingleStore
DB Support: Redshift
Error when saving stored procedures in Redshift for certain driver versions
DB Support: SQL Server
DB Support: Sybase ASE PRINT statements are not always reported in the Log tab
DB Support: Sybase ASE PRINT statements are not always reported in the Log tab
DB Support: SQLite
Exception when generating column constraints in SQLite in certain cases
DB Support: Snowflake
"Create Sequence" generates incorrect SQL in Snowflake
Function DDL may be incomplete in Snowflake
JSON values are interpreted as parameter markers in Snowflake
Function DDL may be incomplete in Snowflake
JSON values are interpreted as parameter markers in Snowflake
Export
"Quote Text Value" is not set correctly when loading export settings
Column type is set to "Custom" when exporting numbers to Excel
Column type is set to "Custom" when exporting numbers to Excel
OS Support: macOS
The choice of font may be lost after application restart
Procedure Editor
Package navigator does not show all procedures/functions
Not able to save procedures and functions for some languages
Not able to save procedures and functions for some languages
Query Builder
Table and columns names are not always qualified properly in Query Builder
Rows in the "Conditions" tab in Query Builder may be clipped
Error in the generated HAVING clause in Query Builder
Rows in the "Conditions" tab in Query Builder may be clipped
Error in the generated HAVING clause in Query Builder
SQL Commander
Possible visual artifacts when hovering the "Sticky" control in SQL Commander
Tool Properties
Actions in the "Find and Replace Toolbar Actions" category are not listed correctly in the key bindings editor
Availability check for Maven repositories in Tool Properties doesn't work when a proxy is used
Availability check for Maven repositories in Tool Properties doesn't work when a proxy is used
UX/UI
Possible exception on application start when checking OS theme settings
24.2.1 - Released 2024-07-04
Improvements
Area
Details
DB Support: Redshift
Update the Redshift template driver
DB Support: Teradata
Update the Teradata template driver to allow automatic download
I18N
Use composite fonts by default to improve support for international characters
Bugs Fixed
Area
Details
App Logging
Error highlighting in the debug window doesn't work
Auto-Completion
Auto-completion may suggest unrelated columns when a table alias is used
Auto-completion may insert the table alias twice in some cases
Auto-completion may insert the table alias twice in some cases
DB Support: MariaDB
Need to use block identifiers in CREATE PACKAGE though "Allow SQL Dialects" is turned on
Data tab
Exception in Edit Table Data->SQL Preview
Driver Manager
Ask for confirmation when deleting driver artifacts
Ask for confirmation when deleting user drivers
When several driver classes are available, the existing choice may be reset when changing the driver version
Ask for confirmation when deleting user drivers
When several driver classes are available, the existing choice may be reset when changing the driver version
Export
Text trim doesn't work when exporting data in JSON format
Changes in editor styles do not affect the preview in Export Grid
Changes in editor styles do not affect the preview in Export Grid
Export/Import User Settings
Exception in "Export Settings"
General
Exception during startup for certain locales
Import
Exception when importing data to a new table
OS Support: Windows
Window title bar may remain light in dark mode on Windows
Procedure Editor
Same icon is used for two actions in the procedure editor
SQL Commander
Restore the missing "Save As" button
Make it possible to open a new SQL Commander tab from the main toolbar with a single click
Make it possible to open a new SQL Commander tab from the main toolbar with a single click
Scripts
Exception when renaming a file in the Scripts tab
24.2 - Released 2024-06-19
New Features
Area
Details
Command Line Support (dbviscmd)
Add support for creating persistent database connections using dbviscmd
DB Support: Azure Synapse
Add support for Azure Synapse Analytics
DB Support: Cassandra
Add support for the Cassandra JDBC Wrapper driver
DB Support: Databricks
Add basic support for Databricks
DB Support: MariaDB
DB Support: Oracle Navigate between procedures and functions in the package body editor
DB Support: Oracle Navigate between procedures and functions in the package body editor
Export
Add support for generating MERGE statements when exporting data as SQL
Add support for trimming text values when exporting data
Add support for trimming text values when exporting data
SQL Editor
Add actions to select the previous/next statement in the editor (Ctrl+Alt+Up/Down)
UX/UI
Full window support on macOS
Automatic theme switching
New dark and light themes
Introduce new scalable icons
Automatic theme switching
New dark and light themes
Introduce new scalable icons
Improvements
Area
Details
Auto-Completion
Automatically qualify columns when the column name alone is ambiguous
Cell Viewer/Editor
Grid Component Add support for SVG images in the cell viewer and the data grid
Grid Component Add support for SVG images in the cell viewer and the data grid
Connection Setup
DB Support: Azure SQL
DB Support: SQL Server Improve the response to "PKIX path building failed"
DB Support: Azure SQL
DB Support: SQL Server Improve the response to "PKIX path building failed"
Create/Alter Table
DB Support: MySQL Add support for generated columns in MySQL in Create/Alter Table
DB Support: MySQL Add support for generated columns in MySQL in Create/Alter Table
Create/Alter Table
DB Support: PostgreSQL Add support for sequence name in auto-generated columns in PostgreSQL
DB Support: PostgreSQL Add support for sequence name in auto-generated columns in PostgreSQL
DB Support: Greenplum
Add support for Greenplum 7
DB Support: Greenplum
DB Support: PostgreSQL
DB Support: Redshift
DB Support: Yellowbrick Display table constraints under the corresponding table node in the database objects tree
DB Support: PostgreSQL
DB Support: Redshift
DB Support: Yellowbrick Display table constraints under the corresponding table node in the database objects tree
DB Support: PostgreSQL
Add support for roles in PostgreSQL (replacing users and groups)
DB Support: Redshift
Add support for materialized views in Redshift
DB Support: Snowflake
Handle additional table types in Snowflake (dynamic, event, hybrid and iceberg tables)
Database Objects Tree
In the database objects tree, add an indicator to nodes where all sub-nodes were hidden by an active filter
Export
Use SQL syntax highlighting in the preview section in Export Grid
Automatically suggest file extensions when exporting data
Automatically suggest file extensions when exporting data
General
Improved support for arrays
Grid Component
Display newlines and tabs as symbols rather than whitespace in text values in the data grid
Multi-thread image preview generation
Multi-thread image preview generation
SQL Commander
With auto-commit off, show the actual statements when warning the user about uncommitted updates
Add support for a list of choices in custom variables
Add support for a list of choices in custom variables
SQL Editor
Add a button for newline in Find and Replace
Support newline, tab and uppercase/lowercase manipulation in Find and Replace
Handle identifier delimiters based on database type instead of user configuration
Support newline, tab and uppercase/lowercase manipulation in Find and Replace
Handle identifier delimiters based on database type instead of user configuration
Security
Add the option to reset master password also when a master password is required
Bugs Fixed
Area
Details
Auto-Completion
Auto-Completion may fail when operators are used in the SELECT clause
Auto-completing a column in a sub-select may insert an alias from the outer query
Auto-completion doesn't work after INSERT INTO
Auto-completion doesn't work with the USING join syntax
The auto-completion popup may behave strangely if a database error occurs when loading table metadata
Auto-completing a column in a sub-select may insert an alias from the outer query
Auto-completion doesn't work after INSERT INTO
Auto-completion doesn't work with the USING join syntax
The auto-completion popup may behave strangely if a database error occurs when loading table metadata
Create/Alter Table
DB Support: PostgreSQL NOT NULL can be omitted in the DDL for auto-generated columns in PostgreSQL
DB Support: PostgreSQL NOT NULL can be omitted in the DDL for auto-generated columns in PostgreSQL
DB Support: ClickHouse
Can't list databases in older versions of ClickHouse
DB Support: Exasol
Incorrect SQL generated by the "Create User LDAP" action in Exasol
Export/Import User Settings
Passwords are not included when exporting/importing SSH configurations
Key Bindings
Some of the assigned key combinations may stop working until the application is restarted
OS Support: macOS
Expanding database nodes using the keyboard may result in the spinning beachball on macOS Sonoma
Query Builder
When loading a query containing an unsupported operator into the query builder, it is replaced with "="
SQL Commander
"Enter Data for Variables" dialog does not reflect the initial state of boolean variables
SQL Editor
Multi-caret select may exclude the first line when clicking outside of the editor
The delete key doesn't work in multi-caret mode
The delete key doesn't work in multi-caret mode
Tool Properties
"Show Password" doesn't work for authentication type Public Key in Tool Properties->SSH Configurations