[MDEV-4523] Add the possibility to do an ALTER trigger DEFINER (and possibly other possibilities such as ENABLE/DISABLE) Created: 2013-05-14  Updated: 2020-10-19

Status: Open
Project: MariaDB Server
Component/s: None
Fix Version/s: None

Type: Task Priority: Minor
Reporter: Jean Weisbuch Assignee: Unassigned
Resolution: Unresolved Votes: 0
Labels: definer, trigger, upstream

Issue Links:
Relates
relates to MDEV-6733 Can't easily change DEFINER on existi... Open

 Description   

For now, if you want to modify the definer of a trigger or any other of its parameters, you have to drop and recreate the trigger and manually lock/unlock the table to do this seamlessly.
Another "possible solution" is to manually modify the .TRG file (which is definitely not recommanded).

The ability to do an ALTER on a trigger to modify the definer, ENABLE/DISABLE the trigger, change its SQL mode and charset/collation would be interresting.

There has been some chat about ALTER trigger ENABLE/DISABLE for quite some time on MySQL : http://dev.mysql.com/worklog/task/?id=2825

ps: an ALTER VIEW DEFINER should also be implemented as the only alternative at the moment to do so is to modify manually the frm followed by a FLUSH TABLES which isnt a proper procedure.



 Comments   
Comment by Geoff Montee (Inactive) [ 2015-05-26 ]

MDEV-6733 appears to be similar.

https://mariadb.atlassian.net/browse/MDEV-6733

Generated at Thu Feb 08 06:57:05 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.