26.2.2 - Released 2026-08-13$$$Improvements $$$Database Objects Tree$$$Start quick search in the Databases tab from the currently selected position$$$Export$$$Add the ability to set a default sheet name for Excel exports$$$Grid Component$$$Make the time component optional when entering timestamps in the grid$$$Bugs Fixed $$$Auto-Completion$$$Auto-complete gives no suggestions after unrecognized keywords in CASE$$$Auto-complete may miss valid column suggestions in statements that contain multiple USING clauses$$$Connection Setup$$$Cant choose a file when configuring file-based databases$$$DB Support: Oracle$$$Incorrect script generated when adding a datafile without a filename (OMF)$$$DB Support: PostgreSQL$$$Error fetching constraint DDL in PostgreSQL$$$Export/Import User Settings$$$SSH configurations are not included when exporting mounted connections$$$Favorites$$$Error when renaming items in the Favorites tab$$$Grid Component$$$Error when moving columns in the grid$$$OS Support: Windows$$$Application title is missing in the Windows taskbar$$$Query Builder$$$Various JOIN-related fixes in the query builder$$$SQL Commander$$$Pressing Alt+Left and Alt+Right may not switch tabs as expected$$$Pressing the End key is not recorded in macros$$$Refreshing metadata may incorrectly report a read-only result set as editable$$$Tabs may be lost or ungrouped when moving tab groups between windows$$$SQL Log$$$Error when saving large log files$$$Security$$$Connection may fail with a missing master password error when no master password is configured

26.2.1 - Released 2026-07-07$$$Improvements $$$Area$$$Details$$$AI$$$Support for AI models with adaptive thinking capabilities$$$Bugs Fixed $$$Area$$$Details$$$AI$$$AI chat history gets out of sync when switching between chats$$$Missing database schema details in the AI context$$$DB Support: Oracle$$$Temp files are listed multiple times in Oracle$$$Files$$$OS Support: Windows$$$Network drives appear empty in the Files tab until a refresh is triggered$$$Installation/Update Installation$$$Restarting after an application update opens the default workspace instead of the previously active workspace$$$Monitor$$$Monitored queries are not initialized on application start$$$Performance/Stability$$$Unexpected error upon background task completion$$$Unexpected error when OS theme changes$$$SQL Commander$$$Error when closing a tab with an ongoing query$$$SQL Commander tabs within closed tab groups are lost after an application restart

26.2.1 - Released 2026-07-07$$$Improvements $$$Area$$$Details$$$AI$$$Support for AI models with adaptive thinking capabilities$$$Bugs Fixed $$$Area$$$Details$$$AI$$$AI chat history gets out of sync when switching between chats$$$Missing database schema details in the AI context$$$DB Support: Oracle$$$Temp files are listed multiple times in Oracle$$$Files$$$OS Support: Windows$$$Network drives appear empty in the Files tab until a refresh is triggered$$$Installation/Update Installation$$$Restarting after an application update opens the default workspace instead of the previously active workspace$$$Monitor$$$Monitored queries are not initialized on application start$$$Performance/Stability$$$Unexpected error upon background task completion$$$Unexpected error when OS theme changes$$$SQL Commander$$$Error when closing a tab with an ongoing query$$$SQL Commander tabs within closed tab groups are lost after an application restart

