Version: 4.2.15.0 $$$Date: 2025-07-02 $$$Release note: $$$Bug Fix.

Version: 4.2.13.0 $$$Date: 2025-06-03 $$$Release note: $$$Bug Fix.

Version: 4.2.13.0 $$$Date: 2025-06-03 $$$Release note: $$$Bug Fix.

Version: 4.2.12.0 $$$Date: 2025-05-02 $$$Release note: $$$Adjusted the zoom ratio for the specified lens.

24.3.3 - Released 2025-01-17$$$Auto-Completion:$$$Auto-completion doesnt work when the metadata cache is disabled$$$Exception when auto-completing columns$$$Exception when closing the auto-completion popup$$$Exception when opening auto-completion settings$$$$$$Cell Viewer/Editor:$$$$$$Text is not rendered when previewing PDF documents$$$$$$$$$Cell Viewer/Editor:$$$OS Support: Windows$$$$$$Wrong encoding when saving CLOBs on Windows$$$$$$$$$Check for Update:$$$$$$Cant disable check for update$$$$$$Connection Setup:$$$Master password prompt is displayed twice$$$$$$Create/Alter Table:$$$The + button in the Alter Table dialog is disabled unless there is a selection in the grid$$$$$$$$$DB Support: Databricks:$$$Some data types are not generated correctly in function DDL$$$The contents of the hive_metastore catalog is not displayed correctly in the database objects tree$$$$$$DB Support: Salesforce:$$$Exception when connecting to Salesforce$$$$$$Driver Manager:$$$Cant set password-protected properties before driver artifacts have been downloaded$$$$$$Favorites:$$$Exception in Add to Favorites$$$$$$Metadata:$$$Metadata cache breaks if a column default is too long$$$$$$Performance/Stability:$$$SQL Commander$$$Displaying a result set may be slow if there are many tables in the database$$$Unresponsive GUI when executing a script with many statements$$$$$$SQL Commander:$$$Large templates may break the editor template popup$$$$$$Tool Properties:$$$Exception when discarding changes in Tool Properties$$$Font settings dont always affect grids and lists consistently$$$

24.3.2 - Released 2024-12-17$$$Bugs Fixed $$$Area$$$Details$$$Auto-Completion$$$Potential exception when moving the caret while the auto-completion popup is open$$$Command Line Support (dbviscmd)$$$Unable to connect when using the -url parameter with dbviscmd$$$DB Support: MariaDB$$$Some keywords break CREATE FUNCTION for MariaDB$$$DB Support: PostgreSQL$$$The same collation may be listed twice in Create/Alter Table$$$DB Support: Redshift$$$Handle changed letter case in connection parameters for Redshift$$$Export/Import User Settings$$$When importing user settings; unchecking SQL Commanders has no effect$$$General$$$An empty main window may be displayed at application start$$$Procedure Editor$$$Package navigator may be displayed for single functions$$$SQL Commander$$$Scrolling in the editor stops working

Improvements $$$Area$$$Details$$$DB Support: Snowflake$$$Add a connection setting to control the query result format in Snowflake to help avoid Arrow-related issues$$$Bugs Fixed $$$Area$$$Details$$$Auto-Completion$$$Misaligned text in the auto-completion popup$$$Cell Viewer/Editor$$$Performance/Stability$$$Opening a cell containing a long single-line JSON value takes a long time$$$Database Objects Tree$$$Visual issues with tooltips in the database objects tree when display scaling is used$$$Grid Component$$$Primary key indicator is missing in data grids for some databases$$$SQL Commander$$$Disallow horizontal scrolling when using the trackpad to zoom editor text$$$Exception in Show Object at Cursor if no database connection is selected$$$Exception when expanding editor templates$$$Tool Properties$$$Long search text may break the visual layout in Tool Properties

