You are viewing a plain text version of this content. The canonical link for it is here.

Posted to derby-dev@db.apache.org by ac...@comcast.net on 2006/03/31 01:33:24 UTC

Generated Identity Columns

In the middle of page 29 of the Derby reference manual, there is an example of using Generated By Default:

create table greetings
(i int generated by default as identity, ch char(50));

Unfortunately, when I try to execute this statement, it gives me an error on the word "by".

Has support for "by default" been removed? If so, shouldn't the manual be updated to reflect that?

Re: Generated Identity Columns

Posted by Satheesh Bandaram <ba...@gmail.com>.

Check which version of Derby you are using... This feature was introduced in
10.1.1 and should be present in 10.1.2 and later versions.

Satheesh

On 3/30/06, acemccloudxx@comcast.net <ac...@comcast.net> wrote:
>
> In the middle of page 29 of the Derby reference manual, there is an
> example of using Generated By Default:
>
> create table greetings
> (i int generated by default as identity, ch char(50));
>
> Unfortunately, when I try to execute this statement, it gives me an error
> on the word "by".
>
> Has support for "by default" been removed? If so, shouldn't the manual be
> updated to reflect that?
>