Hi Bryan,
No, I don't do any checks on the value other than the fact that it should be an integer constant. Don't recall seeing anything in SQL spec about it either.
thanks,
Mamta
On 1/3/06, Bryan Pendleton <[EMAIL PROTECTED]> wrote:
> Changed sqlgrammar.jj to add parser support for ALTER TABLE <tablename>
> ALTER <columnName> RESTART WITH integer-constant
Is it legal to set RESTART WITH to a value which is less than or equal to
a value which already exists in my table? That is, does Derby check to
see that I am setting the new value to something which is higher than any
value that already exists in my table? Or does Derby just trust that I
have provided a sensible value?
I have no particular opinion one way or the other, I was just wondering
how you had implemented the feature.
thanks,
bryan
