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

Confusing highlighted block on the page describing FK in KB

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Fixed
    • N/A
    • N/A
    • Documentation
    • None

    Description

      The KB page about foreign keys https://mariadb.com/kb/en/foreign-keys/ has this text block at the beginning of Syntax section:

      Note: MariaDB accepts the REFERENCES clause in ALTER TABLE and CREATE TABLE statements, but that syntax does nothing. MariaDB simply parses it without returning any error or warning, for compatibility with other DBMS's. However, only the syntax described below creates foreign keys.

      Maybe it is severely outdated or unfortunately phrased, I can't figure out from the text or from the history what it was supposed to mean at the time it was added. Either way it's confusing and needs to be updated, as clearly the REFERENCES clause is an essential part of FK definition and it's not ignored.

      Attachments

        Activity

          People

            greenman Ian Gilfillan
            elenst Elena Stepanova
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.