dbForge Studio for MySQL

What's new in this version:

dbForge Studio for MySQL Professional 10.1.24
Improved:
- Introduced connectivity support for MySQL 9.0
- Added connectivity support for Kamatera MySQL Cloud
- Added support for the rds-ca-rsa2048-g1 SSL/TLS certificate for connecting to MariaDB servers on Amazon Web Services (AWS)
- Added support for HeatWave-specific commands in Code Completion and Syntax Check
- Redesigned the Query History interface
- Added quick selection of all relationships within a Database Diagram
- Added the ability to copy data to the clipboard in the CSV format from Data Editor
- Added the ability to copy data to the clipboard in the Excel-compatible format from Data Editor
- Added the ability to append a timestamp to the file name in Data Generator
- Introduced the option to include security permissions in the Generate Scripts functionality
- Introduced the ability to generate comparison reports from the command line
- Added quick access to Devart Academy directly from the interface

Fixed:
- Resolved an issue with object compilation on MariaDB servers
- Fixed an error that occurred when parsing procedure parameters
- Fixed an issue with supporting MariaDB expressions (Oracle Syntax)
- Fixed an error that occurred when parsing CREATE TABLE statements
- Fixed an error that occurred when parsing CREATE PROCEDURE statements
- Fixed an error that occurred when parsing CREATE VIEW statements
- Resolved an issue with losing privileges during synchronization with the project
- Fixed the System.ArgumentException error that occurred during schema comparison with a project if synchronizing directly to the project
- Fixed the InvalidOperationException error that occurred when working with projects
- Resolved an issue with data sorting in Data Editor
- Fixed an issue that occurred when filtering object types in the Schema Compare document
- Fixed handling of the JSON data type when the NO_BACKSLASH_ESCAPES mode is enabled in SQL Modes
- Fixed an issue with retrieving metadata when lower_case_table_names = 0 on MySQL 5.7 servers
- Improved the mechanism for selecting the correct server connection when navigating (F12) to an object name in SQL documents
- Fixed the behavior of the Ctrl + Delete command for removing whitespace in SQL documents
- Fixed an error in the Changes History window that occurred when the server connection was closed
- Removed unnecessary delimiter characters ($$) appearing during procedure synchronization in Source Control
- Resolved an issue with the support for the BODY keyword in the MariaDB dialect (Oracle Syntax)
- Fixed a request error that occurred when accessing MySQL system database tables with restricted user permissions in Source Control
- Fixed an issue with saving Master-Detail or Database Diagram documents
- Fixed an issue that occurred when adding a relation between table columns
- Fixed the detection of AUTO_INCREMENT column values when adding new records in Data Editor
- Resolved the incorrect display of tables in the database diagram
- Fixed an error that occurred when parsing SQL scripts
- Resolved an issue with context hints in SQL scripts
- Fixed an issue that occurred when working with a database project
- Fixed an issue with synchronizing tables with foreign keys in Schema Compare
- Fixed an issue with data display in Data Editor in Card View mode
- Fixed an issue that occurred on application startup


dbForge Studio for MySQL Professional 10.0.225
Fixed:
- Fixed the issue of losing encoding for string values in the Edit Parameters dialog
- Resolved the problem with auto-formatting of the SET keyword
- Fixed a syntax error that occurred when using the MEMBER alias
- Fixed a MySQL server connection error that occurred when using the SSL Cipher List parameter
- Fixed the issue that prevented table editing for queries involving JOIN operations in the Data Editor
- Resolved an issue that occurred when attempting to open a connection to the server while editing script parameters in the SQL Document
- Fixed the Lost connection to MySQL server during query error in the stored procedure editor
- Fixed an error that occurred during script parsing in the SQL document
- Fixed errors that occurred during query editing in Query Builder
- Fixed an issue with unnecessary quotation marks being added to values when copying data from the Data Editor
- Fixed an issue related to computing the insertion position for elements from the Member List
- Added support for the Mroonga engine in the syntax checking
- Significantly improved the performance of parsing queries containing a large number of JOIN operations
- Fixed an issue that occurred when applying the decimal separator during the export of floating-point numbers

