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

Documentation improvements for Sequence objects

    XMLWordPrintable

    Details

      Description

      Documentation tweaks needed for Sequence Objects

      1. Users may experience confusion between SEQUENCE Storage Engine and SEQUENCE Object.
      https://mariadb.com/kb/en/mariadb/create-sequence/
      https://mariadb.com/kb/en/mariadb/sequence/

      Both chapters should include small disclaimer which clarifies that these are unrelated syntax elements, despite having similar name.

      2. Sequence objects act as regular tables in many contexts, including LOCK TABLES command.
      This may complicate migration from other RDBMS which use both LOCK TABLES and Sequence objects, because e.g. in Oracle LOCK TABLES does allow to increment sequences. This difference should be documented.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              greenman Ian Gilfillan
              Reporter:
              anikitin Andrii Nikitin (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: