Debian Codegraph @

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

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