Released: Apr 19, 2023

Updates in V9.2.5

Features

• Connectivity
  • Added support for MariaDB v11.3.
  • Added support for Aiven Cloud.
  • Added support for SHA-256/512.
• Text Editor
  • Enhanced code completion for application-period temporal tables.
  • Added support for a broader range of optimizer hints.
  • Added support for VALUES ... ORDER BY ... LIMIT statements.
  • Added support for TABLE statement.
  • Added support for EXCEPT and INTERSECT statements.
  • Added support for spatial functions ST_LineInterpolatePoint, ST_LineInterpolatePoints, ST_PointAtDistance and ST_Collect.
  • Added the ability to show/hide the additional view in SQL Document using the Ctrl+R shortcut.
• Query Builder
  • Added support for sequence tables.
• Other Improvements
  • Added support for UUID and INET6 data types.
  • Added support for MySQL functional indexes.
  • Added the ability to save and load filters in Database Explorer.
  • Improved charset comparison behavior in Schema Compare.
  • Added support for quoting function names used as table names.
  • Added support for COLLATE and CHARSET in the RETURN expression of function declarations.
  • Added support for the 'omit anti-spoofing prompt after authentication' option for Plink connections.
  • Improved error diagnostics in Schema Compare.
  • Improved security of username display.
  • Improved behavior when editing procedures and functions.
  • Improved application startup performance.
  • Improved behavior when executing procedures for users with limited privileges.
  • Improved algorithm for converting object names to their original case during formatting.

Fixes

• Fixed metadata retrieval for MariaDB 10.6 and higher versions, and also removed the temporary workaround of setting the session system variable OLD_MODE to UTF8_IS_UTF8MB3.
• Fixed an error with incorrect server-side conversion of object names to lowercase.
• Fixed an error that occurred when opening the Object Privileges tab in Security Manager.
• Fixed an issue with saving formatting options to the registry.
• Fixed an error that occurred when establishing the plink connection.
• Fixed an issue with displaying object privileges in Security Manager.
• Fixed an issue with saving SSH parameters in the Database Connection Properties window.
• Fixed an error that occurred when establishing a connection in Security Manager.
• Fixed an issue with retrieving the list of the unique keys columns in Database Explorer.
• Fixed an issue with creating data reports via the command line.
• Fixed an error that occurred with retrieving metadata for the procedure parameters.
• Fixed an error that occurred when switching between the Grid View and Card View modes in Data Editor.
• Supported the precision value outside the range for the TINYINT type in Schema Compare.
• Fixed an error with opening a connection when repeatedly executing queries in SQL Document.
• Fixed the Query Builder error.
• Fixed the behavior of setting the Empty String value to a grid cell in Data Editor.
• Fixed an issue with establishing a connection.
• Fixed an issue with retrieving the list of database objects for the object tree in Backup Wizard.
• Fixed an error that occurred when opening the SSH connection.
• Fixed an issue with retrieving table data and closing the connection when working with Data Export.
• Fixed an issue with retrieving metadata that occurred when using the Database Refactoring functionality.
• Fixed a project build error that could occur when using window functions in scripts.
• Fixed an error that occurred when generating the procedure script.
• Fixed an error that occurred when generating a partitioned table script.
• Resolved an issue where a part of the script could be mistakenly included in the comment while formatting.
• Resolved an issue with formatting Boolean literals.
• Fixed the Query Builder error that could occur when using the IN operator.
• Fixed an issue where unnecessary users were created when building the project.
• Fixed the comparison of default column values.
• Fixed a project build error that occurred when using CHARSET expressions in scripts.
• Fixed a describe table error that could occur when using indexes.
• Fixed an error for geometric data types.
• Resolved an issue with application freezing that occurred when formatting complex view scripts.
• Fixed an index describe error on older server versions.
• Fixed an error that could occur when closing documents.
• Fixed the generation of trigger scripts on computers with non-English locales.
• Fixed the generation of table scripts.
• Fixed an error that occurred when opening SQL Editor during script generation in Data Generator.
• Fixed an error that occurred when closing the application.
• Fixed an error that occurred when synchronizing MEDIUMTEXT data in Data Compare.
• Fixed the behavior of managing connections in the SQL document.
• Fixed synchronization of auto_increment columns.
• Fixed an error that occurred when starting the application.
• Fixed an issue with document recovery after reopening the application.
• Fixed an error that occurred when creating a procedure with a temporary sequence.
• Resolved an issue with access to the license file.
• Fixed a system error in the graphics subsystem.
• Fixed an error that occurred when displaying the tooltip window in the Text Editor.
• Resolved an issue with opening the Table Editor in Crossover.
• Fixed an error that occurred when creating database documentation.
• Fixed an error that occurred when saving documents for recovery.
• Fixed an error that could occur when dragging and dropping objects onto the database diagram.
• Fixed an error that occurred when editing check constraints.
• Resolved issues with parsing scripts containing hieroglyphs.
• Fixed an error that occurred when debugging stored routines with error handlers that call the FOUND_ROWS function.
• Fixed a freezing issue that could occur when working with Documenter - Studio, Documenter.
• Fixed syntax checking errors.
• Fixed an error that occurred when working with Query Builder.
• Fixed an issue with exporting data to an Excel table.
• Fixed an error that occurred when executing queries that call the JSON_TABLE function.
• Resolved an issue with processing paths to project files.
• Fixed an error that occurred when importing data from JSON files.