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

Inconsistent documentation on AUTO_INCREMENT

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: N/A
    • Fix Version/s: N/A
    • Component/s: Documentation
    • Labels:
      None
    • Environment:
      online documentation

      Description

      The MariaDB page for AUTO_INCREMENT (https://mariadb.com/kb/en/mariadb/auto_increment/) says that the AUTO_INCREMENT column in a table "must be the PRIMARY KEY or a UNIQUE key." But the AUTO_INCREMENT FAQ page (https://mariadb.com/kb/en/mariadb/autoincrement-faq/) says "it only has to be indexed. It doesn't even have to be unique."

        Gliffy Diagrams

          Attachments

            Activity

            Hide
            elenst Elena Stepanova added a comment - - edited

            Thanks for the report.
            FAQ wins.

            Show
            elenst Elena Stepanova added a comment - - edited Thanks for the report. FAQ wins.
            Hide
            greenman Ian Gilfillan added a comment -

            The documentation has been updated

            Show
            greenman Ian Gilfillan added a comment - The documentation has been updated

              People

              • Assignee:
                greenman Ian Gilfillan
                Reporter:
                libcub Paul Weiss
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: