Bug #16525 INSTEAD OF triggers
| Submitted: | 15 Jan 2006 23:37 | Modified: | 16 Jan 2006 12:13 |
|---|---|---|---|
| Reporter: | Markus Popp | Email Updates: | |
| Status: | Verified | Impact on me: | |
| Category: | MySQL Server: Stored Routines | Severity: | S4 (Feature request) |
| Version: | 5.X | OS: | Any (all) |
| Assigned to: | CPU Architecture: | Any |
[15 Jan 2006 23:37]
Markus Popp
[16 Jan 2006 12:13]
MySQL Verification Team
Thank you for the feature request's bug report.
[14 Sep 2006 10:58]
Valeriy Kravchuk
Bug #19990 was marked as a duplicate of this one.
[24 Oct 2008 17:57]
MySQL Verification Team
Bug: http://bugs.mysql.com/bug.php?id=39466 was marked as duplicate of this one.
[25 Oct 2008 17:30]
Valeriy Kravchuk
Bug #40012 was marked as a duplicate of this one.
[4 Feb 2009 2:44]
Jim Manico
I to have run up against this limitation. It would be a great addition.
[14 Jul 2011 8:34]
Meenakshi SUndara Santhosh
Consider this one as high priority. We are changing from MSSql to Mysql. We uses this feature very much. Regards VMSSanthosh
[26 Dec 2012 20:59]
Shane Bester
http://bugs.mysql.com/bug.php?id=67977 is a duplicate of this
[20 Nov 2015 7:32]
Daniël van Eeden
With the Rewriter plugin (and possibly other rewrite plugins) this is sort-of possible. One major limitation in the Rewriter plugin is that it is limited to SELECT. https://dev.mysql.com/doc/refman/5.7/en/rewriter-query-rewrite-plugin.html This feature should be combined with: Bug #72395 ON SELECT trigger This is useful for situations with partitioning where the partitions are not equal (e.g. old partitions have less indexes or slightly different column definitions).
Portions of this website are copyright © 2001, 2002 The PHP Group
Page generated in 0.061 sec. using MySQL 8.4.7-u6-cloud
Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the
respective copyright holders.
It is not reviewed in advance
by Oracle and does not necessarily represent the opinion of
Oracle or any other party.