26.2 - Released 2026-06-18$$$New Features $$$Area$$$Details$$$AI$$$Contextual AI actions in SQL Commander$$$Support for multiple vendors and models in the AI assistant$$$App Logging$$$Add audit logging for executed SQL statements$$$DB Support: Amazon Athena$$$Add basic support for Amazon Athena$$$DB Support: InfluxDB$$$Add basic support for InfluxDB$$$Grid Component$$$Add map visualization for geospatial data$$$Notifications$$$Introduce in-app notifications$$$SQL Commander$$$Add support for tab groups in SQL Commander$$$Vim mode in SQL Commander$$$Improvements $$$Area$$$Details$$$AI$$$Run query from the AI assistant$$$Check for Update$$$Implement in-app updates when checking for updates manually$$$DB Support: Db2 z/OS$$$Extract view DDL in Db2 z/OS$$$DB Support: Hive$$$Update the Apache Hive template to use the official standalone driver$$$DB Support: SQL Server$$$Mark non-online databases in the database objects tree for SQL Server$$$Database Objects Tree$$$Add quick search for database connections in the Databases tab$$$Driver Manager$$$Add support for Maven artifact classifiers$$$Update template drivers$$$Grid Component$$$Improve the functionality; performance and UX of the quick filter in grids and trees$$$SQL Commander$$$Enhance the connection selector in SQL Commander to support search and hierarchies$$$Implement smooth scrolling between editor tabs$$$Security$$$Add an option to accept and trust any certificate within a validation chain$$$Value Viewer$$$Add support for editing JSON values in the Value tab$$$Add syntax highlighting for JSON and XML values in the Value tab$$$Bugs Fixed $$$Area$$$Details$$$DB Support: PostgreSQL$$$MAINTAIN grant isnt displayed correctly in the Grants tab for PostgreSQL$$$Database Objects Tree$$$Possible error when removing a database connection$$$OS Support: Linux$$$SQL Editor$$$Editor font isnt scaled correctly on Linux$$$OS Support: Windows$$$SQL Editor$$$Editor loses input focus when activating rectangular selection on Windows$$$OS Support: Windows$$$Value Viewer$$$International characters are not always displayed correctly in the Value tab on Windows$$$Performance/Stability$$$Possible error during application startup$$$Workspace$$$Maximized window may be restored on the wrong monitor

Version: 4.2.20.0 $$$Date: 2026-3-11 $$$Release note: $$$Bug Fix.

Version: 4.2.19.0 $$$Date: 2026-1-12 $$$Release note: $$$Bug Fix.

Version: 4.2.19.0 $$$Date: 2026-1-12 $$$Release note: $$$Bug Fix.

Version: 4.2.18.0 $$$Date: 2025-12-15 $$$Release note: $$$Add hardware support for the IPEVO Wireless USB/HDMI™ Receiver.

Version: 4.2.18.0 $$$Date: 2025-12-15 $$$Release note: $$$Add hardware support for the IPEVO Wireless USB/HDMI™ Receiver.

Version: 4.2.17.0 $$$Date: 2025-09-12 $$$Release note: $$$Added countdown auto document scanning feature.

Version: 4.2.17.0 $$$Date: 2025-09-12 $$$Release note: $$$Added countdown auto document scanning feature.

Version: 4.2.16.0 $$$Date: 2025-08-28 $$$Release note: $$$Bug Fix.

Version: 4.2.16.0 $$$Date: 2025-08-28 $$$Release note: $$$Bug Fix.

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

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.

Release Notes$$$26.1.2 - Released 2026-05-11$$$Improvements $$$Area$$$Details$$$Installation/Update Installation$$$OS Support: Linux$$$Sign RPM and DEB installers$$$SQL Commander$$$Expand the Alt+Click pinning area to the entire tab header

Release Notes$$$26.1.2 - Released 2026-05-11$$$Improvements $$$Area$$$Details$$$Installation/Update Installation$$$OS Support: Linux$$$Sign RPM and DEB installers$$$SQL Commander$$$Expand the Alt+Click pinning area to the entire tab header

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

26.1.1 - Released 2026-04-07$$$Improvements $$$Area$$$Details$$$DB Support: Exasol$$$New keywords and other improvements for Exasol$$$DB Support: Mimer SQL$$$Support for deferred foreign key constraints and other improvements for Mimer SQL$$$DB Support: Redshift$$$Automatically handle invalid entries in search_path when working with Redshift$$$SQL Commander$$$Add an option to keep existing result set tabs without pinning them

26.1.1 - Released 2026-04-07$$$Improvements $$$Area$$$Details$$$DB Support: Exasol$$$New keywords and other improvements for Exasol$$$DB Support: Mimer SQL$$$Support for deferred foreign key constraints and other improvements for Mimer SQL$$$DB Support: Redshift$$$Automatically handle invalid entries in search_path when working with Redshift$$$SQL Commander$$$Add an option to keep existing result set tabs without pinning them

