Debian Codegraph @

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

raw
1 # Tests for PERFORMANCE_SCHEMA
2
3 --disable_warnings
4 drop table if exists test.setup_objects;
5 --enable_warnings
6 SET sql_mode = 'NO_ENGINE_SUBSTITUTION';
7 # Save the setup
8 create table test.setup_objects as
9 select * from performance_schema.setup_objects;
10 truncate table performance_schema.setup_objects;
11
12 # Test
13
14 select * from performance_schema.setup_objects;
15
16 select * from performance_schema.setup_objects
17 order by object_type, object_schema, object_name;
18
19 select * from performance_schema.setup_objects
20 where object_type = 'TABLE'
21 order by object_type, object_schema, object_name;
22
23 select * from performance_schema.setup_objects
24 order by object_type, object_schema, object_name;
25
26 --error ER_NO_REFERENCED_ROW_2
27 insert into performance_schema.setup_objects
28 set object_type='ILLEGAL', object_schema='foo', object_name='bar',
29 enabled='YES', timed='YES';
30
31 insert into performance_schema.setup_objects
32 set object_type='TABLE', object_schema='foo', object_name='bar',
33 enabled='YES', timed='YES';
34
35 --error ER_DUP_KEY
36 insert into performance_schema.setup_objects
37 set object_type='TABLE', object_schema='foo', object_name='bar',
38 enabled='YES', timed='NO';
39
40 delete from performance_schema.setup_objects
41 where object_type='TABLE' and object_schema='foo';
42
43 select * from performance_schema.setup_objects
44 order by object_type, object_schema, object_name;
45
46 insert into performance_schema.setup_objects
47 set object_type='TABLE', object_schema='foo', object_name='bar',
48 enabled='NO', timed='YES';
49
50 select * from performance_schema.setup_objects
51 order by object_type, object_schema, object_name;
52
53 --error ER_WRONG_PERFSCHEMA_USAGE
54 update performance_schema.setup_objects
55 set object_type='ILLEGAL';
56
57 --error ER_WRONG_PERFSCHEMA_USAGE
58 update performance_schema.setup_objects
59 set object_schema='ILLEGAL';
60
61 --error ER_WRONG_PERFSCHEMA_USAGE
62 update performance_schema.setup_objects
63 set object_name='ILLEGAL';
64
65 update performance_schema.setup_objects
66 set enabled='NO', timed='NO';
67
68 select * from performance_schema.setup_objects
69 order by object_type, object_schema, object_name;
70
71 update performance_schema.setup_objects
72 set enabled='YES', timed='YES';
73
74 delete from performance_schema.setup_objects
75 where object_type = 'TABLE';
76
77 delete from performance_schema.setup_objects;
78
79 LOCK TABLES performance_schema.setup_objects READ;
80 UNLOCK TABLES;
81
82 LOCK TABLES performance_schema.setup_objects WRITE;
83 UNLOCK TABLES;
84
85 # Restore the setup
86 truncate table performance_schema.setup_objects;
87 insert into performance_schema.setup_objects
88 select * from test.setup_objects;
89 drop table test.setup_objects;
90 SET sql_mode = default;