Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

ALTER SEQUENCE RESTART WITH <n> should not change the initial sequence START value [CORE6386] #6625

Closed
firebird-issue-importer opened this issue Aug 11, 2020 · 5 comments

Comments

@firebird-issue-importer

Submitted by: @asfernandes

Replaces CORE5133

Standalone ALTER SEQUENCE RESTART WITH and IDENTITY COLUMN RESTART WITH has different behavior.

If standalone sequence is created with initial value 10, then later
RESTARTed WITH value 20 and then RESTARTed, it's restarted to 20.

With identity column RESTART WITH value is not saved and the last
restart goes to 10.

Accordingly to the standard, the START value is part of the "descriptor", so it's stored in metadata.

But in ALTER SEQUENCE RESTART WITH, that descriptor is not updated.

It does only update the sequence's current value.

We had this behavior but it was changed with CORE5133.

Commits: e94c66b FirebirdSQL/fbt-repository@95fb600

====== Test Details ======

See fbt-repo\tests\functional\generator\alter_01.fbt

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Aug 11, 2020

Modified by: @asfernandes

assignee: Adriano dos Santos Fernandes [ asfernandes ]

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Aug 12, 2020

Modified by: @asfernandes

status: Open [ 1 ] => Resolved [ 5 ]

resolution: Fixed [ 1 ]

Fix Version: 4.0 RC 1 [ 10930 ]

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Aug 13, 2020

Modified by: @pavel-zotov

status: Resolved [ 5 ] => Resolved [ 5 ]

QA Status: No test => Covered by another test(s)

Test Details: See fbt-repo\tests\functional\generator\alter_01.fbt

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Aug 13, 2020

Modified by: @pavel-zotov

status: Resolved [ 5 ] => Closed [ 6 ]

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Sep 19, 2020

Modified by: @mrotteveel

Link: This issue replaces CORE5133 [ CORE5133 ]

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Linked pull requests

Successfully merging a pull request may close this issue.

None yet
2 participants