![]() After executing the sync script from the editor it still could occur that the sync tool reported differences. ![]() Fixed a bug with Stored Procedures and Structure Sync. Solved the problem reported by a fraction of users that the sqlyog.ini file was not copied when upgrading from 6.05 and earlier versions. If user's 'AppData' path used special characters (due to a localized 'AppData' folder or a user name with special characters) program was not able to access sqlyog.ini for read and write operations. With a large ('wide') table specific repeated operations with the SCROLL BARs, SCROLL BUTTONs and arrow keys could cause a crash in the DATA tab. Fixed an issue with DATA SYNC when the Primary Key was based on a BIGINT and value for this PK field was greater than 2147483647. 'change table type' was disabled when connected to the most recent MySQL 5.1 releases (due to a recent change in the Information_Schema content with those MySQL versions). Page wise (using the current LIMIT setting) display in table data with '' (next) buttons. Structure Sync now supports column level charset/collations. Functionalities of F5 and F9 can be switched. In CREATE/ALTER TABLE we now perform client-side validation for the most common user errors (such as failure to specify the length of a data type where it is required). advanced dialogue (removed largely depreciated 'RAID' and 'PASSWORD' options). Added an option to specify DEFAULT charset/collation for databases and tables different from 'upper-level' default (server/database). Common error dialogue: when a GUI operation returns an error the error message is 'wrapped' in a dialogue explaining the meaning and origin of the error message (note that this is not implemented when manually executing queries from the editor). Symptom was that updates could fail with MySQL error 1064 (syntax error). ![]() The fix for BIGINT based PK's greater than 2147483647 in 6.1 introduced another problem with data sync. Fixed a pointer corruption when importing from a file. Fixed an issue that could cause SMTP authentication to fail. ![]() Fixed an encoding issue with special characters and Data Sync when syncing between MySQL versions where one supports SET NAMES and the other one does not. Fixed an issue with Migration Tool where importing Foreign Keys could fail when migrating from Microsoft Access. Scheduled Backup threw the error "incorrect table name" when backing up all tables from MySQL 4.0 and before ('export' had no such issue). Duplicate column name foreign key sqleditor code#SQLyog could crash when trying to connect to a server when the thread used for establishing the previous connection had not stopped executing ( code for creating connection wasn't thread-safe). Structure Sync could generate DROP statements where the name of the object to be dropped was empty. Reading from sqlyog.ini was slow with huge number of connections. Those details that could not be read were lost. As a consequence details that could not be read would not be written. Empty or incomplete lines in sqlyog.ini would cause stop reading from the file. Fixed a display issue in DATA tab with large DPI monitor setting. Horisontal scrollbars were added where missing. When a Foreign Key referenced a column used for the definiton of a multi-column Primary Key the Schema Designer could display a "1" and (not a "infinity" symbol as it should be) at the 'parent'. With specific data 'export as Excel XML' could mistake text data for binary data. ![]() Exports could generate duplicate rows if there was activity on the screen while exporting. On Wine a meaningless error message when selecting a table could occur. COMMUNITY version (not ENTERPRISE) could crash when editing connection details. ALTER TABLE would generate invalid SQL with column-level comments. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |