MySQL Bugs: #72395: ON SELECT trigger

Bug #72395	ON SELECT trigger
Submitted:	20 Apr 2014 8:40	Modified:	21 Apr 2014 18:08
Reporter:	Jassim Rahma	Email Updates:
Status:	Verified	Impact on me:	None
Category:	MySQL Server: Stored Routines	Severity:	S4 (Feature request)
Version:		OS:	Any
Assigned to:		CPU Architecture:	Any

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
I suggest the following improvement:

Please add an option for an ON SELECT trigger

How to repeat:
this is a suggestion

Thank you for the reasonable feature request.

Probably a duplicate of:
Bug #21553 	RFE: CREATE TRIGGER ... SELECT ON ...

Note that in MySQL 5.7 with the Rewriter plugin similar functionality is available. I don't think the Rewriter plugin allows multiple statements, but it could call a stored procedure which does that. It might be hard to get the Rewriter plugin to intercept all SELECT queries on a table. So this might solve the issue for some cases, but not for all cases so this RFE is still needed.

Together with this RFE it might make more sense:
Bug #16525 	INSTEAD OF triggers