You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
{{ message }}
Repository navigation
Failed to parse Mysql CHARACTER SET with COLLATE clause #1544
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.
Activity
LucaCappelletti94 commentedon Sep 23, 2026
Completed by #1731.