Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Fixed
-
N/A
-
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.