Released: May 12, 2022

V9.0.890 での更新項目

機能

• Improved how the dimension of numeric types is determined, for the parameters of procedures and functions.
• Improved tab activation behavior when executing queries in a SQL document.
• SSH protocol configuration form now displays local port option.
• Improved handling of server errors that use hyphenation in procedure and function comments.
• Added query timestamp to the General output window.
• Changed opening behavior of the trigger editor and added the ability to view scripts from SHOW CREATE...

Released: Dec 9, 2021

V9.0.791 での更新項目

機能

• Added support for new privileges during syntax checking.
• Improved performance when opening a connection.

不具合の修正

• Fixed an issue that occurred when generating scripts for tables.
• Fixed an issue with reading table metadata.
• Fixed an issue with reading session variables when opening a connection.

Released: Dec 1, 2021

V9.0.782 での更新項目

機能

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

Released: Oct 20, 2021

V9.0.689 での更新項目

不具合の修正

• The application fails with a critical error when trying to create diagram objects after installing the KB5006670, KB5006672 or KB5006674 Windows update.

Released: Sep 8, 2021

V9.0.688 での更新項目

不具合の修正

• Fixed an error with reading the default values.
• Fixed a error with displaying a warning about the absence of unique keys in the Data Editor.

Released: Aug 5, 2021

V9.0.665 での更新項目

機能

• Added connectivity support for MariaDB 10.6.

不具合の修正

• Fixed error with quotation of Default values for the ENUM type.

Released: Jul 28, 2021

V9.0.660 での更新項目

不具合の修正

• Fixed export of large tables with more than 65536 records for Excel 2003 and 1048576 records for Excel 2007.
• Fixed metadata retrieval for default_role in Documenter.
• Fixed a problem with comparing a view that calls aggregate function with OVER clause in its query.
• Resolved an issue that led to multiple row data changes when editing data in a table with a unique key that allows NULL values.
• Fixed incorrect work with the default TIMESTAMP column.
• Fixed a problem with generating a script for...

Released: Jul 8, 2021

V9.0.636 での更新項目

機能

• Added the ability to connect via SSL with different encryption protocols.
• Improved Database Project deployment.

不具合の修正

• Debugger behavior in the auto-commit mode = OFF has been fixed.
• Issue with the reserved word LAG in Object Editor has been fixed.
• Procedure execution error has been fixed.
• Processing of error information output has been fixed.
• Error in Data Editor in case of deleting a table on the server has been fixed.
• Bug with quoting DEFAULT values has been fixed.
• Critical error when...

Released: May 25, 2021

V9.0.597 での更新項目

不具合の修正

• Warning about data type mismatch of the FOREIGN KEY columns has been added to Database Project.
• Query Builder forces lower case table names.
• Column persistency settings are incorrectly detected within DDL scripts.
• A fatal error occurs when trying to generate data for tables that contain NOT NULL check constraints.
• Error with comparing the DEFAULT value for columns with a BIT(1) data type has been fixed.
• Error with comparing automatically generated index names has been fixed.
• Error with...

Released: Apr 22, 2021

V9.0.567 での更新項目

機能

• Added new commands to Data Viewer.
• Improved behavior of grouping, sorting and filtering in Data Editor.
• Informational message added instead of an unexpected exception when importing data from invalid Microsoft Excel files.
• Added support for processing FOR and END FOR constructions.
• Optimized synchronization of changes in virtual columns.

不具合の修正

• Fixed issue related to Drag & Drop of nodes in Database Explorer.
• Error when retrieving data in Data Editor.
• Error in Database Diagram.
• Error when...