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

Reply via email to