Failed to parse Mysql CHARACTER SET with COLLATE clause

[miniliuke]

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.