Inline MySQL comment causes error

[mhuether]

I updated an old installation from 1.2 to 1.6 and got an MySQL error because of inline comment in SQL/mysql/2016112200.sql:

ALTER TABLE `dictionary` ADD COLUMN `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST; -- redundant, for compat. with Galera Cluster

When I remove the comment or place it above the statement, everything works fine.

I'm using MySQL 8.0.32 on macOS 13.3 (Ventura)