Author Topic: Inline MySQL comment causes error  (Read 6611 times)

Offline mhuether

  • Newbie
  • *
  • Posts: 2
Inline MySQL comment causes error
« on: March 31, 2023, 01:29:31 PM »
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)