SET STORAGE_ENGINE='Falcon';
*** Bug #200 ***
DROP TABLE IF EXISTS testSavepoints;
SET autocommit=1;
CREATE TABLE testSavepoints (field1 int);
SET autocommit=0;
INSERT INTO testSavepoints VALUES (1);
SAVEPOINT `afterInsert`;
UPDATE testSavepoints SET field1=2;
SAVEPOINT `afterUpdate`;
DELETE FROM testSavepoints;
SELECT count(*) FROM testSavepoints;
count(*)
0
ROLLBACK TO SAVEPOINT afterUpdate;
SELECT count(*) FROM testSavepoints;
count(*)
1
DROP TABLE testSavepoints;