Improved:
- Improved the behavior of retrieving metadata about database objects under restricted privilege conditions
- Improved the behavior of the Execute Current Statement and Execute To Cursor commands during script parsing when it's not possible to evaluate the script fragment for execution. Now, users will be notified when executing the command is not possible


dbForge Studio for MySQL Professional 10.0.150
Code Completion & Syntax Check:
- Added support for START, STOP, SHOW and RESET REPLICA statements
- Added full support for FLUSH command

DDL generator:
- Added option 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
- New Alt + Up/Down Arrow shortcuts for navigating script differences in the lower comparison pane in Schema Compare

User-reported and internal bug 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
- Implemented the restoration of tables being edited in Data Editor in case of the execution of multiple SELECT queries
- Fixed an issue in Object Search that occurred when searching for objects whose names contain the underscore character
- Improved the object renaming functionality for users with limited permissions
- 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
- Improved the selection of server connection in Object Editor when navigating between objects by name from SQL Document
- 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
- Implemented the recovery of triggers when rebuilding a table in the editor
- Fixed an issue with the generation of package DDL
- Improved error diagnostics in Document Outline
- 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


dbForge Studio for MySQL Professional 10.0.60
Improvements:
- Added the ability to open the Object Editor's Data tab directly from the Database Explorer for quicker access to the data editing functionality

User-reported and internal bug fixes:
- Fixed an issue with editing string values in the Data Editor
- Resolved an application crash issue when attempting to save a script larger than 2 gigabytes
- Fixed an issue with parsing duplicate objects in the script
- Expanded the list of reserved words
- Resolved the problem with SQL Document freezing during query execution


dbForge Studio for MySQL Professional 9.2.128
Improved:
- Added support for authentication via AWS Identity and Access Management (IAM)

User-reported and internal bug fixes:
- Fixed an issue with the SSL connection to the server


dbForge Studio for MySQL Professional 9.2.105
Connectivity:
- Added support for MySQL v8.1

User-reported and internal bug fixes:
- Improved table mapping error diagnostics in Data Compare
- Removed the automatic creation of an empty debug.log file when opening the Studio
- Removed the cause of warnings in database backup scripts; the ALTER TABLE ENABLE KEYS command is applied to MyISAM tables only
- Fixed an issue in the table editor that occurred when opening a table with the # character in the title
- Improved the modification mechanism for procedures and functions; when saving an object, the Studio does not create a temporary object with a 'dvrt_' prefix in the title
- Fixed an issue that occurred when updating data in Session Manager
- Fixed an issue that occurred when creating a trigger
- Fixed an internal application error in SQL Editor
- Fixed an internal application error that occurred when opening the Studio on Linux or macOS via CrossOver
- Fixed the incorrect display of fonts that occurred when opening the Studio on Linux or macOS via CrossOver
- Fixed an issue that occurred when loading a SQL document
- Fixed an issue that occurred when exporting/importing data from the command line
- Fixed the incorrect highlighting caused by the document window losing focus on input
- Fixed the false triggering of syntax check
- Fixed an issue that occurred during schema synchronization and added an unnecessary CREATE TRIGGER to the synchronization script
- Fixed an issue that occurred when opening large scripts
- Fixed the generation of an error report in Query Builder, caused by the renaming of a table in File Explorer


dbForge Studio for MySQL Professional 9.2.34
Fixed:
- It is impossible to specify shortcuts for several commands within the "Generate Script As" section of the data editor pop-up menu
- All toolbar and menu buttons are unresponsive within specific environments
- Facing parsing errors when performing schema comparison for objects containing specific subqueries
- Incorrect encoding within the SET NAMES statement when generating data export script


