MySQL - setting remarks on a column generates sql for comments on the whole table

Description

This changeset:
<databaseChangeLog xxxxxxxx>
<changeSet author="root (generated)" id="1574189348049-1">
<setColumnRemarks columnName="nickname" remarks="nickname" tableName="t_user"/>
</changeSet>
</databaseChangeLog>

when run on a MySQL database will generate SQL that looks like this:

ALTER TABLE testdb.t_user COMMENT = 'nickname';

It should generate SQL that is more like this:

ALTER TABLE `user` CHANGE `id` `id` INT( 11 ) COMMENT 'id of user'

Note that the existing definition of the column must be included in the statement. See https://dev.mysql.com/doc/refman/8.0/en/alter-table.html#alter-table-redefine-column for details

This was reported in https://stackoverflow.com/questions/58941026/liquibase-sql-generated-error-with-column-comments?noredirect=1#comment104209636_58941026

Environment

MySQL, various versions

Status

Reporter

Steve Donie

Components

Affects versions

Priority

Major
Configure