Debian Codegraph @

mysql-test/suite/perfschema/t/trigger_table_io.test

raw
1 # Tests for PERFORMANCE_SCHEMA table io
2 --source include/have_myisam.inc
3 --source include/force_myisam_default.inc
4 --source ../include/table_io_setup_helper.inc
5
6 let $engine_type= MyISAM;
7
8 --disable_warnings
9 drop table if exists test.t1;
10 drop table if exists test.t2;
11 --enable_warnings
12
13 eval create table test.t1 (a int, v int) engine = $engine_type;
14 eval create table test.t2 (b int, v int) engine = $engine_type;
15
16 create trigger t1_bi before insert on t1
17 for each row insert into test.t2 set b = new.a, v = 0;
18
19 create trigger t1_ai after insert on t1
20 for each row update test.t2 set v = 1 where b = new.a;
21
22 create trigger t1_bu before update on t1
23 for each row update test.t2 set v = 3 where b = old.a;
24
25 create trigger t1_au after update on t1
26 for each row update test.t2 set v = 4 where b = new.a;
27
28 create trigger t1_bd before delete on t1
29 for each row delete from test.t2 where b = old.a;
30
31 create trigger t1_ad after delete on t1
32 for each row insert into test.t2 set b = old.a, v = 99;
33
34 # Start recording events
35 update performance_schema.setup_consumers set enabled = 'YES';
36
37 # Code to test
38
39 insert into marker set a = 1;
40 insert into t1 set a = 1, v = 10;
41 insert into marker set a = 1;
42 insert into t1 set a = 2, v = 20;
43 insert into marker set a = 1;
44 select * from t1;
45 insert into marker set a = 1;
46 select * from t2;
47 insert into marker set a = 1;
48 update t1 set v = v + 100;
49 insert into marker set a = 1;
50 select * from t1;
51 insert into marker set a = 1;
52 select * from t2;
53 insert into marker set a = 1;
54 delete from t1 where a = 1;
55 insert into marker set a = 1;
56 select * from t1;
57 insert into marker set a = 1;
58 select * from t2;
59 insert into marker set a = 1;
60 delete from t1 where a = 2;
61 insert into marker set a = 1;
62 select * from t1;
63 insert into marker set a = 1;
64 select * from t2;
65
66 # Stop recording events + pull results
67 --source ../include/table_io_result_helper.inc
68
69 # Cleanup
70 drop table test.t1;
71 drop table test.t2;
72 --source ../include/table_io_cleanup_helper.inc
73