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

[Robbert-Jan <rjm...@xs...>]

Hi,
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?


Kind regards, 
Robert

From: Robbert-Jan 
Sent: Monday, February 03, 2014 1:50 PM
To: fir...@li... 
Subject: [Firebird-test] Alpha2: adding identity column with START WITHclause gives error

Testing WI-T3.0.0.30809 Firebird 3.0 Alpha 2:

ALTER TABLE Test
ADD IdentityTest
INTEGER
GENERATED BY DEFAULT AS IDENTITY
START WITH 1

error:
Dynamic SQL Error
SQL error code = -104
Token unknown - line 5, column 1
START


Note:
This works okay: ALTER TABLE Test ADD IdentityTest INTEGER GENERATED BY DEFAULT AS IDENTITY
This works also okay: ALTER TABLE Test ALTER IdentityTest RESTART WITH 1

Kind regards,
Robert
- NL



--------------------------------------------------------------------------------
------------------------------------------------------------------------------
Managing the Performance of Cloud-Based Applications
Take advantage of what the Cloud has to offer - Avoid Common Pitfalls.
Read the Whitepaper.
http://pubads.g.doubleclick.net/gampad/clk?id=121051231&iu=/4140/ostg.clktrk 


--------------------------------------------------------------------------------
_______________________________________________
Firebird-test mailing list
Fir...@li...
https://lists.sourceforge.net/lists/listinfo/firebird-test