Version History - 2013

SQLyog 11.3 (December 2013)

• Features

  -- The Query Profiler results can now be exported as HTML.

• Bug Fixes

-- Multiple 'reorder columns' operations in same instance of the dialog for this operation could have unexpected ordering results.
-- Strings containing a double-quote character are now escaped by doubling the double-quote character when also double-quote is selected for 'enclosed by'. This is a special rule for the double-quote character (other characters are escaped - if needed - with the backslash character) added for compliance with Excel and CSV-standards (at least Microsoft's interpretation of same) and -practices.
-- If databases named identically except for lettercase were available in a connection, Stored procedures, Stored Functions and Events could display in Object Browser where they should not.
-- When typing an object name (database or table) followed by a dot, the Autocomplete list of sub-objects could fail to popup. This was introduced in 11.28. Affected users may need to 'rebuild tags' after installing this build.

SQLyog 11.28 (November 2013)

• Bug Fixes

-- Schema Sync requires SELECT privilege to the `mysql` database for syncing non-table objects. If user did not have this privilege, SQLyog would display a generic message that the sync failed, but with no further information. We now ask user to check for privileges.
-- A sluggishness could occur in the editor when typing a function name followed by a bracket. It could happen for instance if specific versions of the Notepad++ text editor was installed on the system before SQLyog was installed.

• Miscellaneous

  -- The color used to indicate the selected row in DATA and RESULT grids is now clearer/brighter than before and thus more easily distinguishable from the darker rows of the grid.

SQLyog 11.27 (October 2013)

• Bug Fixes

-- 11.25 introduced a dependency on the VC++ redistributable for some Windows platform(s). If the redistributable was not installed SQLyog would not start. Affected was Windows 2008 Server r2 (at least).
-- Another dependency was introduced in 11.26 affecting Wine. Also here SQLyog could fail to start.
-- Fixed a rare case where connection to a SSH daemon failed while copying a database.
-- Fixed a crash in SJA when "To email" recipient was not specified in the job file.
-- With SSL connection the 'helper connection' opened in order to stop a running query would not use SSL. As a consequence the server could refuse this 'helper connection'.

• Miscellaneous

  -- SQLyog now uses "ALTER VIEW" statement instead of DROP and CREATE VIEW statements for ALTER VIEW operation.

SQLyog 11.26 (October 2013)

• Bug Fixes

  -- Fixed a random crash in Schema sync.
  -- Messages were not displaying in MESSAGES tab after creating/altering Views, Triggers, Stored Procedures etc.
  -- Horizontal scrollbar was not handled properly in Blob Viewer.
  -- Pressing ESC key to cancel the DROP TABLE operation was dropping the table on Wine.
  -- Comments inside a 'quoted string' were not escaped properly in query when executing in Query tab.
  -- On Windows Server 2008 r2 SQLyog could close down unexpectedly immediately after it was started.

SQLyog 11.25 (September 2013)

• Bug Fixes

-- When executing queries in more connections at the same time all connection tabs would only display the results when all query instances had returned.
-- If focus was on the table in Object browser selecting "copy table to" -option was not setting the focus to the selected table in the dialog.
-- Menu option 'Paste SQL Statement' will now format the query as per the SQL Formatter Preferences settings.
-- Sometimes SQLyog failed to connect to MySQL server via SSL. This was introduced in 11.2.
-- While copying a table/database, pressing SPACE would abort the copying process. Now it will not (but ENTER key will still abort the process).
-- On Wine expanding triggers- and stored procedures -folders in copy database dialog could crash SQLyog.
-- FIND option in Blob viewer could crash SQLyog with specific sequences of user operations.

• Miscellaneous

  -- Preference dialog will now display the the last closed tab.

SQLyog 11.24 (September 2013)

• Bug Fixes

  -- Fixed a memory corruption when accessing specific tables. In rare cases this could crash SQLyog. Only the 32 bit version was affected and only when using 'compressed protocol' for the connection.
  -- LOAD DATA LOCAL could fail to import data from a data file using 'Windows line breaks' (\r\n). This bug was introduced in 11.23 with the fix for non-ASCII characters in the file name.

SQLyog 11.23 (August 2013)

• Bug Fixes

  -- Fixed a rare crash which could occur while stopping query execution.
  -- Fixed a crash while expanding tables in Scheduled backup with no connection open.
  -- Import External Data truncated DOUBLE and FLOAT values to 6 digits after decimal point.
  -- Paste did not work in a column where a 'Foreign Key Lookup' icon displays (FK 'children' columns).
  -- When opening a SJA wizard multiple times and selecting an existing jobfile, the jobfile details were not displayed 2nd and higher times. Instead details from first time a job file was opened during the session were displayed.
  -- Exporting to a SQL-dump failed to escape properly, if a view contained columns with backtick(s) in the column identifier.
  -- Specifying a filename with non-ASCII characters in LOAD DATA LOCAL raised the error 'file not found' even if file existed and was valid.

SQLyog 11.22 (August 2013)

• Bug Fixes

  -- Fixed stability issues when running SQLyog with a non-English language interface on a system running a non-western locale. 'Hangs' and random crashes could occur. This bug was introduced in 11.2.
  -- With specific settings for the formatter the formatting preview in 'preferences' would not always show exactly how formatting would actually be done.
  -- After closing a maximized SQLyog program window with no connection window inside, SQLyog would open in non-maximized mode when started next time.

SQLyog 11.21 (August 2013)

• Features

  -- The interface for restoring connections from previous session has been changed due to user requests. There is now no popup dialog at startup, but instead a setting in Tools-> Preferences-> Others tab.

• Bug Fixes

-- Fixed a rare crash in HTTP-tunnel typically happening when copying huge databases or tables. Exact details of this crash would depend on the environment.
-- LOAD DATA LOCAL would hang indefinitely if a non-existing file was specified as argument. This bug was introduced in version 11.2.
-- In Schema Sync a comma could be missing before a COLLATE clause thus resulting in an invalid SQL statement.
-- A very large .zip archive generated by Scheduled Backup could fail to open due to a checksum error.

• Miscellaneous

  -- MySQL 3.23 and 4.0 servers are no longer supported and a connection attempt to such will be denied.

SQLyog 11.2 (July 2013)

• Features

  -- When opening SQLyog it is now posibble to have the same connections tab opened as when the program was closed last time. The feature is optional and individual connections can be selected.

• Bug Fixes

  -- If memory was exhausted SQLyog could crash. We will now exit gracefully.

• Miscellaneous

  -- Support for the clear-text plugin has been removed.

SQLyog 11.13 (June 2013)

• Bug Fixes

  -- The fix for incorrect escaping in DSN-authentication in 11.12 introduced a new problem with some ODBC-drivers - most important drivers for Oracle. Actually we belive that the code in 11.12 is correct according to ODBC standards and Windows API requirements. But affected drivers do not follow standards as regards to escaping of authentication details. We will now try to authenticate 'the old way' if authentication 'the new way' fails.

SQLyog 11.12 (June 2013)

• Bug Fixes

  -- Fixed a case where support for the 'cleart text plugin' did not work as expected and authentication failed.
  -- Import External Data could fail to authenticate to the ODBC-source if dsn-password contained a semicolon.
  -- Autocomplete would sometimes hang or crash while editing stored procedures. This bug was introduced in v11.0.
  -- Export table data as SQL generated an incorrect create table in the 64 bit version. Also this was introduced in v11.0
  -- For DATETIME fields in MySQL 5.6+, if CURRENT_TIMESTAMP was given as default, the default would be incorrectly quoted.

SQLyog 11.11 (April 2013)

• Bug Fixes

  -- Enum field drop down was not available in table data or result tab when http connections were used - introduced in v10.0
  -- Schema sync could generate an incorrect alter table statement for addition of foreign keys - introduced in v11.0.
  -- SJA was not decoding the dsn password and the ssh passphrase/password after reading it from the xml file.
  -- SQLyog 64 bit was extremely slow on some systems.

SQLyog 11.1 (April 2013)

• Features

  -- Added an option in the Connection Manager to keep a connection alive by pinging the server (using mysql_ping() ) at a user-specified interval.
  -- Encoding of all passwords in all job files in the same way that the passwords are encoded in the SQLyog.ini file. The job files created with version 11.1 will not work with previous versions of SQLyog/SJA. However, job files created with older versions of SQLyog will work with the new version.
  -- A setting in the connection manager for enabling the MySQL Cleartext Authentication Plugin. This sends the password in clear text and is to be used only if the user has a secure connection and a specific need for this. For example, if the server has PAM authentication enabled, then the password needs to be sent in clear text.

• Bug Fixes

  -- Incorrect mapping of the double data type when importing from access in import external data.
  -- Fixed a crash which would occur while dropping an index when table data was in focus - introduced in v10.
  -- In Visual Data Compare, an incorrect query could be generated if the primary key column was not the first column in the table - introduced in v10.5.
  -- COLLATE clause not handled properly in Schema Sync.
  -- If the difference between the structure of 2 tables was only the character set, then Schema Sync could incorrectly generate a comma in the alter table statement.
  -- Session timeout value was not stored in the job files.
  -- DataSync in SJA for linux 64 bit would fail in some cases due to incorrect typecasting.

• Miscellaneous

  -- Changes in the order of execution of statements when opening a new connection. Now the user specified init-command(s) will be executed after SQLyog's init-command(s).

SQLyog 11.01 (February 2013)

• Bug Fixes

  -- Fixed 2 issues introduced in 'Import External Data' when rewriting program code for 64-bit compilation as of version 11.0: 1) A job file with a (NDB-cluster) TABLESPACE specification and a WHERE clause failed to load in the wizard 2) non-ASCII defaults defined on non-unicode/ANSI string columns on source would be mapped against a UTF8 byte pattern and would garble for same reason.
  -- Fixed a rare crash occurring when dropping indexes from the Object Browser repeatedly.

