Version History - 2021

SQLyog 13.1.8 (April 2021)

• Bug Fixes:

      --With MariaDB System-Versioned tables, SQLyog was hanging when clicking in SQL Preview in the Alter table wizard.
      --Indexes were not being displayed with MariaDB System-Versioned tables.
      --In some cases, LOAD DATA LOCAL INFILE query failed to be executed from the Query Editor.
      --Schema Sync tool generated incomplete queries if the table contained an exceptionally long ENUM data type.
      --In some rare cases, Schema Sync failed to sync the mismatch, even after executing the query generated by the Schema Sync tool.
      --SQLyog generated an incorrect ALTER TABLE statement in Schema synchronization with 'TIMESTAMP' and integer (INT, TINYINT, BIGINT, and SMALLINT) data types for MySQL Server version 8.0.19 or above with any target MySQL version and vice versa. Though the Schema Sync will still display the difference in the schema, SQLyog now allows the data to be synced for only INT, TINYINT, BIGINT, and SMALLINT data types.
      --In some cases, Schema Sync reported nonexistent differences in the schema.
      --When the connection was idle for a long time, executing Copy Database/Table or opening a new connection using the option New Connection Using Current Settings returned different MySQL errors like Error No. 1043 Bad Handshake.