Alter table wizard hangs when MariaDB table uses system versioning

webyog / sqlyog-community

Webyog provides monitoring and management tools for open source relational databases. We develop easy-to-use MySQL client tools for performance tuning and database management. Webyog's solutions include SQL Diagnostic Manager for MySQL performance optimization and SQLyog for MySQL administration. More than 35,000 companies (including Amazon, IBM, Salesforce, AT&T, eBay, and GE) and 2.5 million users rely on Webyog's solutions to provide valuable insights into their databases. Webyog is an Idera, Inc. company.

GNU General Public License v2.0

2.19k stars 322 forks source link

Steps to reproduce:

CREATE TABLE `test` (
  id INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY,
  product VARCHAR(80)
) WITH SYSTEM VERSIONING;

Now right-click on the table name and and select "alter table". A wizard dialog appear. Klick on the "SQL Preview" tab. Now SqlYog hangs, although I did not modify anything.

The alter table statement works fine when executed manually:

SET @@system_versioning_alter_history = KEEP;
ALTER TABLE test CHANGE product product VARCHAR(100);

Even after setting this system property, the wizard dialog hangs anyway.

Environment: Debian Linux 10 MariaDB 10.3.22 Wine 4.0-2 SqlYog Community 13.1.5 64bit

webyog / sqlyog-community

Alter table wizard hangs when MariaDB table uses system versioning #2255