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

          Activity

            danblack Daniel Black created issue -
            danblack Daniel Black made changes -
            Field Original Value New Value
            danblack Daniel Black made changes -
            Assignee Anel Husakovic [ anel ]
            danblack Daniel Black made changes -
            Summary CREATE SEQUENCE to accept RESTART WITH (lke alter sequence) CREATE SEQUENCE to accept RESTART WITH (like alter sequence)
            danblack Daniel Black made changes -

            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.
            monty Michael Widenius made changes -
            Fix Version/s N/A [ 14700 ]
            Fix Version/s 10.3 [ 22126 ]
            Resolution Won't Fix [ 2 ]
            Status Open [ 1 ] Closed [ 6 ]
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 112782 ] MariaDB v4 [ 134324 ]

            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.