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. ------------------------------------------------------------------------------ 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
