Hi! I'm looking at different behavior of standalone ALTER SEQUENCE RESTART and IDENTITY COLUMN RESTART.
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. Personally I prefer the standalone sequence behavior, but it's not what I understand in 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. Could someone also take a look? Should we change one or another behavior? Adriano Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