24.3 - Released 2024-11-27$$$New Features $$$Area$$$Details$$$Connection Setup$$$Tool Properties$$$Add a search feature to Tool Properties and Connection Properties$$$DB Support: Databricks$$$Add extended support for Databricks$$$DB Support: MariaDB$$$DB Support: MySQL$$$DB Support: SingleStore$$$Add support for the LOAD DATA command for MySQL; MariaDB and SingleStore$$$Grid Component$$$Add support for text wrapping in data grids$$$Installation/Update Installation$$$Introduce in-app updates to simplify the application update process$$$Performance/Stability$$$Introduce a persistent database metadata cache$$$SQL Commander$$$Easily switch between recent editor tabs$$$Zoom editor text using the mouse scroll wheel$$$Improvements $$$Area$$$Details$$$Auto-Completion$$$Automatically adjust the size of the auto-completion popup$$$Implement inline configuration in the auto-completion popup$$$Improve the handling of letter case when using auto-completion for tables and columns$$$Improved positioning of the auto-completion popup in multi-screen setups$$$Create/Alter Table$$$Add support for user-defined data types in Create/Alter Table$$$DB Support: H2$$$Warn about potential incompatibilities when upgrading H2 database drivers in existing connections$$$DB Support: MariaDB$$$DB Support: MySQL$$$Add a setting to control the handling of YEAR values in MySQL and MariaDB$$$DB Support: MySQL$$$Add support for MySQL 9$$$Support detection of new driver versions for MySQL (in spite of changed artifact coordinates)$$$DB Support: PostgreSQL$$$Improve the efficiency of the Max Rows setting in the Data tab for PostgreSQL$$$DB Support: Vertica$$$Detect version mismatch between the database server and the driver for Vertica$$$Database Objects Tree$$$Format and color table row counts in the database objects tree$$$Driver Manager$$$Update template drivers$$$General$$$Add support for saving transparent colors$$$Java$$$Bundle Java 21 with installers$$$OS Support: Windows$$$Performance/Stability$$$Improve the performance of File->Open Recent for slow drives$$$SQL Commander$$$Add a preview section to the editor template popup$$$Display intermediate search results in Show Object at Cursor$$$Improved support for international characters in result tab names$$$SQL Editor$$$Improve the performance of Find and Replace for large documents$$$UX/UI$$$Ask for confirmation before closing the contact support dialog$$$Simplify copying names; paths and row counts in the GUI$$$Updated welcome screen$$$Bugs Fixed $$$Area$$$Details$$$Auto-Completion$$$An extra delimiter may be inserted when auto-completing qualified table names$$$Auto-completion doesnt always work in CASE statements$$$Auto-completion doesnt work following function calls in the WHERE clause$$$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$$$Favorites may be imported incorrectly in some cases$$$Proxy password may not be imported correctly$$$Import$$$Exception when executing import on a disconnected database$$$Possible exception when importing table data$$$Installation/Update Installation$$$The application installer should use the Downloads directory by default$$$Performance/Stability$$$Intermittent exception in the grid component$$$Query Builder$$$QueryBuilder fails to load a valid query if identifier case differs from the metadata$$$SQL Editor$$$Exception in the code editor$$$UX/UI$$$Popup windows may briefly flash with a light background when opening$$$Some panels in Tool Properties are not scrollable$$$Status text is the progress dialog may be cut off$$$UI issue in proxy settings

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

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: MariaDB$$$Exception in Drop Package$$$DB Support: MariaDB$$$DB Support: SingleStore$$$Alter Table doesnt 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: 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$$$Export$$$Quote Text Value is not set correctly when loading export settings$$$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$$$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$$$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 doesnt 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 doesnt 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$$$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$$$Export$$$Text trim doesnt work when exporting data in JSON format$$$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$$$Scripts$$$Exception when renaming a file in the Scripts tab

24.1.4 - Released 2024-04-15$$$BUGS FIXED $$$AREA$$$DETAILS$$$Auto-Completion$$$Possible exception when auto-completing client-side commands$$$Should be able to auto-complete columns even if the table name is not the right case$$$Tooltip for columns in a subquery table shows wrong table name$$$Improve auto-completion of columns in subqueries$$$Check for Update$$$Automatic check for update does not detect available versions$$$DB Support: MySQL$$$Alter Event generates invalid SQL if ENDS is not defined for recurring events$$$Grid Component$$$Exception when dragging data from a grid$$$Find Column does not always detect matching columns$$$OS Support: Windows$$$Exception when saving a file that has trailing spaces in the file name$$$Object View$$$Object view panes may be rendered on top of each other$$$Procedure Editor$$$SQL Commander$$$Script execution errors are not reported for certain error types$$$Query Builder$$$Expressions in the columns tab are not updated when editing using the cell editor$$$SQL Commander$$$If several SQL warnings with the same message are raised; only one of them is displayed in the Log tab$$$Unsaved tabs may contain path instead of content on application startup$$$Exception when executing multi-line @run commands$$$SQL Editor$$$Duplicate Line or Selection does not work when triggered on the last line of the document$$$Possible exception when selection changes in the editor