SQLyog 11.0 (February 2013)

• Features

  -- Now SQLyog (including SJA for both Windows and Linux) is available as both 32 and 64 bit binaries. Obviously the 64 bit version will require a 64 bit Windows. 32 bit version will install to 'Program Files (x86)' and 64 bit to 'Program Files' on 64 bit systems.
  -- Autocomplete is now context-aware. The keyword before any type of autocomplete popup/dialog will be used for filtering and displaying only object types relevant in the context.

• Bug Fixes

  -- Copy to clipboard from GRID could in rare cases truncate the last row away. This bug was introduced in version 9.51.
  -- Fixed a bug in import external data where clicking on "select all" would select tables even when no data was returned from the source. This could cause a crash while executing the job. This was introduced in 10.1.
  -- If there was no default database selected in the main dialog of SQLyog, changing the database from the dropdown in 'backup as SQL dump' dialog would cause SQLyog to hang. Introduced in version 10.5.
  -- When using drag and drop to create a Foreign Key constraint in Schema Designer, the ALTER TABLE pop-up dialog would have the view scrolled to the right, resulting in the leftmost two columns being hidden. This issue was introduced in 9.6.
  -- The position from where the 'Themes' folder was read did not honor a specified -dir startup switch. It will now read from a 'Themes' subfolder to the folder specified with -dir if exists.
  -- Schema Sync could attempt to DROP and CREATE a Foreign Key in one ALTER TABLE statement in cases where a Foreign Key existed on both source and target specified on same columns but details for ON UPDATE and/or ON DELETE were different. This will not work and now two statements are generated.

• Miscellaneous

  -- Explain Extended (executed by Query Profiler) now pops up an error dialog instead of logging to MESSAGES tab if an error occurs with the statement.