dbForge Studio for MySQL Professional 9.2.5
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 the VALUES ... ORDER BY ... LIMIT statements
- Added support for the TABLE statement
- Added support for the 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 (p172754)

Query Builder:
- Added support for sequence tables in Query Builder

Other Improvements:
- Added support for the UUID Data Type
- Added support for the INET6 Data Type
- Added support for MySQL functional indexes
- Added the ability to save and load filters in Database Explorer
- Improved the charset comparison behavior in Schema Compare
- Added quoting of function names being used as table names

Fixed:
- 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
- Added support for COLLATE and CHARSET in the RETURN expression in the function declaration
- Fixed a project build error that occurred when using CHARSET expressions in scripts
- Fixed a describe table error that could occur when using indexes
- Improved error diagnostics in Schema Compare
- 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
- Added support for the 'omit anti-spoofing prompt after authentication' option for the plink connections
- Fixed an error that occurred when opening SQL Editor during script generation in Data Generator
- Improved the security of username display
- Fixed an error that occurred when closing the application
- Fixed an error that occurred when synchronizing MEDIUMTEXT data in Data Compare
- Improved the behavior of editing procedures and functions
- 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
- Improved the application startup performance
- 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
- Improved the behavior of executing procedures for users with limited privileges
- 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
- Improved the algorithm for converting object names to their original case during formatting
- 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


dbForge Studio for MySQL Professional 9.1.21
Improvements:
- Connectivity support for MariaDB 10.10

User-reported and internal bug fixes:
- an issue with data modification in tables with an INVISIBLE column in the Data Editor
- a bug that occurred when saving document cache for recovery
- a false syntax check error
- an issue with the synchronization of calculated columns


dbForge Studio for MySQL Professional 9.0.897
- Improved CrossOver compatibility
- Fixed schema comparison behavior
- Fixed error handling


dbForge Studio for MySQL Professional 9.0.894
- Improved CrossOver compatibility
- Fixed schema comparison behavior (D76098, D73000, D76098)


dbForge Studio for MySQL Professional 9.0.890
Improved:
- Improved the behavior of determining the dimension of numeric types for the parameters of procedures and functions (D73292)
- Improved the tab activation behavior when executing queries in a SQL Document (D76851)
- Improved the SSH Protocol configuration form to display the Local port option (D75981)
- Improved the behavior of the Studio to work around a server error using hyphenation in procedure and function comments (D75638)
- Improved compatibility with macOS and Linux using CrossOver
- Fixed an issue with activation on macOs using CrossOver
- Fixed issues that could occur when installing the application on macOS and Linux using CrossOver

User-reported and internal bug fixes:
- Added a query timestamp in the General output window (D75287, D78442)
- Changed the opening behavior of the trigger editor and implemented the capability to view the script from SHOW CREATE TRIGGER (D78463)
- Enhanced the execution performance of metadata queries and improved the support for object names with different cases for Unix systems (D73426, D73485)
- The compiler now factors in the ANSI_QUOTES mode when saving a procedure compiled for debugging (D85538, D85537, D85664, D85665)
- Fixed an unexpected exception that occurred when generating data for the foreign key columns (D61140)
- Fixed an unexpected exception that occurred when describing data for Schema Compare (D76988)
- Fixed an unexpected exception that occurred when creating a script in the Data Report Wizard
- Fixed an unexpected exception that occurred after selecting the Use Regular Expression option in the Data Compare Wizard (D54972)
- Fixed file error that occurred after exporting data to the .xlsx format (D65759)
- Fixed an unexpected exception that occurred when importing data from a text file with no content (D71358, D71359)
- Fixed an unexpected exception that occurred when exporting data with nullable values via ODBC provider (D75249, D75475, D75640)
- Fixed an unexpected exception that occurred when closing a SQL document during query profiling
- Fixed an issue that occurred when starting the application (D54073)
- Fixed an unexpected exception that occurred when opening the application options editor window (D66452, T315964, T317130)
- Fixed a bug where after renaming a table column in Database Explorer, no changes were displayed in the table editor (p200130)
- Fixed an unexpected exception that occurred when launching the Data Generation wizard (D72307)
- Fixed an unexpected exception that occurred when loading the Data Report file
- Fixed an unexpected exception that occurred when generating the Tooltip for the connection node
- Fixed an issue with the Next and Previous keywords in the trigger script (D82957)
- Fixed an issue in the text editor on Windows builds 22567 and higher (D81729, D81730)
- Fixed an error that occurred when renaming a procedure with a long name (D76977)
- Fixed an issue with the Splash window (T321527)
- Fixed an error that occurred when saving a SQL Document to a network drive (D76829)
- Fixed the control rendering error 'Arithmetic operation resulted in an overflow' (D83365, D83094, D82790, D75641, D76700, D79304, D79299, D79284, D79391, D79513, D79538, D79647, D79795, D80052, D82265, D82390, D82645, D83232, D83328, D83354, D83415, D83488, D83488, D83553, D83806, D83978, D84261, D84261, D84309, D84497, D84597, D84630, D84633, D84904)
- Fixed an issue with getting the procedures and functions metadata (D74780, D74782, D74781, D74783, D74806, D75289, D75805, D76493, D77598, D777791, D78100, D81817, D81893, D81960, D82277, D83125, D83300, D835900, D836V)
- Fixed the generation of scripts with BULK INSERT (D73106)
- Fixed an error that occurred when opening the context menu (D67415)
- Fixed the comparison and synchronization of foreign keys and indexes associated with foreign keys (D68054)
- Fixed an issue with the tool's windows activation (T309559, T310394, T309631)
- Fixed an issue with closing the application (D72911)
- Fixed an error that occurred when executing the query containing the '/' symbol (D63962)
- Fixed an error that occurred when opening the Style menu in Documenter (D54079)
- Fixed the connection opening error in a SQL Document (D69979, D83775)
- Fixed an error that occurred when selecting a connection in the Project Explorer window
- Fixed an error that occurred when executing a request (D65909)
- Fixed an issue with calling the object editing window from the Search window (D70832, D66412)
- Fixed a bug that could occur when switching between pages in the comparison wizard (D67465, D77784)
- Fixed an error that occurred when working with permissions in database projects (D77870)
- Fixed an error that occurred when working with the procedure parameters (D75638)
- Fixed an issue with the synchronization of objects with the enabled NO_ZERO_DATE, NO_ZERO_IN_DATE options (D80408)
- Fixed a bug that could occur when closing the application (D80352)
- Fixed a critical application error (D58203)
- Fixed the behavior of index synchronization (D70389)
- Fixed schema comparison behavior (D76098, D73000, D76098)
- Fixed an error that could occur when comparing a database with a script folder (D74083)
- Fixed an issue with object script generation (D75427)
- Fixed a bug that could occur when setting a breakpoint
- Fixed issues caused by false syntax errors (T325249, D72828, D56047, D73574, D73593, D74726, D76485, D77098, D75695, D76420, D82654, D84159, D84851)
- Fixed the suggestion of types for the CAST function
- Fixed errors that could occur when specifying a list of view columns for schema comparison (D71544)
- Fixed critical bugs related to the parsing of long calculated expressions and multiple unions (D74042, D82634, D83823, D83997, D76586, p206266, D76612, D74042, D83997, d82635, d76612)
- Fixed an issue with renaming objects in a script (D75618)
- Fixed the loss of procedure parameter values between debug sessions (D77708)
- Fixed an error that could occur when debugging a procedure with the LONG type parameter (D78488)
- Fixed the loss of breakpoints during procedure debugging (D75638, D76971, D77193)
- Fixed an issue with saving changes in database object editors (D76029)
- Fixed an issue with exporting VARBINARY data type to Google Sheets (p205834)
- Fixed an issue with handling queries containing syntax errors in Query Builder (D77579, D84159)
- Fixed a text editor bug on Windows builds 22567 and higher (D81675, D81730, D81712, D81713, D81699, D81463, D81105, D81428, D81674, D80821, D81556, D81203, D81193, D81500, D81199, D81213, D81214, D81106, D81200, D81209 , D81916, D82123, D81292, D82633)
- Fixed docking error when working on 4k monitors (D81179)


dbForge Studio for MySQL Professional 9.0.791
- Added support for new privileges during syntax check
- Improved performance when opening a connection

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


dbForge Studio for MySQL Professional 9.0.782
Improved:
- Added support for the following syntax constructs: ARRAY, MEMBER OF, JSON_TABLE, JSON_ARRAYAGG

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


dbForge Studio for MySQL Professional 9.0.689
Fixed:
- The application fails with a critical error when trying to create diagram objects after installing the KB5006670, KB5006672 or KB5006674 Windows update


dbForge Studio for MySQL Professional 9.0.688
Fixed:
- an error with reading the default values (Z60282)
- a error with displaying a warning about the absence of unique keys in the Data Editor (Z62016, Z62008, Z62390, Z62717, Z63023)


dbForge Studio for MySQL Professional 9.0.665
Improvements:
- Connectivity support for MariaDB 10.6

User-reported and internal bug fixes:
- Error with quotation of Default values for the ENUM type was fixed


dbForge Studio for MySQL Professional 9.0.660
Fixed:
- export of large tables with more than 65536 records for Excel 2003 and 1048576 records for Excel 2007
- metadata retrieval for default_role in Documenter
- 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
- incorrect work with the default TIMESTAMP column
- a problem with generating a script for virtual columns


dbForge Studio for MySQL Professional 9.0.636
Improvements:
- Database Project deployment was improved

User-reported and internal bug fixes:
- Debugger behavior in the auto-commit mode = OFF was fixed
- Issue with the reserved word LAG in Object Editor was fixed
- Procedure execution error was fixed
- Processing of error information output was fixed
- Error in Data Editor in case of deleting a table on the server was fixed
- Ability to connect via SSL with different encryption protocols was added
- Bug with quoting DEFAULT values was fixed
- Critical error when parsing procedure parameters was fixed


dbForge Studio for MySQL Professional 9.0.567
Improvements:
- New commands added to Data Viewer
- Behavior of grouping, sorting, and filtering data in Data Editor
- Informational message added instead of an unexpected exception when importing data from invalid Excel files
- Supported processing of FOR and END FOR construction
- 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 opening Object Editor
- Bug when renaming an object with refactoring
- Issue related to MS Access database in Data Import
- Error when opening the Database Diagram document
- Issue with a warning about unique keys in Data Editor
- Issue with a connection to Azure MySQL when using Azure Active Directory
- Freeze issue in Data Editor
- Issue with displaying the DEFAULT values of functions in Table Editor
- Issue related to ANSI_QUOTES when generating DD
- Issue related to renaming objects with refactoring without full privileges
- Incorrect behavior when importing data: now the default value for table columns when generating a script is taken into account
- Incorrect behavior when exporting data: float data export as a string
- Unexpected exception while generating data
- Error when exporting data to the Excel format
- Incorrect highlighting for changes preview nodes when renaming
- Issue with floating point typeseal, double) incorrectly handled by the code parser in certain cases
- Issue with a possible application crash during status bar updates
- Failure to detect caret position when suggesting code snippets due to fatal error
- Number of exceptional cases when renaming objects
- Possible errors when parsing queries due to the incorrect handling of built-in date and time functions
- Possible unrecoverable error when trying to get hardware info for analytics
- Issue with possible compilation failure for specific procedures due to critical error
- Possible application freeze when scrolling through large scripts
- Incorrect code parser behavior when handling specific subqueries
- Application failure with critical error after renaming the table added to Query Builder
- Critical error when searching through any Data Report document
- Possible errors after calculating context for code completion suggestions
- Issue with currently active document window not being focused after closing the Find and Replace panel
- Possible application crash when caching document content for restoring
- Error when comparing stored procedures
- Issue with a request to server metadata
- Error in ignoring spaces through the command line when working with options
- Error in finding dependencies when working with quoted object names
- Error in reading table partitioning settings- Critical error when quitting the application
- Critical error when processing versioned comments


