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

SEQUENCE with zero increment is not described in mariadb documentation

    XMLWordPrintable

    Details

      Description

      https://mariadb.com/kb/en/library/create-sequence/

      lack information about case of INCREMENT equal to 0.

      ORACLE and MSSQL prohibit it according to documentation
      DB2 thread the sequence as accidental and so we do (at least according my experience)

      CREATE SEQUENCE s INCREMENT 0;
      SELECT NEXTVAL(s);
      NEXTVAL(s)
      1
      SELECT NEXTVAL(s);
      NEXTVAL(s)
      2
      SELECT NEXTVAL(s);
      NEXTVAL(s)
      3
      

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              greenman Ian Gilfillan
              Reporter:
              sanja Oleksandr Byelkin
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: