SQLyog v12.19 released

Released: Feb 9, 2016

Updates in this release

Updates in 12.19

Features:

  • Virtual Columns support for MySQL 5.7 onwards (Virtual Columns with MariaDB were already supported). Please see note below for details.
  • SSL and SSH-tunnel are now not mutually exclusive. A SSL connection may now be established through an SSH-tunnel. This is in particular useful with various sorts of "private clouds" where connection to the cloud requires SSH and privacy of the cloud is enforced by using SSL for internal communication in the cloud.
  • Multiple files (.sql, .schemaxml, .queryxml) may now be opened in one operation in main editor window.

Bug Fixes:

  • When importing from some (not commonly used) external data sources using a WHERE-clause a SPACE was missing before the "WHERE" keyword causing an error. This is actually an issue with ODBC-drivers affected, but this release has a workaround.
  • In CREATE/ALTER TABLE dialog a default value could be specified for BLOB/TEXT columns. The server does not permit this and doing so will result in a server error. Now the GUI prevents it.
  • Fixed minor bugs with the Virtual Columns support for MariaDB.

Miscellaneous:

  • SQLite has been upgraded to version 3.10.0. This results in performance improvements (in autocomplete in particular).