Re: [Firebird-devel] ALTER SEQUENCE RESTART

2020-08-06 Thread Mark Rotteveel
On 05-08-2020 10:53, Mark Rotteveel wrote: On 05-08-2020 03:34, Adriano dos Santos Fernandes wrote: 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

Re: [Firebird-devel] ALTER SEQUENCE RESTART

2020-08-05 Thread Mark Rotteveel
On 05-08-2020 03:34, Adriano dos Santos Fernandes wrote: 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

[Firebird-devel] ALTER SEQUENCE RESTART

2020-08-04 Thread Adriano dos Santos Fernandes
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 t