Start off with the following:
CREATE TABLE test
(
extra_info
BLOB NULL DEFAULT NULL,
test_int
INT(11) NULL DEFAULT '1'
)
COLLATE='utf8_general_ci'
ENGINE=InnoDB
;
Then add a comment to the test_int field and you get the following which is now invalid SQL and very bad as the default value is no longer present.
CREATE TABLE test
(
extra_info
BLOB NULL DEFAULT NULL,
test_int
INT(11) NULL DEFAULT ''
)
COLLATE='utf8_general_ci'
ENGINE=InnoDB
;
This bug plus that CHECK constraints are also removed on table schema changes makes HeidiSQL very dangerous to modify table structures.