Re: Identity value of 0

Here's some freaky stuff. I never would have suspected I would have
gotten that 2.

create table qtemp.testtable (
"ID" INTEGER GENERATED ALWAYS AS IDENTITY (
START WITH 1 INCREMENT BY 1
NO MINVALUE NO MAXVALUE
NO CYCLE NO ORDER
CACHE 20 ),
mytext char(20));
INSERT INTO QTEMP.TESTTABLE (MYTEXT) VALUES('D');

SELECT * FROM QTEMP.TESTTABLE; -- "ID"=1

UPDATE QTEMP.TESTTABLE OVERRIDING USER VALUE
SET ID =0, MYTEXT='a'
WHERE ID=1;

SELECT * FROM QTEMP.TESTTABLE; -- "ID=2

UPDATE QTEMP.TESTTABLE OVERRIDING SYSTEM VALUE
SET ID =0, MYTEXT='q'
WHERE ID=2;

SELECT * FROM QTEMP.TESTTABLE; -- "ID=0


Rob Berendt