Error while creating new tables, alter tables, table copies etc. (mysql/mariadb)

There is an error while creating new tables, alter tables, table copies etc:

The quotation marks are missing for default values. I.E.:

ALTER TABLE table CHANGE COLUMN Column ColumnNew VARCHAR(255) NOT NULL DEFAULT COLLATE 'latin1_german2_ci' AFTER ColumnPrev;

This should be (emtpy default value):

ALTER TABLE table CHANGE COLUMN Column ColumnNew VARCHAR(255) NOT NULL DEFAULT "" COLLATE 'latin1_german2_ci' AFTER ColumnPrev;

HTH CoolWater

Please report your used HeidiSQL version.

The latest builds may surely throw such errors, as I am working on a larger code change. In case you use a build, I can currently recommend not to use them, use the last stable release instead.

My HeidiSQL version is 10.3.0.5811

I will revert back to the lastest stable release in this case... :-)

Regards CoolWater