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

DROP FOREIGN KEY IF EXISTS is not supported in 10.3.11

    XMLWordPrintable

Details

    Description

      "IF EXISTS" option was added to several commands of ALTER TABLE, including "DROP FOREIGN KEY", a while ago

      It throws a syntax error on 10.3.11

      I am not sure on which version exactly the regression happened.

      I know that DROP FOREIGN KEY IF EXISTS works fine on 10.0.36 (had it working on local setup and downgraded server to this version to avoid patching code)

      Attachments

        Activity

          People

            Unassigned Unassigned
            support@excsitement.com jaborandi
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

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