26.1 - Released 2026-03-06$$$New Features $$$$$$AI - Introduce the AI assistant$$$DB Support: Impala - Add basic support for Impala$$$DB Support: Neo4j - Add basic support for Neo4j$$$File Chooser - Introduce the OS native file chooser$$$$$$Improvements $$$$$$Connection Setup - Create missing SSH configurations when mounting a database connection folder$$$Mount database connection folders using drag and drop$$$DB Support: Azure SQL - Avoid multiple authentication prompts when working with Azure$$$DB Support: Databricks - Add support for streaming tables in Databricks$$$Simplify connection setup for the authentication flows available in Databricks$$$DB Support: Informix - Make is possible to import data into temporary tables in Informix using @import$$$Driver Manager - Update template drivers$$$Grid Component - Add an action to copy grid selection as a Markdown table$$$Installation/Update Installation - Add an option to install DbVisualizer for the current user only$$$Java - Bundle Java 25 with installers$$$Performance/Stability - Improve application performance when working with many editor tabs$$$Improve application startup time$$$SQL Commander - Add a predefined variable for current clipboard contents$$$Quickly access recently used database connections in SQL Commander$$$$$$Bugs Fixed $$$$$$Auto-Completion - Fully Qualify Objects may generate incorrect completions$$$Incorrect suggestions or error when auto-completing columns in a derived table$$$Connection Setup - Driver type may be reset when editing multiple database connections$$$DB Support: ClickHouse - Error during connect when using the latest Clickhouse driver$$$DB Support: Snowflake - Error during connect when using the latest Snowflake driver$$$TIME values are saved incorrectly when editing in a grid or using parameterized queries$$$Database Objects Tree - Database connection filters may be lost$$$File Chooser - File chooser may be slow or freeze the application when running on a Windows environment with mapped network drives$$$OS Support: Windows$$$Performance/Stability $$$General - Main window isnt maximized on application start$$$Git - Git operations can fail if the application is set up to use the system proxy but it is not available$$$Grid Component - When pasting table data into a grid; only changed cells should be highlighted as updated$$$Performance/Stability - Application interface doesnt appear on startup$$$Performance/Stability$$$SQL Commander - Application may freeze when working with a large script if Show Tab Lines is on

26.1 - Released 2026-03-06$$$New Features $$$$$$AI - Introduce the AI assistant$$$DB Support: Impala - Add basic support for Impala$$$DB Support: Neo4j - Add basic support for Neo4j$$$File Chooser - Introduce the OS native file chooser$$$$$$Improvements $$$$$$Connection Setup - Create missing SSH configurations when mounting a database connection folder$$$Mount database connection folders using drag and drop$$$DB Support: Azure SQL - Avoid multiple authentication prompts when working with Azure$$$DB Support: Databricks - Add support for streaming tables in Databricks$$$Simplify connection setup for the authentication flows available in Databricks$$$DB Support: Informix - Make is possible to import data into temporary tables in Informix using @import$$$Driver Manager - Update template drivers$$$Grid Component - Add an action to copy grid selection as a Markdown table$$$Installation/Update Installation - Add an option to install DbVisualizer for the current user only$$$Java - Bundle Java 25 with installers$$$Performance/Stability - Improve application performance when working with many editor tabs$$$Improve application startup time$$$SQL Commander - Add a predefined variable for current clipboard contents$$$Quickly access recently used database connections in SQL Commander$$$$$$Bugs Fixed $$$$$$Auto-Completion - Fully Qualify Objects may generate incorrect completions$$$Incorrect suggestions or error when auto-completing columns in a derived table$$$Connection Setup - Driver type may be reset when editing multiple database connections$$$DB Support: ClickHouse - Error during connect when using the latest Clickhouse driver$$$DB Support: Snowflake - Error during connect when using the latest Snowflake driver$$$TIME values are saved incorrectly when editing in a grid or using parameterized queries$$$Database Objects Tree - Database connection filters may be lost$$$File Chooser - File chooser may be slow or freeze the application when running on a Windows environment with mapped network drives$$$OS Support: Windows$$$Performance/Stability $$$General - Main window isnt maximized on application start$$$Git - Git operations can fail if the application is set up to use the system proxy but it is not available$$$Grid Component - When pasting table data into a grid; only changed cells should be highlighted as updated$$$Performance/Stability - Application interface doesnt appear on startup$$$Performance/Stability$$$SQL Commander - Application may freeze when working with a large script if Show Tab Lines is on

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.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