[MDEV-33814] Wrong error message "Can't create table" on "ALTER TABLE" - Jira

XML

Word

Printable

An error in an "ALTER TABLE" command generates a "Can't create table" error :

MariaDB [test]> ALTER TABLE cluster

    ->     DROP CONSTRAINT fk_utilisateur_cluster,

    ->     ADD CONSTRAINT fk_utilisateur_cluster FOREIGN KEY (owner_id) REFERENCES utilisateur (id)

    ->         ON DELETE SET NULL;

ERROR 1005 (HY000): Can't create table `test`.`cluster` (errno: 121 "Duplicate key on write or update")

It should rather be "Can't alter table".

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.