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

SEQUENCE with zero increment is not described in mariadb documentation

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

            Ascending order - Click to sort in descending order
            sanja Oleksandr Byelkin created issue -
            elenst Elena Stepanova made changes -
            Field Original Value New Value
            Summary SECUENCE with zero increment is not described in mariadb documentation SEQUENCE with zero increment is not described in mariadb documentation
            greenman Ian Gilfillan made changes -
            Component/s Sequences [ 14009 ]
            greenman Ian Gilfillan made changes -
            greenman Ian Gilfillan made changes -
            Fix Version/s N/A [ 14700 ]
            Fix Version/s 10.3 [ 22126 ]
            Resolution Fixed [ 1 ]
            Status Open [ 1 ] Closed [ 6 ]
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 86797 ] MariaDB v4 [ 154259 ]

            People

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

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

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