ALTER SEQUENCE RESTART WITH <n> should not change the initial sequence START
value
----------------------------------------------------------------------------------
Key: CORE-6386
URL: http://tracker.firebirdsql.org/browse/CORE-6386
Project: Firebird Core
Issue Type: Bug
Affects Versions: 3.0.6, 4.0 Beta 2
Reporter: Adriano dos Santos Fernandes
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.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
