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

[Dmitry Y. <fir...@ya...>]

08.03.2016 19:37, Dimitry Sibiryakov 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.

We don't have CREATE OR ALTER for tables, do we?

> I hope you won't insist that "ALTER SEQUENCE s1 INCREMENT 3" must reset value to 0?..

Surely not. I was speaking about CREATE OR ALTER only.


Dmitry