24.1 - Released 2024-01-08$$$NEW FEATURES $$$AREA$$$DETAILS$$$Connection Setup$$$Database Objects Tree$$$Add an action allowing to create a connection from a database URL$$$Driver Manager$$$Automatically detect when new driver versions are available$$$SQL Editor$$$Build a new SQL editor$$$Build a new auto-completion engine$$$Build a new solution for Find and Replace as an inline panel in the editor$$$Workspace$$$Add support for workspaces$$$IMPROVEMENTS $$$AREA$$$DETAILS$$$@import$$$Allow comments in the column mapping file$$$Connection Setup$$$DB Support: MariaDB$$$DB Support: MySQL$$$Warn if MySQL driver is used when connecting to MariaDB$$$Create/Alter Table$$$DB Support: SQLite$$$Rename and drop columns in SQLite using the Alter Table dialog$$$DB Support: ClickHouse$$$Add support for materialized views$$$DB Support: Google BigQuery$$$DB Support: SingleStore$$$DB Support: Vertica$$$Performance/Stability$$$Improve read performance for large result sets (LIMIT clause)$$$DB Support: Oracle$$$Add Grant Privilege action for materialized views; functions and procedures$$$DB Support: Oracle$$$Performance/Stability$$$Improve read performance for large data sets (fetch size)$$$DB Support: SAP Hana$$$Add driver entry and database type for SAP Hana$$$DB Support: SQL Server$$$Database Objects Tree$$$Display column default constraints in the database objects tree$$$DB Support: SingleStore$$$Add the Native DDL tab for pipelines$$$DB Support: Vertica$$$Add an action to create stored procedures in Vertica$$$Driver Manager$$$Update template drivers$$$Export$$$Add support for database-specific multi-row INSERT syntaxes$$$Grid Component$$$Row Form Viewer/Editor$$$Add navigation buttons to the row form viewer/editor$$$Performance/Stability$$$SQL Commander$$$Improve the performance of stale files checking for slow drives$$$Release memory faster after closing editor tabs$$$Release memory faster after script execution$$$References$$$Add an option to control the background color when exporting a references graph in SVG format$$$SQL Editor$$$Support for groups when using regular expressions in Find and Replace$$$Security$$$Streamline handling of master password to improve user experience$$$Theme$$$Adjust window sizes to the selected application font$$$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$$$Cannot reset driver property value to driver default$$$Show connection information and make database capabilities searchable in the Database Info tab$$$Cannot apply changes when editing multiple database connections at once$$$Connection Setup$$$Driver Manager$$$Unsaved driver properties warning is displayed even when there are no changes$$$Connection Setup$$$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: Cassandra$$$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$$$Show warnings reported by JDBC via ResultSet$$$DB Support: Greenplum$$$DB Support: PostgreSQL$$$DDL Generator$$$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$$$Source code is displayed without line breaks in Java Sources$$$Internal columns in the objects tree; generated DDL and table data editor$$$DB Support: Redshift$$$Column ordering for external tables in Redshift$$$DB Support: Redshift$$$Procedure Editor$$$Procedure editor remov

23.2.5 - Released 2023-10-03$$$IMPROVEMENTS$$$AREA$$$DETAILS$$$SSH$$$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$$$Contact Support$$$Adapt dialog size when application font size changes$$$DB Support: Greenplum$$$DDL Generator$$$PARTITION BY clause is missing from table DDL$$$DB Support: Informix$$$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$$$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$$$Grid Component$$$Auto resize column widths should be preserved between reloads$$$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.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$$$Table Data Editor$$$The permission checker doesnt issue a warning when updating or deleting rows in the table data editor