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

Confusing highlighted block on the page describing FK in KB

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: N/A
    • Fix Version/s: N/A
    • Component/s: Documentation
    • Labels:
      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

            Assignee:
            greenman Ian Gilfillan
            Reporter:
            elenst Elena Stepanova
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Git Integration