MySQL InnoDB Transactions
Original Reporter info from Mantis: NelsonN
-
Reporter name: NelsonN
Original Reporter info from Mantis: NelsonN
- Reporter name: NelsonN
Description:
I seem to be able to work with commit and rollback transactions with SQLite and Firebird 2.5 with the following:
DataModule1.SQLTransaction1.StartTransaction;
DataModule1.SQLTransaction1.Rollback;
DataModule1.SQLTransaction1.Commit;
DataModule1.SQLTransaction1.EndTransaction;
But not with MySQL's InnoDB tables. Only with:
DataModule1.SQLQuery1.SQL.Text := 'Start Transaction';
DataModule1.SQLQuery1.ExecSQL;
DataModule1.SQLQuery1.SQL.Text := 'RollBack';
DataModule1.SQLQuery1.ExecSQL;
DataModule1.SQLQuery1.SQL.Text := 'Commit';
DataModule1.SQLQuery1.ExecSQL;
I am using MySQL Server version: 5.1.41.
According to moderator, marcov, over at the Free Pascal/Lazarus forum:
http://forum.lazarus.freepascal.org/index.php/topic,12750.msg65937.html
"Seems to be correct, the overrides are empty. This could be because older versions of mysql didn't support transactions.
Please file a bug so it is not forgotten."
Mantis conversion info:
- Mantis ID: 19137
- Fixed in version: 2.6.4
- Fixed in revision: 23906 (#0ad5811b)
- Monitored by: » NelsonN (NelsonN)
- Target version: 2.6.1