Bug #27357 Falcon: rollback fails after delete
Submitted: 21 Mar 2007 19:58 Modified: 20 Apr 2007 14:56
Reporter: Peter Gulutzan Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Falcon storage engine Severity:S3 (Non-critical)
Version:5.2.4-falcon-alpha-debug OS:Linux (SUSE 10.0 / 64-bit)
Assigned to: Jim Starkey CPU Architecture:Any

[21 Mar 2007 19:58] Peter Gulutzan 
Description:
I create a Falcon table.
I insert two rows.
I commit.
I delete one row, using DELETE with a WHERE clause.
I rollback.
I select.
There's only one row -- the delete wasn't rolled back.

How to repeat:
mysql> set @@autocommit=0;
Query OK, 0 rows affected (0.00 sec)

mysql> create table t1 (s1 int) engine=falcon;
Query OK, 0 rows affected (0.01 sec)

mysql> insert into t1 values (1),(2);
Query OK, 2 rows affected (0.01 sec)
Records: 2  Duplicates: 0  Warnings: 0

mysql> commit;
Query OK, 0 rows affected (0.00 sec)

mysql> start transaction;
Query OK, 0 rows affected (0.00 sec)

mysql> delete from t1 where s1 = 2;
Query OK, 1 row affected (0.00 sec)

mysql> rollback;
Query OK, 0 rows affected (0.00 sec)

mysql> select * from t1;
+------+
| s1   |
+------+
|    1 |
+------+
1 row in set (0.00 sec)
[22 Mar 2007 11:48] MySQL Verification Team 
Thank you for the bug report. Verified as described on FC 6 32-bit.
[23 Mar 2007 16:15] Hakan Küçükyılmaz 
Added test case falcon_bug_27357.test, which passes now.
[23 Mar 2007 18:21] Peter Gulutzan 
Tested again with latest push
ChangeSet@1.2507, 2007-03-23 18:01:04+01:00

It still fails.
[23 Mar 2007 22:44] Hakan Küçükyılmaz 
I had a mistake in my test case. The table in question has to be without any index, then it fails.

Updated falcon_bug_27357.test to reflect the behaviour.

Best regards, Hakan
[14 Apr 2007 19:41] Hakan Küçükyılmaz 
Test(s) which will be run though they are marked as disabled:
  falcon_bug_27357     : Bug#27357 2007-03-23 hakank Currently failing

TEST                           RESULT         TIME (ms)
-------------------------------------------------------

falcon_bug_27357               [ pass ]            222
-------------------------------------------------------
Stopping All Servers
All 1 tests were successful.
The servers where restarted 1 times
Spent 0.222 seconds actually executing testcases
[14 Apr 2007 21:34] Bugs System 
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/24559

ChangeSet@1.2597, 2007-04-14 23:34:38+02:00, hakank@lu0011.wdf.sap.corp +1 -0
  Test for Bug#27357 works now.
[15 Apr 2007 20:59] Peter Gulutzan 
I confirm that the disappearance no longer occurs with the latest build.
[20 Apr 2007 14:56] MC Brown 
A note has been added to the 5.2.4 changelog.
[10 Jul 2007 19:08] MC Brown 
This bug report entry has been moved to the 6.0.0 Falcon changelog.