Released: Jan 17, 2024

Updates in V10.0.150

Features

• Code Completion and Syntax Check
  • Added support for START, STOP, SHOW and RESET REPLICA statements.
  • Added full support for FLUSH command.
• DDL generator
  • Added the option to Include triggers to DDL generator.
  • Added Include DEFINER clause and Include SQL SECURITY clause options instead of Exclude DEFINER and SQL SECURITY clauses option.
• Others
  • Added connectivity support for MariaDB 11.4.
  • Upgraded from legacy chart designer to advanced new version.
  • Added new Alt + Up/Down Arrow shortcuts for navigating script differences in the lower comparison pane in Schema Compare.
  • Implemented the restoration of tables being edited in Data Editor in case of the execution of multiple SELECT queries.
  • Improved the object renaming functionality for users with limited permissions.
  • Improved the selection of server connection in Object Editor when navigating between objects by name from SQL Document.
  • Implemented the recovery of triggers when rebuilding a table in the editor.
  • Improved error diagnostics in Document Outline.

Fixes

• Fixed an issue with ANSI_QUOTES that occurred during the compilation of procedures for debugging.
• Fixed issues that occurred during the synchronization of schemas into project files.
• Fixed syntax check issues that caused various malfunctions and improved the diagnostics of such issues.
• Fixed an issue that occurred when comparing object scripts to display differences.
• Fixed an issue with the execution of Commit and Get Latest from the shortcut menu of Database Explorer.
• Fixed an issue in Object Search that occurred when searching for objects whose names contain the underscore character.
• Fixed an issue with editing string values in columns in Data Editor.
• Fixed an issue with displaying empty values in Data Editor.
• Fixed an issue that occurred when retrieving table metadata in Data Editor.
• Fixed an issue that occurred during the repeated execution of a SELECT query in Data Editor.
• Fixed an issue that occurred during the repeated execution of a query in SQL Document.
• Fixed an issue that occurred when pasting multiline text into a grid cell in Data Editor.
• Fixed an issue that occurred when opening the Tables node in Database Explorer with the 'Allow uncommitted objects discovery' option enabled.
• Fixed a syntax error in queries that join subqueries.
• Fixed an issue that occurred when running a comparison after saving a .scomp document.
• Fixed an issue that occurred when opening and editing documents in a project.
• Fixed an issue that occurred when changing a column name in Table Editor.
• Fixed an issue with the generation of package DDL.
• Fixed the incorrect restoration of open documents.
• Fixed an issue that occurred when opening a project.
• Fixed an issue with applying the 'Use cached update mode by default' option.
• Fixed an issue with reading LOB.
• Fixed an issue with launching the application via CrossOver.