dbForge Studio for MySQL Professional 9.0.505
Improved:
- More informative error outputting in Restore Database Wizard
- UI with notification text when refactoring objects is enhanced
- Improved display of tags for source objects in Documenter
- The mechanism of reading metadata for events and triggers containing underscore in names on MariaDB Server is modified
- Support for the utf8mb4_0900_ai_ci coding is added

Fixed:
- Issue with freezing in the foreign keys editor
- Behavior with formatting the procedure body when refactoring objects
- Issue with unclosed connection to MySQL server in SQL document
- Error when inserting the DATETIME value into Data Editor
- Error when inputting an incorrect value on the Security tab of Connection Manager
- Connection to MariaDB Server via the PAM authentication
- Error when opening a document in Database Diagram
- Error when switching to the Read-only mode in Data Editor
- Application was unable to profile queries when connected to Percona Server for MySQL 8.0.21
- Syntax Checker reported errors for parameters and variables that started with numbers
- Possible critical errors when preparing quick info for items from the completion list
- Syntax Checker failed to process union syntax in specific cases
- Code Formatter did not work for certain queries that contained object names that match keywords
- Issue with the import date: "When importing, there is no way to assign a default value for a column."
- Issue with the import date: "When importing a CSV into an existing table, the program creates a MySQL error in the query it generates."
- Throwing an unhandled exception when importing some types of the .xlsx files
- Reading metadata when working with users and roles
- Incorrect script generation when working with an auto-increment column
- Critical error when analyzing the required order of columns
- User formatting is taken into account when synchronizing the function parameters
- Loss of foreign keys without names during synchronization
- Critical error when generating comparison report
- Error occurred when closing comparison wizard is fixed


dbForge Studio for MySQL Professional 9.0.470
Improvements:
- Work of the application when connecting via SSL is improved

Fixed:
- Issue with connecting to Azure MySQL via SSL (T313516, T319656, T321100)
- Issue with processing Quick Info hints (T314128)


dbForge Studio for MySQL Professional 9.0.435
Improvements:
- Behavior of metadata retrieving when dragging and dropping a table in Query Builder (T314046)
- Behavior of displaying empty values for the JSON data types in Data Editor
- Behavior of incorrect retrieving of constraints in Data Editor (T314423)
- Behavior of modifying the comment text when changing the letter case (T314767)
- Behavior of identifying unique keys when changing the editable table in Data Editor (T315797)
- Behavior of displaying object lists in Object Viewer (T314050)
- Behavior of the Not Null tag of a column in Table Editor (T312215)
- Behavior of renaming a query in Data Report

