SET AUTOCOMMIT OFF

CREATE TABLE T1 (A INTEGER);

INSERT INTO T1 VALUES (1);

INSERT INTO T1 VALUES (2);

INSERT INTO T1 VALUES (3);

COMMIT;

INSERT INTO T1 (4);

INSERT INTO T1 (5);

ROLLBACK;

SELECT SUM(A) FROM T1