Bug #28045 Falcon ROLLBACK does not work correctly
Submitted: 23 Apr 2007 21:04
Reporter: Hakan Küçükyılmaz Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Falcon storage engine Severity:S3 (Non-critical)
Version:6.0.0-alpha OS:Any
Assigned to: CPU Architecture:Any

[23 Apr 2007 21:04] Hakan Küçükyılmaz 
Description:
This test is extracted from JConnector test suite testSavepoint.

How to repeat:
SET autocommit=1;
DROP TABLE IF EXISTS testSavepoints;
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;
ROLLBACK TO SAVEPOINT afterUpdate;
select count(*) from testSavepoints; <-- should be 1, but returns 0
[23 Apr 2007 21:05] Hakan Küçükyılmaz 
Test case is falcon_bug_28045.test.