Bug #56176 Commit/Rollback triggers (like Firebird)
Submitted: 23 Aug 2010 0:04 Modified: 24 Aug 2010 23:22
Reporter: D AZ Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server: DDL Severity:S4 (Feature request)
Version: OS:Any
Assigned to: CPU Architecture:Any

[23 Aug 2010 0:04] D AZ 
Description:
Firebird has a number of database level triggers, including commit and rollback triggers.

This is quite important for the transactional database engines, especially when trying to interact with external components via UDF's etc in a multi-user environment.

I've create a post here, but haven't received any replies as yet:
  http://forums.mysql.com/read.php?20,377803

How to repeat:
Can't repeat - Feature Request
[24 Aug 2010 9:30] Valeriy Kravchuk 
Thank you for the feature request.
[24 Aug 2010 9:35] Valeriy Kravchuk 
Actually, I'd say it is just a subset of the request for Oracle-like system level triggers, Bug #17632.
[24 Aug 2010 23:22] D AZ 
Ah, excellent.  So given that this feature was first requested in 2006, is there any existing plan to implement it?  If not, I'd be happy to help if I can (just point me to some code to get started).  Or, in the absence of such a feature, is there any other way to detect when something is committed?