Re: [Firebird-devel] Positioned attributes in CREATE/ALTER sequence statement

[Dimitry S. <sd...@ib...>]

08.03.2016 13:33, Dmitry Yemanov wrote:
> The only way
>
> CREATE OR ALTER SEQUENCE S;
>
> can be allowed is that is acts as RESTART WITH 0 INCREMENT BY 1 for
> existing sequences.
>
> This way the behaviour is consistent: both CREATE and ALTER produce the
> same result: existence of generator S with the same properties {start
> value = 0, current value = 0, increment = 1}.

   But in this case behavior will be inconsistent with plain ALTER TABLE that doesn't 
change not mentioned attributes.
   I hope you won't insist that "ALTER SEQUENCE s1 INCREMENT 3" must reset value to 0?..

-- 
   WBR, SD.