Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-21250

Better error message for Dropping a column that is part of a multi-column UNIQUE constraint is not permitted.

    XMLWordPrintable

Details

    • Task
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • None
    • None
    • None

    Description

      > Dropping a column that is part of a multi-column UNIQUE constraint is not permitted.

      IMO "[42000][1072] Key column 'A' doesn't exist in table" doesn't make sense. Could it just say it's not permitted?

      Why isn't this permitted BTW?
      Of course the constraint would be more strict but that's to be expected.

      https://mariadb.com/kb/en/library/alter-table/

      Attachments

        Activity

          People

            Unassigned Unassigned
            XTF Olaf van der Spek
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

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