HitmanPro.Alert

What's new in this version:

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