Failed to parse Mysql CHARACTER SET with COLLATE clause

When using SQLParser, the following ALTER TABLE statement fails to parse:
ALTER TABLE `test`.`test` MODIFY COLUMN `v` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL AFTER `id`,DROP PRIMARY KEY,ADD PRIMARY KEY (`id`, `v`) USING BTREE
The issue seems to be related to the presence of the COLLATE latin1_swedish_ci clause. If the COLLATE clause is removed, the statement parses successfully.

Start by reproducing the reported ALTER TABLE statement with SQLParser, comparing it with the version that omits the COLLATE clause. The work is done when the full MySQL statement, including CHARACTER SET and COLLATE, parses successfully.

Written by the indexing model from the issue text.