Released: Dec 1, 2021

Mises à jour de V9.0.782

Fonctionnalités

• Added support for the following syntax constructs:
  • ARRAY.
  • MEMBER OF.
  • JSON_TABLE.
  • JSON_ARRAYAGG.
• Added the analysis of BOM (Byte Order Markers) availability when opening files with a suggestion to normalize such files.
• Added the ability to display and edit the original object text in the procedure and function editor.
• Improved behavior when saving database connections list.
• Variable parsing now complies with the documentation.
• Added support for varcharacter[(n)] data type when parsing scripts with MariaDB syntax.
• Improved behavior of query execution using the utf8mb3 charset for MariaDB 10.6.

Correctifs

• Fixed an unexpected exception during the operation of the code completion module.
• Fixed an issue with data export to an Excel file that occurred when the dataset exceeded 66,000 lines.
• Fixed an issue that occurred during data import due to incorrect initialization of the charset and collations for a new table.
• Fixed an issue that occurred during data import from a JSON file.
• Fixed an unexpected exception that occurred when updating the caret position in the document editor.
• Fixed the incorrect behavior of the "Hide unmodified columns" option in the Data Comparison document.
• Fixed a data presentation format issue that occurred during data export.
• Fixed an issue that occurred when connecting under a user with limited permissions.
• Fixed an unexpected exception that occurred during data export from ODBC due to data type incompatibility.
• Fixed a product activation error that occurred during a delayed response of the activation server.
• Fixed a primary key synchronization issue.
• Fixed an issue that occurred during data import via a template.
• Fixed a synchronization issue for a table with PARTITION BY RANGE COLUMN.
• Fixed a procedure script generation issue.
• Fixed an issue that occurred when creating a project.
• Fixed memory leaks that occurred during data import.
• Fixed a product activation issue that involved Arabic characters.
• Fixed a synchronization issue for a table with partitioning.
• Fixed the behavior of the Limit Bulk Size option in Data Compare.
• Fixed an issue that occurred when using data filtering in Data Editor.
• Fixed an issue with the repeated execution of a query in Data Editor.
• Fixed an issue that occurred when canceling query execution in a SQL document.
• Fixed an issue with the paginal mode in Data Editor.
• Fixed an issue with connection to a database in a SQL document.
• Fixed selection criteria in queries that retrieve metadata for security objects.
• Fixed an issue that occurred when retrieving a charset in the view editor.
• Fixed the behavior of setting up user permissions in Security Manager.
• Fixed the background color application error that occurred during data export to the Excel format.
• Fixed an issue that occurred when launching the application and accessing the Object Viewer.
• Fixed an issue that occurred when processing scripts containing syntax in versioned comments.
• Fixed an issue with the partial loss of expressions during formatting.
• Fixed the inclusion of a false error to the log.
• Fixed the behavior of change markers in SQL Editor.
• Fixed the selection of encoding when writing synchronization scripts to a file.
• Fixed an issue with the syntax check for SELECT expressions with multiple UNION operators.
• Fixed an issue that occurred when closing the Studio.
• Fixed an issue that occurred when retrieving a list of view columns.
• Fixed an issue that occurred when using a drop-down list (Member List).
• Fixed a false syntax check that hindered the compilation of stored procedures for debugging.
• Fixed the behavior of the view editor during detection of syntax errors.
• Fixed a false syntax check that hindered the comparison of views.