CONNECT 'jdbc:derby:test;create=true';

CREATE TABLE TABLE1(NAME1 VARCHAR(10));
INSERT INTO TABLE1(NAME1) VALUES('before');
ALTER TABLE TABLE1 ADD COLUMN TIMESTAMP1 TIMESTAMP;
ALTER TABLE TABLE1 ADD COLUMN STR1 VARCHAR(10);
ALTER TABLE TABLE1 ADD COLUMN STR2 VARCHAR(10);

--This update is important.
UPDATE TABLE1 SET STR2 = 'before2';

SELECT * FROM TABLE1;

AUTOCOMMIT OFF;
UPDATE TABLE1 SET NAME1='after', TIMESTAMP1=CURRENT_TIMESTAMP,  STR1='after', STR2='after';
SELECT * FROM TABLE1;
ROLLBACK;

AUTOCOMMIT ON;
SELECT * FROM TABLE1;
