db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Bryan Pendleton <bpendle...@amberpoint.com>
Subject Re: syntax for generated-column-spec: bug in doc or code?
Date Tue, 03 Oct 2006 15:55:38 GMT
> When I try it, 0 is flagged as illegal, as I would expect:
> 
> ij> create table f (i int generated by default as identity (start with 1, increment
by 0), j int);
> 
> ERROR 42Z21: Invalid increment specified for identity for column 'I'. Increment cannot
be zero.  

This behavior seems reasonable to me. I can't think of a reason that
I would want to set INCREMENT BY to 0.

I would prefer to change the docs in this case, than to change the code.

thanks,

bryan


Mime
View raw message