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
------------------------------------------------------------------------------
Transform Data into Opportunity.
Accelerate data analysis in your applications with
Intel Data Analytics Acceleration Library.
Click to learn more.
http://makebettercode.com/inteldaal-eval
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
