[MDEV-10915] Multiple triggers are not counted in Executed_triggers status variable Created: 2016-09-28  Updated: 2016-09-29  Resolved: 2016-09-29

Status: Closed
Project: MariaDB Server
Component/s: Triggers
Affects Version/s: N/A
Fix Version/s: 10.2.3

Type: Bug Priority: Major
Reporter: Elena Stepanova Assignee: Michael Widenius
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Relates
relates to MDEV-6112 multiple triggers per table Closed

 Description   

All multiple triggers count as one in Executed_triggers.

create table t1 (i int);
 
create trigger tr1 after insert on t1 for each row set @a=@a+1;
create trigger tr2 after insert on t1 for each row set @a=@a+1;
create trigger tr3 after insert on t1 for each row set @a=@a+1;
 
flush status;
show status like 'Executed_triggers';
set @a=0;
insert into t1 values (1);
show status like 'Executed_triggers';
select @a;
 
drop table t1;

MariaDB [test]> show status like 'Executed_triggers';
+-------------------+-------+
| Variable_name     | Value |
+-------------------+-------+
| Executed_triggers | 1     |
+-------------------+-------+
1 row in set (0.00 sec)
 
MariaDB [test]> select @a;
+------+
| @a   |
+------+
|    3 |
+------+
1 row in set (0.00 sec)



 Comments   
Comment by Michael Widenius [ 2016-09-29 ]

Fixed in development tree and test case added to trigger.test

Generated at Thu Feb 08 07:45:54 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.