MicroFix - Mysql copy Table Enum Default value without quote

HeidiSQL 10.3.0.5906 - Mysql V 5.7.27

when using in HeidiSQL to function copy Table,

If a column ENUM have a default value, this is not wrapped.

CREATE TABLE `tmp`.`tttt_copy` (
    `aaa` ENUM('Y','N') NULL DEFAULT Y COLLATE 'utf8_general_ci'
)
 COLLATE 'utf8_general_ci' ENGINE=MyISAM ROW_FORMAT=Fixed;
/* Errore SQL (1064): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Y COLLATE 'utf8_general_ci'
)
 COLLATE 'utf8_general_ci' ENGINE=MyISAM ROW_FOR' at line 2 */

correct is DEFAULT 'Y' COLLATE not DEFAULT Y COLLATE

Tks W:-}

Please update to the next nightly build. I just added more logic for separating functions/expressions from text in column default values.

There are also differences in current MariaDB versions compared to MySQL. See https://mariadb.com/kb/en/information-schema-columns-table/ how "COLUMN_DEFAULT" is quoted.

MySQL only supports CURRENT_TIMESTAMP and similar in temporal columns, or are there more?

HeidiSql 10.3.0.5909 Work fine

it has been correctly created

CREATE TABLE `tttt_copy` (
    `aaa` ENUM('Y','N') NULL DEFAULT 'Y' COLLATE 'utf8_general_ci',
    `bbb` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `Colonna 3` INT NULL
)
COLLATE='utf8_general_ci'
ENGINE=MyISAM
ROW_FORMAT=FIXED
;

Tks

W:-}