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

          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-16035 SEQUENCE with zero increment does not behave as expected

          • Major - Major loss of function.
          • Closed

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved:

                Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0d
                  0d
                  Logged:
                  Time Spent - 0.5h
                  0.5h

                  Git Integration

                    Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.