Debian Codegraph @

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

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