Eric Radzinski wrote:

> *   autocommit on;
>    CREATE TABLE tauto(i INT GENERATED BY DEFAULT AS IDENTITY, k INT);
>    CREATE UNIQUE INDEX tautoInd ON tauto(i);
>    INSERT INTO tauto(k) values 1,2;  *

Remove the 'autocommit on', it doesn't add anything here and is not
supported by Derby, only by ij. And this is the reference manual for Derby.

The reference manual also seems to be inconsistent on if statements are
terminated with a semi-colon in examples. Again the semi-colon is an ij
feature, the engine itself does not support it.

Dan.

Reply via email to