Version 11.0
Release Notes 11.0
You are currently viewing an old version of DbVisualizer. We recommend that you check out our latest 24.3.1 version.
11.0.7 - Released 2021-01-24
Bugs Fixed
Area
Details
Cell Viewer/Editor
TIFF image read error when using Java 8
Cell Viewer/Editor
DB Support: Informix ClassCastException when editing Informix BYTE
DB Support: Informix ClassCastException when editing Informix BYTE
DB Support: Redshift
Alter table dialog believes properties are changed when they are not
DB Support: Snowflake
Scripting a "CREATE TABLE" in Snowflake does not account for case sensitive table names
Export
"Invalid column index (256)" error when exporting to Excel
11.0.6 - Released 2020-11-25
Bugs Fixed
Area
Details
@import
The "Encoding" parameter for @import is not supported while the users guide says it is
DB Support: MariaDB
DB Support: MySQL
SQL Commander Database dropdown does not update after "use" command
DB Support: MySQL
SQL Commander Database dropdown does not update after "use" command
DB Support: PostgreSQL
Import Import of data types where a cast (for example xml) is needed does not work
Import Import of data types where a cast (for example xml) is needed does not work
Export
@export via settings file does not check for unsupported Format parameter
Import
Exception during import
References
Exception when redisplaying table references, with node content changed from none to primary key
SQL Commander
Show warning when when @run SQL file that has changed during execution
Multiple whitespaces within the filename are reduced to one in @export
Multiple whitespaces within the filename are reduced to one in @export
SQL Editor
Auto highlighting in editor cannot handle inserted or deleted text
Cursor misplaced when deleting selected rectangle text
Cursor misplaced when deleting selected rectangle text
11.0.5 - Released 2020-09-14
Bugs Fixed
Area
Details
Create/Alter Table
DB Support: Oracle
DDL Generator Alter table need to support specifying VARCHAR(nn "BYTE/CHAR") for Oracle
DB Support: Oracle
DDL Generator Alter table need to support specifying VARCHAR(nn "BYTE/CHAR") for Oracle
DB Support: DB2 LUW
DB Support: Exasol
DB Support: SQL Server
DB Support: Snowflake Compound foreign keys are not correctly generated
DB Support: Exasol
DB Support: SQL Server
DB Support: Snowflake Compound foreign keys are not correctly generated
DB Support: MariaDB
DB Support: MySQL
DB Support: PostgreSQL
DB Support: SQL Server Column default value is quoted badly if default is a function call when generating DDL
DB Support: MySQL
DB Support: PostgreSQL
DB Support: SQL Server Column default value is quoted badly if default is a function call when generating DDL
DB Support: Oracle
Can not see synonyms in the tree view for synonym with DB link
DB Support: Oracle
Parameterized SQL Parameter marker in quoted literal is detected while it shouldn't
Parameterized SQL Parameter marker in quoted literal is detected while it shouldn't
DB Support: PostgreSQL
References Tables not shown if constraints are named the same
References Tables not shown if constraints are named the same
Data tab
Filtering/Filter Sets Issues with filter editor related to IN and BETWEEN clauses
Filtering/Filter Sets Issues with filter editor related to IN and BETWEEN clauses
Database Objects Tree
Double-click outside the grid in the Connections grid results in an error
Import
Importing Table Data from CSV or Excel may include escape symbols in text data (ex ' and '')
Key Bindings
"Home" key binding not mapped for Linux/UNIX
References
Reference graph does not honor tables when "Specified Tables" is selected
Reference graph is not refreshed when changing setting "One Link/Column"
Reference Graph does not handle combined keys unless One Link/Column is selected
Reference graph is not refreshed when changing setting "One Link/Column"
Reference Graph does not handle combined keys unless One Link/Column is selected
SQL Formatter
SQL formatter may clear the output
11.0.4 - Released 2020-07-09
Improvements
Area
Details
@import
Trim text field on import for all import types
DB Support: Exasol
Updates for Exasol 7
DB Support: Redshift
Upgrade the Redshift driver to support IAM authentication
DB Support: Snowflake
Show server parameters under DBA->Server Info
Bugs Fixed
Area
Details
@import
Strange results during @import
@import shows failure at end of data
@import shows failure at end of data
Connection Setup
The 'Global Properties' link in connection properties doesn't work
Create/Alter Table
DB Support: PostgreSQL
DB Support: Snowflake When setting Nullable or Default in Alter Table the column name is not delimited potentially leading to "column not found"
DB Support: PostgreSQL
DB Support: Snowflake When setting Nullable or Default in Alter Table the column name is not delimited potentially leading to "column not found"
Create/Alter Table
DB Support: SQL Server SQL Server DATETIME2 type precision lost when doing Alter Table
DB Support: SQL Server SQL Server DATETIME2 type precision lost when doing Alter Table
DB Support: Informix
DDL Generator Showing DDL for functional index doesn't work
DDL Generator Showing DDL for functional index doesn't work
DB Support: MySQL
Export of embedded special characters in data should be escaped
DB Support: PostgreSQL
Wrong DDL generated for Index if index column contains expression
DB Support: PostgreSQL
Export Bug while exporting schema in SQL file (PostgreSQL)
Export Bug while exporting schema in SQL file (PostgreSQL)
DB Support: SQL Server
Import Importing CSV automatically maps Strings to SSN type
Import Importing CSV automatically maps Strings to SSN type
Export
Can not open exported excel file
Open in Spreadsheet with a 1M rows result set, shows the in progress dialog and when stopped, DbVisualizer works as normal but CPU runs high
Open in Spreadsheet with a 1M rows result set, shows the in progress dialog and when stopped, DbVisualizer works as normal but CPU runs high
File Chooser
Regression in 'Clear All Recent Paths' action in File Chooser->Recent Paths drop-down
Grid Component
Making a column visible in the column chooser doesn't work
Import
Cannot clean old imports if one or more files or directories in the import directory lack read access
Mail Support
Clicking Apply in the Tool Properties window, the currently selected Mail Server account resets to the first in list
SQL Commander
Any exception during script pre processing is not reported
A quoted string containing an escaped quote and single line comment identifiers may result in errors
When merging small but wide result sets the horizontal scrollbar is invisible
A quoted string containing an escaped quote and single line comment identifiers may result in errors
When merging small but wide result sets the horizontal scrollbar is invisible
SQL Editor
Regular-Expression-Replacement does not work as expected with $
SQL Formatter
The SQL formatter converts TABLESPACE to TABLE
Formatting splits schema
Formatting splits schema
11.0.3 - Released 2020-05-21
Bugs Fixed
Area
Details
References
Regression in References graph resulting in an error in some configurations
11.0.2 - Released 2020-05-21
Improvements
Area
Details
Connection Setup
Translate certain SSH error messages during connect to be more helpful
Should be possible to opt-out from automatically showing the Single Physical connections popup during connect of such connection
Should be possible to opt-out from automatically showing the Single Physical connections popup during connect of such connection
DB Support: SQL Server
Support for the history table of a temporal table in the database tree
Generate drop alter and drop for temporal tables when creating Drop DDL.
Generate drop alter and drop for temporal tables when creating Drop DDL.
DB Support: Snowflake
Better error message when VIEW definition is empty
References
yFiles Add guidelines what to do when an out of memory error occurs during export of references graph
yFiles Add guidelines what to do when an out of memory error occurs during export of references graph
Bugs Fixed
Area
Details
DB Support: Mimer SQL
Saving table data edits may truncate CLOB edits in Mimer SQL
DB Support: Oracle
Object View Grants are not always displayed for a database object
Object View Grants are not always displayed for a database object
Database Objects Tree
Regression in 11.0 and 11.0.1 whereas Open Object and Show Object at Cursor may take long time to complete or even show wrong object
Export
Grid Component Error when "Export Visible" having a larger Max Rows than number of actual rows
Grid Component Error when "Export Visible" having a larger Max Rows than number of actual rows
Export/Import User Settings
Import User settings may generate an exception
Query Builder
Query Builder handles NOT and parentheses wrong in some cases
References
Primary key relationship are duplicated in Diagram
SQL Formatter
FORMAT for EXTERNAL Tables un-formats
11.0.1 - Released 2020-04-29
Improvements
Area
Details
DB Support: DB2 LUW
DB Support: SQL Server Export DDL for SQL Server and DB2 Temporal Tables (GENERATED AS)
DB Support: SQL Server Export DDL for SQL Server and DB2 Temporal Tables (GENERATED AS)
Installation/Update Installation
OS Support: Linux Make installation on Fedora linux more according to convention
Highlight when installing DbVisualizer in an environment where no display is available
Warn when running DbVisualizer in an environment where no display is available
Make installation on Ubuntu Linux more according to convention
OS Support: Linux Make installation on Fedora linux more according to convention
Highlight when installing DbVisualizer in an environment where no display is available
Warn when running DbVisualizer in an environment where no display is available
Make installation on Ubuntu Linux more according to convention
OS Support: macOS
Window title bars color should adapt with light or dark mode in macOS
Bugs Fixed
Area
Details
@import
@import target fails on data type of not-imported column
Create/Alter Table
DB Support: MySQL ALTER TABLE shows SQLs in the preview even though no changes has been made
DB Support: MySQL ALTER TABLE shows SQLs in the preview even though no changes has been made
Create/Alter Table
DB Support: Oracle DDL generated by the Alter Table action includes the VISIBILITY clause even if not set/changed
DB Support: Oracle DDL generated by the Alter Table action includes the VISIBILITY clause even if not set/changed
DB Support: Oracle
Constraints with DEFERRABLE and DEFERRED properties are exported as regular Constraints for tables
DB Support: Redshift
There are no object views for Procedures and Procedure objects in the Databases tab for Redshift
DB Support: SQL Server
DDL Generator Generated DDL for index is incomplete if it contains the INCLUDE clause
DDL Generator Generated DDL for index is incomplete if it contains the INCLUDE clause
DDL Generator
DDL not refreshed after Alter Table
Data tab
Max Rows on First Display = 0 is not honored
Database Objects Tree
Right-click in the Databases tab having "Autoscroll TO Object View tab" enabled, will not only show the popup menu but also open the object
Row labels may be presented with different fonts in the Databases tab
Sudden error in the Databases tab
Row labels may be presented with different fonts in the Databases tab
Sudden error in the Databases tab
Database Profile: View
Having viewer="text" for a DataView shows it as viewer="grid"
Grid Component
Clicking in the area outside the data in a grid should focus the grid
Query Builder
Query builder may generate wrong SQL
References
In References graph, "selected tables" only include outbound relations
SQL Formatter
SQL Formatter alters DbVis Variables ${...}$
11.0 - Released 2020-04-09
New Features
Area
Details
@import
Add a client-side command for import allowing to import table data in SQL scripts
DB Support: MariaDB
Add support for MariaDB
DB Support: Snowflake
Add extended support for Snowflake
Mail Support
SQL Commander Add @mail client side command used to email the result set from a query or file
SQL Commander Add @mail client side command used to email the result set from a query or file
SQL Commander
Add a "Morph to Delimited List" function in the SQL Commander
Add new @open <file | URL> command used to open file in associated program or URL in web browser
Add new @open <file | URL> command used to open file in associated program or URL in web browser
Improvements
Area
Details
Cell Viewer/Editor
Add options to format/unformat JSON in the cell editor
Chart
Resizing Charts on export distorts geometry
Add more color schemes for charts
Add more color schemes for charts
Command Line Support (dbviscmd)
dbviscmd should prompt for variables in connection details and variables used in scripts
The dbviscmd script should use the same environment and JRE detection as the launcher for the GUI (dbvis)
The dbviscmd script should use the same environment and JRE detection as the launcher for the GUI (dbvis)
Create/Alter Table
DB Support: MySQL Add support for check constraints in the Create/Alter table dialog for MySQL
DB Support: MySQL Add support for check constraints in the Create/Alter table dialog for MySQL
Create/Alter Table
DB Support: Oracle Make it possible to change the visibility of a column through the Create and Alter table dialog
DB Support: Oracle Make it possible to change the visibility of a column through the Create and Alter table dialog
DB Support: DB2 LUW
Add user and role information for DB2 LUW
DB Support: Exasol
Always pass SQLs to the Exasol database with LF instead of CRLF line separators
Enable the Procedure Editor for UDFs and Functions in Exasol
Enable the Procedure Editor for UDFs and Functions in Exasol
DB Support: MySQL
DDL Generator Improve support of the ON UPDATE clause for temporal types for MySQL
DDL Generator Improve support of the ON UPDATE clause for temporal types for MySQL
DB Support: MySQL
Procedure Editor Automatically set SQL Mode when editing Procedures and Functions
Procedure Editor Automatically set SQL Mode when editing Procedures and Functions
DB Support: PostgreSQL
Query Builder Add support for ~, !~, ~*, !~* operators in the Query Builder for PostgreSQL
Query Builder Add support for ~, !~, ~*, !~* operators in the Query Builder for PostgreSQL
Data tab
Add capability to set a key binding for the generic "Stop" action
Option to prevent any filter from being used when loading a table during its first display
Data tab should have a "Reload with Sorting as ORDER BY" action used to reload from database using a ORDER BY clause defined by the current sorting in the grid
Option to prevent any filter from being used when loading a table during its first display
Data tab should have a "Reload with Sorting as ORDER BY" action used to reload from database using a ORDER BY clause defined by the current sorting in the grid
Database Objects Tree
Show all contained database connections when selecting a database connections folder
Need capability to make it easier to scope what database connections that should be updated in multi connections edits
Need capability to make it easier to scope what database connections that should be updated in multi connections edits
Database Objects Tree
Database Profile: Commands For DB2 LUW and using the Generic profile, there is a (null) catalog node in the Databases tab
Database Profile: Commands For DB2 LUW and using the Generic profile, there is a (null) catalog node in the Databases tab
Driver Manager
Update bundled JDBC drivers
Export
For Excel exports, the "Include original SQL" setting in Export Grid and for @export ExcelIncludeSQLCommand parameter should allow: "sheet" parameter in addition to "none", "top", "bottom"
The Open as Spreadsheet action should put the SQL in a separate sheet
Rename "XLS" output format to "Excel" and accept "XLS" or "XLSX" (default) in the "ExcelFileFormat" parameter in @export
Add "Auto Resize Columns" for Excel export
Add new "Export Visible" and "Open Visible as Spreadsheet" actions for grids that considers any current filters, sorting, and visible columns in the grid
The Open as Spreadsheet action should put the SQL in a separate sheet
Rename "XLS" output format to "Excel" and accept "XLS" or "XLSX" (default) in the "ExcelFileFormat" parameter in @export
Add "Auto Resize Columns" for Excel export
Add new "Export Visible" and "Open Visible as Spreadsheet" actions for grids that considers any current filters, sorting, and visible columns in the grid
Favorites
Opening a favorite object for a database connection that fail to establish give no visible feedback that there is a problem
Grid Component
Add a new Copy Selection As->Copy Selection as AND/OR clause
Key Bindings
Possible to assign a modifier with TAB as key binding
Should be possible to easily browse all available keyboard shortcuts
Key bindings editor need a filtering/search capability to locate an existing key binding and filtering
Should be possible to easily browse all available keyboard shortcuts
Key bindings editor need a filtering/search capability to locate an existing key binding and filtering
References
Selected table nodes in the references graph should not change background color
When Highlight Links is checked, do also color code the associated column names in the source and target nodes
Table references to self (same table) should attach to the corresponding column names when using Hierarchic layout and not in random positions
Certain controls in the References graph requires Hierarchic layout. Highlight this condition for controls when not using hierarchic layout mode
When Highlight Links is checked, do also color code the associated column names in the source and target nodes
Table references to self (same table) should attach to the corresponding column names when using Hierarchic layout and not in random positions
Certain controls in the References graph requires Hierarchic layout. Highlight this condition for controls when not using hierarchic layout mode
SQL Commander
Add new "Set Modified State when Scripting" setting in Tools->Tool Properties under General / SQL Commander
Add "Change Default Values..." in the SQL Commander Options menu and SQL Commander toolbar drop-down
Show the full path for the current database connection when hovering the Database Connection drop-down
Have an option in SQL Commander to generate a dbviscmd command string that can be pasted in a terminal
Refresh of the object tree (as a result of for example filtering) does not refresh the Catalog/Schema drop-down lists
Add "Change Default Values..." in the SQL Commander Options menu and SQL Commander toolbar drop-down
Show the full path for the current database connection when hovering the Database Connection drop-down
Have an option in SQL Commander to generate a dbviscmd command string that can be pasted in a terminal
Refresh of the object tree (as a result of for example filtering) does not refresh the Catalog/Schema drop-down lists
SQL Editor
Offer GUI help for regular Expression replacement text (similar to the helper for the Find text)
Show visible margin at user specified column
Add support for adding linefeed, tab etc. in the replacement text in the Replace dialog
Show visible margin at user specified column
Add support for adding linefeed, tab etc. in the replacement text in the Replace dialog
SQL Formatter
Allow setting indent for joins INNER, LEFT OUTER, RIGHT OUTER
Allow for having multiple SQL Formatting profiles
SQL Formatter should use the keyword lists defined for each supported database (use when for example upper/lower case keywords)
Make it possible to add custom keywords that are upper/lowercased along with standard
Introduce a new SQL Formatter
Add multiple indentation levels and other improvements
The Format SQL->Copy/Paste Formatted should allow setting that formatting should not be applied
Allow for having multiple SQL Formatting profiles
SQL Formatter should use the keyword lists defined for each supported database (use when for example upper/lower case keywords)
Make it possible to add custom keywords that are upper/lowercased along with standard
Introduce a new SQL Formatter
Add multiple indentation levels and other improvements
The Format SQL->Copy/Paste Formatted should allow setting that formatting should not be applied
SQL Log
Allow configuring what columns and order should be displayed in the SQL Log tab for SQL Commanders
Table Data Editor
Add a link to tool properties when the "Number of rows limited by <link>Max Rows at First Display</link> setting" balloon in the data tab is displayed
Tool Properties
Allow user to edit the sample text when choosing fonts
Bugs Fixed
Area
Details
Auto Completion
Having Fully Qualify Objects for Auto Completion and then AC a table name, database.null.table is inserted
Chart
When exporting graph the width and height does not always honor the selected orientation
Connection Setup
Copying driver property name copies the wrong name if entries are filtered
DB Support: DB2 LUW
SQL Commander Stopped query leaves locks on SYSIBM tables
SQL Commander Stopped query leaves locks on SYSIBM tables
DB Support: H2
DDL Tab for Table with Identity columns are not generated correctly when H2 1.4.199 is used
DB Support: PostgreSQL
For some PostgreSQL installations the pg_catalog.pg_database is empty resulting in no databases being displayed in the databases tab
Space is inserted in middle of Operator when formatting
Space is inserted in middle of Operator when formatting
Data tab
Generate Filter for quoted string fails
Data tab
Grid Component NULL and duplicated values not handled properly in "Copy Selection as IN Clause" and "Generate Filter & Sort"
Grid Component NULL and duplicated values not handled properly in "Copy Selection as IN Clause" and "Generate Filter & Sort"
Database Profile: Actions
Main windows locks when shutting down action dialogs in the wrong order
Explain Plan
Performance/Stability Show confirm dialog when executing explain plan with multiple statements
Performance/Stability Show confirm dialog when executing explain plan with multiple statements
Export
Exporting Binary/BLOB to File with JSON format outputs the binary data as is rather than the special ${data8-1||blob/8.png||BinaryData||noshow vl=file}$
Export
Import Malformed XML generated when export DbVis style XML
Import Malformed XML generated when export DbVis style XML
OS Support: Linux
Application icons on Linux are blurry when placed on desktop, and present in the application (task) switcher
Procedure Editor
SQL Editor The line break style (CRLF or LF) should be retained when editing an existing file or database code object
SQL Editor The line break style (CRLF or LF) should be retained when editing an existing file or database code object
Query Builder
Conditions tab tree row heights are too small when loading a query in the query builder
References
Remove link "handles" in the references graph that are visible on self referencing tables
SQL Commander
Find and Replace with regular expression does not work
Some ${dbvis-xxx}$ variables are not case sensitive
Some ${dbvis-xxx}$ variables are not case sensitive
SQL Editor
Using Ctrl+A/Cmd+A keybinding to Select All will not enable some right-click actions unless opening the menu again
SQL Formatter
When applying the SQL formatter the schema name in some situations may be preceded by blanks
UNLOGGED keyword with create table statement breaks formatting
Script Table as INSERT adds the schema in uppercase when SQL formatted
Having comments in a WITH clause breaks the SQL formatting
Format with string literals longer than max Line Width results in invalid SQL
UNLOGGED keyword with create table statement breaks formatting
Script Table as INSERT adds the schema in uppercase when SQL formatted
Having comments in a WITH clause breaks the SQL formatting
Format with string literals longer than max Line Width results in invalid SQL
Scripts
If focus not in the Scripts tab, renaming a file using right-click immediately cancels the editing