Release Notes 9.5.1Release Notes 9.5.1

Version Date
9.5.1 2016-08-17
9.5 2016-06-15 W
9.2.17 2016-06-19
9.2.16 2016-06-15
9.2.15 2016-03-09
9.2.14 2015-12-22
9.2.13 2015-11-19
9.2.12 2015-10-21
9.2.11 2015-10-19
9.2.10 2015-08-26
9.2.9 2015-07-31
9.2.8 2015-06-28
9.2.7 2015-05-13
9.2.6 2015-04-16
9.2.5 2015-03-17
9.2.4 2015-03-05
9.2.3 2015-02-25
9.2.2 2015-02-18
9.2.1 2015-01-29
9.2 2015-01-12 W
9.1.13 2015-01-11
9.1.12 2014-11-27
9.1.11 2014-10-14
9.1.10 2014-08-08
9.1.9 2014-06-11
9.1.8 2014-04-15
9.1.7 2014-03-07
9.1.6 2014-01-26
9.1.5 2013-12-16
9.1.4 2013-12-07
9.1.3 2013-11-22
9.1.2 2013-10-27
9.1.1 2013-10-01
9.1 2013-09-09 W P
9.0.9 2013-08-28
9.0.8 2013-07-16
9.0.7 2013-06-04
9.0.6 2013-04-15
9.0.5 2013-03-05
9.0.4 2013-02-19
9.0.3 2013-01-26
9.0.2 2012-12-18
9.0.1 2012-12-17
9.0 2012-11-29 W P
8.0.12 2012-11-27
8.0.11 2012-09-27
8.0.10 2012-07-10
8.0.9 2012-04-30
8.0.8 2012-02-14
8.0.7 2011-12-22
8.0.6 2011-11-22
8.0.5 2011-11-03
8.0.4 2011-09-16
8.0.3 2011-08-30
8.0.2 2011-08-07
8.0.1 2011-06-29
8.0 2011-06-16 W P
7.1.5 2011-02-24
7.1.4 2010-11-23
7.1.3 2010-09-10
7.1.2 2010-08-18
7.1.1 2010-06-23
7.1 2010-06-16 W
7.0.8 2010-06-16
7.0.7 2010-05-25
7.0.6 2010-04-21
7.0.5 2010-03-16
7.0.4 2010-02-24
7.0.3 2010-02-23
7.0.2 2010-02-03
7.0.1 2010-01-29
7.0 2010-01-15 W P
6.5.12 2009-12-22
6.5.11 2009-12-05
6.5.10 2009-10-23
6.5.9 2009-08-29
6.5.8 2009-08-27
6.5.7 2009-06-19
6.5.6 2009-05-15
6.5.5 2009-04-06
6.5.4 2009-02-06
6.5.3 2009-01-12
6.5.2 2009-01-09
6.5.1 2008-11-23
6.5 2008-10-23 W P
6.0.15 2008-10-20
6.0.14 2008-09-22
6.0.13 2008-08-19
6.0.12 2008-06-26
6.0.11 2008-05-28
6.0.10 2008-04-10
6.0.9 2008-03-17
6.0.8 2008-02-24
6.0.7 2007-12-06
6.0.6 2007-10-15
6.0.5 2007-10-08
6.0.4 2007-09-25
6.0.3 2007-09-17
6.0.2 2007-07-25
6.0.1 2007-07-16
6.0 2007-07-09 W P
5.1.1 2006-10-16
5.1 2006-10-05 W P
5.0 2006-04-03 W P
4.3.6 2006-01-08
4.3.5 2005-10-06
4.3.4 2005-09-07
4.3.3 2005-08-19
4.3.2 2005-07-23
4.3.1 2005-07-05
4.3 2005-07-03 W P
4.2.2 2005-02-19
4.2.1 2005-02-11
4.2 2005-01-12 W P
4.1.1 2004-06-16
4.1 2004-04-06 W P
4.0.4 2004-01-20
4.0.3 2004-01-15
4.0.2 2003-11-07
4.0.1 2003-10-24
4.0 2003-10-22 W
3.3.1 2003-07-05
3.3 2003-06-07 W
3.2 2003-02-12 W
3.1.1 2002-12-09
3.1 2002-10-20 W
3.0 2002-07-01 W
2.1 2001-10-30
2.0.1 2001-05-18
2.0 2001-04-20
1.2.1 2000-12-23
1.2 2000-11-11
1.1 2000-06-05
1.0 1999-12-06

DbVisualizer 9.5.1 - Change Log

Enhancement

