Re: [Firebird-test] Alpha2: adding identity column with START WITH clause gives error

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

03.02.2014 19:49, Robbert-Jan wrote:
>
> Seems the START WITH clause needs to be between parenthesses, so:
>     ALTER TABLE Test ADD IdentityTest INTEGER GENERATED BY DEFAULT AS
> IDENTITY (START WITH 1)
> works!
> However, is it possible to make the parser a little bit more intelligent
> so parentheses are not needed?

This is not our personal choice. The SQL specification requires 
parentheses and I don't think we should relax the syntax.


Dmitry