Fixed:
- Error in Database Diagram when opening a .dbd file
- Error in the View editor after closing a document
- Error with displaying the Search (Find Objects) window when Database Explorer was absent (T312512)
- Error with copy-pasting in Data Editor
- Error with formatting the DATETIME value in Data Editor (T312665, T315522)
- Error with rendering values in Data Editor (T313623)
- Error with the progress tab of Restore in Execute Large Script Wizard (T313785)
- Error with selecting an editable table in Data Editor
- Error with updating objects in Query Builder (T314231)
- Error with the undoing operations for linked tables in Query Builder (T310715)
- Working with column types for Turkish encoding (T316473)
- Error with displaying the context menu of an object in Database Diagram (T315113)
- Work of Data Import for Google Spread Sheets (T314984)
- Error with saving a procedure in Database Diagram (T313856)
- Error with reading the Google Sheets data in Data Import (T314178)
- Error of overflow when executing a SELECT query with LIMIT OFFSET
- Bug when generating data for tables with foreign keys (T312605)
- Issue with using the documentation on case sensitive operating systems (T317028)
- Error with opening text dictionary in Data Generator
- Error when generating a SQL Profiler document and closing Studio
- Displaying warnings as an error in Data Generator
- Incorrect generation of table columns if their names coincided with the reserved words in CRUD
- Incorrect error processing in Database Project (T315373)
- Error when analyzing index dependencies (T318093)
- Notification on possible data loss in certain cases of comparing the TINYINT types
- Missed calls of user scripts when assembling a database project (T318011)
- Critical error during syntax check of CREATE ROLE (T318011)
- Incorrect reading of the DEFAULT values if it was not specified as CURRENT_TIMESTAMP () (T317941)
- Incorrect reading of the DEFAULT values for the JSON type (T310136)
- The incorrect character was inserted instead of the ` character when typing Alt+96 in the SQL editor (T317193)
- Incorrect behavior of syntax check feature for MODIFY keywords within the ALTER TABLE clause (T318406)
- The application failed with a fatal error when trying to compile procedures containing identifiers with digital prefixes for debugging (T317744, T316666)
- Possibly incorrect script generation within Query Builder for queries containing date and time functions
- The 'AS NEW()' syntax was treated as invalid within INSERT statements (T314777)
- Incorrect CRUD and SELECT scripts generation for tables containing columns with names matching words that are reserved


dbForge Studio for MySQL Professional 9.0.391
Improvements:
- The disable animations option was implemented

Fixed:
- Incorrect foreign keys comparison in case of cross-database reference (T313064)
- Add 'lateral' as a reserved keyword (T311236)
- Error on an attempt to read the non-existing column from the metadata for SYSTEM VERSIONING tables in MariaDB (T313844, T314778, T314779)
- Error on processing variables with the same name in different scopes (T314318, T314318, T315270)
- Add schema comparison option to ignore triggers on the target (T314479)
- Incorrect precision of the TINYINT data type in schema synchronization script (T314157)
- Remove inconsistent escaping chars from columns expressions (T310136)
- Incorrect quotes of DEFAULT values (T313524)
- Save user formatting for procedures and functions parameters
- Incorrect decimal separator in Data Editor (T313296, T315422)
- Error on copying table data with virtual columns
- Incorrect data formatting in Data Editor (T310401)
- Incorrect shift of visible zone in Database Diagram when drag-and-dropping objects to the container (T312054)
- Parameters applied only to the first query during multiple queries in Data Report (T307560)
- Incorrect formatting of DATETIME in the Formatting options window for Data Editor (T310931)
- Critical error when loading application (T310150)
- Improved Data Editor behavior in the Filter Editor window (T309337)
- Incorrect export of the date format when exporting from the results grid (T313468, T314591)
- Trace information was added to further fix of the issue with exporting to Xls file (T309909)
- Issues when profiling queries (T310496)
- Showing a valid object as invalid in Find Invalid Objects
- Object duplicates error in object search


dbForge Studio for MySQL Professional 9.0.338
Bug fixes:
- Problem with lost connection after 30 sec is fixed
- Problems with cache file are fixed
- Problem with date and time format is fixed
- Problem with loosing DEFINER is fixed


dbForge Studio for MySQL Professional 9.0.304
Connectivity:
- Connectivity support for MariaDB 10.5 is added
- Display of server type in the Property window for MySQL, MariaDB, Percona, Amazon, Alibaba Cloud, and Tencent Cloud is added
- Display of server type in the Connections section of the System window for MySQL, MariaDB, Percona, Amazon, Alibaba Cloud, and Tencent Cloud is added
- Database Connection Properties and Test Connection windows are redesigned
- Connectivity support for SkySQL is added

Database Design:
- The Find Invalid Objects feature is implemented

Support for new objects:
- Working with the Packages and Sequences established in MariaDB 10.3 is supported

SQL Document:
- -- nowarn and -- endnowarn tags have been added to the Execution warnings functionality
- Exporting execution history in the CSV file format is added

Code Completion:
- Code completion is available in the body of triggers and events

Data Editor:
- Cached Updates mode is implemented

Schema Compare:
- Scripts Folder comparison is added
- Object Filter is implemented
- Schema Comparison Report window is redesigned
- HTML reports are redesigned.
- Pre and post script execution during data synchronization
- Ignore DEFINER and SQL SECURITY clauses option is modified
- Ignore row format table option is added
- Ignore AUTO_INCREMENT option is added
- DDL Diff control is redesigned

Data Compare:
- Scripts Folder comparison is added
- Data Compare control is redesigned
- Data Comparison Report window is redesigned
- Pre and post script execution during data synchronization
- Option to append timestamp to the name of the data sync script file is added to Data Synchronization Wizard
- Option to set default values is added to Data Synchronization Wizard

Data Generator:
- Pre and post script execution during data population.

Database Backup:
- Option to disable reference tables from the backup is added

Data Export and Import:
- Output tab is added to Data Import Wizard and Data Export Wizard
- Data Export, CSV tab is added to the Options window
- Display of selected data export format is added to all tabs of Data Export Wizard

Other Improvements:
- Command line prompt is expanded with a full list of available exit codes
- Activation of the tool via the command-line interface is implemented

User-reported bug fixes:
- Problem with precision for Update Timestamp on MariaDB 10.3 is fixed
- Problem with generating CREATE script 'curdate()' with quotes is fixed
- Problem with generating null is fixed
- Problem with error on backup is fixed
- Problem with increment update is fixed
- Problem with displaying multi-line comments is fixed
- Problem with scrolling fields is fixed
- Problem with error exporting .rdb report to DOCX is fixed
- Problem with options editing format is fixed
- Problem with Restore running is fixed
- Problem with "find and replace" window is fixed
- Problem with comparing projects and databases is fixed
- Problem with displaying warnings in Output is fixed
- Problem with displaying property AUTO_INCREMENT is fixed
- Problem with completion list in case of using JOIN is fixed
- Problem with highlighting error is fixed
- Problem with displaying of controls for 4K monitors is fixed
- Problem with generating backup scripts is fixed
- Other user reported bugs are fixed


dbForge Studio for MySQL Professional 8.2.23
- Fixed: problem with connection to Azure Database for MySQL is fixed


dbForge Studio for MySQL Professional 8.2.21

Improvements:
- Support for Check Constraints for MySQL

User reported bugs fixed:
- Problem with script generating is fixed
- Problem with incorrect foreign key creating is fixed
- Problem with procedure debugging is fixed
- Problems with data export to Excel is fixed
- Other user reported bugs are fixed


dbForge Studio for MySQL Professional 8.1.45

Bugs fixed:
- Problem with "Set Value To Null" is fixed
- Problem with incorrect display of page count is fixed
- Problem with incorrect utc_timestamp quotes is fixed
- Problem with AUTO_INCREMENT property loosing is fixed
- Problem with wrong status message is fixed
- Problem with wrong table rebuild is fixed
- Problem with date format is fixed
- Problem with procedure debugging when lower_case_table_names = 0 is fixed
- Problem with smart data generators list is fixed
- Other user reported bugs are fixed


dbForge Studio for MySQL Professional 8.1.22
Connectivity
- Support for MariaDB 10.4

User reported bugs fixed
- "PDF view" mode of Data Viewer issue is fixed
- A comparison of objects names with different case issue is fixed
- "Spatial view" mode of Data Viewer issue is fixed
- Problem in Data Population Wizard is fixed
- Problem in SQL Document is fixed
- Other user reported bugs are fixed