DB Support: Oracle
References
Add option to set /*+RULE*/ hint for query getting referenced tables
Export Exporting to binary Excel and exceeding 65K rows should show a more meaningful error message and suggestion to use XLSX instead
Grid Component Add drop-down filtering capability in grid column headers
Workspace Make the draggable divider between SQL Commander and results tabs easier to find (bigger)

Bug

Connection Setup Exception when disconnecting from server
Create/Alter Table Adding new index or foreign key doesn't always select the newly added entry
Create/Alter Table Alter Table should clear some attributes when changing data type
DB Support: DB2 LUW Row Change Timestamp column constraint not included in DDL
DB Support: DB2 z/OS
SQL Commander
Schema filters are not applied in the schema drop-down list
DB Support: Hive
DB Support: Phoenix
DatabaseException: Could not set catalog to: NoCatalogKey for: Phoenix: null
DB Support: Informix Delimited identifier should not be used in the informix.getTableTriggers command
DB Support: JavaDB/Derby Exceptions may occur if using a version of the JDBC driver not compatible with the database version
DB Support: MySQL AUTO_INCREMENT clause not inserted when Auto Increment is selected in Alter Table
DB Support: MySQL
DDL Generator
DDL does not quote default value for enum
DB Support: Netezza Only test for multiple schema support for database versions greater than 7.0
DB Support: Oracle Fail to open index Sub partitions as index name is null
DB Support: Oracle Having Delimited Identifiers for Scripting enabled erroneously enclosed parameters for "kill session"
DB Support: Oracle Condition missing in SELECT for getting table indexes
DB Support: Phoenix There is a (null) schema in the database objects tree for HBase/Phoenix which gives side effects in that Data and Row Count tabs for tables results in a DB error
DB Support: PostgreSQL Looking at tablespace info in versions older than PostgreSQL 9.0 gives an error
DB Support: PostgreSQL Collations should only be fetched for PostgreSQL 9.1+
DB Support: PostgreSQL There is no "(Default)" label for a database when logging in with no database specified in connection details
DB Support: PostgreSQL Having Single Physical Connection enabled and Auto Commit off doesn't work as expected
DB Support: PostgreSQL
References
Using Open in New Tab in references graph doesn't work for PostgreSQL
DB Support: Presto
References
References graph for Presto shows only table names and no columns information
DB Support: SQL Server Errors when connecting to SQL Server older than 2008
DB Support: SQL Server
DB Support: Sybase ASE
The database objects tree for the generic profile may not show the correct schemas for an expanded database
DB Support: SQL Server
Export
Errors while retrieving database objects for export doesn't render these with the error icon and red text as in the Databases tab
DB Support: SQL Server
Export
"The statement is closed" error when launching export schema
DB Support: Sybase ASE Database Devices view does not work for versions earlier than Sybase ASE 15
DB Support: TeraData GUI may be unresponsive when loading thousands of objects in the Databases tab
DDL Generator DDL generation fails if driver throws an exception getting primary keys
Data tab Script to SQL Commander->UPDATE WHERE and the generated "where" clause always refer first column and not selected columns
Database Objects Tree Highlighting a database object in the Databases tab by click on Select in the disconnected object view tab or by the object path fail in some situations
Database Objects Tree Reload/reconnect with thousands of expanded nodes in the Databases tab is slow
Database Objects Tree UI painting problems in Databases tab after opening File->Import Settings
Database Objects Tree Exception: "path in TreePath must be non null" when reloading filters
Database Objects Tree
DB Support: Vertica
Expanding the Columns node for a table takes longer than it should
Database Objects Tree
Object View
Memory leaks and slow performance in databases tab when there are many thousands objects
Database Profile: Tree
DB Support: Presto
DB Support: Snowflake
Schema names displayed as "(null)" for Presto and Snowflake
Database Search IllegalStateException when doing a search again after an object tree refresh
Database Search
DB Support: SQL Server
NPE when getting View column info for an IDENTITY column
Export No icon found for: "Error" reported when expanding objects types check box tree in export schema and there was a database error getting the objects
Filtering/Filter Sets Show Only Default Database/Schema should do case insensitive comparison
Monitor Data Monitor doesn't work with PostgreSQL
Monitor
Scripts
Clicking or opening a MySQL Scripts file for a connected connection with Java 7 gives exception while with Java 8 the UI is not properly painted
OS Support: Mac OS X "Invalid Seal" error when starting DbVisualizer with a newly installed license key
SQL Commander Connecting a database connection that have thousands of schemas, and if a SQL Commander tab for that connection is visible, the GUI hangs
SQL Commander Any value in Max Chars in SQL Commander doesn't have any effect
SQL Editor Rectangular edit issue when copy/paste
[http://support.dbvis.com/support/discussions/topics/1000077551 ]
Scripts Renaming bookmarks folder makes a file in the folder show as two nodes