Issue Details (XML | Word | Printable)

Key: CORE-6386
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Major Major
Assignee: Adriano dos Santos Fernandes
Reporter: Adriano dos Santos Fernandes
Votes: 0
Watchers: 2
Operations

If you were logged in you would be able to see more operations.
Firebird Core

ALTER SEQUENCE RESTART WITH <n> should not change the initial sequence START value

Created: 11/Aug/20 03:29 PM   Updated: 19/Sep/20 03:16 PM
Component/s: None
Affects Version/s: 4.0 Beta 2, 3.0.6
Fix Version/s: 4.0 RC 1

Issue Links:
Replace
 

QA Status: Covered by another test(s)
Test Details: See fbt-repo\tests\functional\generator\alter_01.fbt


 Description  « Hide
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 CORE-5133.

 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
There are no comments yet on this issue.