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

CREATE SEQUENCE to accept RESTART WITH (like alter sequence)

Details

    Description

      While `ALTER SEQUENCE` could get to this value, lets get there in one step.

      Attachments

        Issue Links

          blocks

          Bug - A problem which impairs or prevents the functions of the product. MDEV-21786 mysqldump will forget sequence definition details on --no-data dump

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Task - A task that needs to be done. MDEV-23524 SHOW CREATE SEQUENCE to output restart value

          • Major - Major loss of function.
          • Closed

          Activity

            monty Michael Widenius added a comment -

            There is no reason whatsoever to have for CREATE STATEMENT... RESTART WITH

            This is not part of the SQL standard (a far as I know) and neither ORACLE or PostgreSQL has it.

            If one wants to start the sequence at a specific value one should use START=
            If one wants to set the value for an existing sequence, one can use SETVALUE()

            By the way, when asking for a new feature, please describe in detail why this is needed and how it should be used. That information is critical in deciding if a feature should be added to MariaDB or if there is already a workaround that makes the request not needed.

            monty Michael Widenius added a comment - There is no reason whatsoever to have for CREATE STATEMENT... RESTART WITH This is not part of the SQL standard (a far as I know) and neither ORACLE or PostgreSQL has it. If one wants to start the sequence at a specific value one should use START= If one wants to set the value for an existing sequence, one can use SETVALUE() By the way, when asking for a new feature, please describe in detail why this is needed and how it should be used. That information is critical in deciding if a feature should be added to MariaDB or if there is already a workaround that makes the request not needed.

            People

              anel Anel Husakovic
              danblack Daniel Black
              Votes:
              0 Vote for this issue
              Watchers:
              3 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.