Debian Codegraph @

mysql-test/suite/perfschema/t/dml_setup_actors.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_actors;
8 --enable_warnings
9
10 # Save the setup
11 create table test.setup_actors as
12 select * from performance_schema.setup_actors;
13
14 # Inserting Duplicate values in the table should
15 # throw error
16 --error ER_DUP_KEY
17 insert into performance_schema.setup_actors
18 values ('%','%','%','YES', 'YES');
19 --error ER_DUP_KEY
20 insert into performance_schema.setup_actors
21 values ('%','%','%','NO', 'NO');
22
23 truncate table performance_schema.setup_actors;
24
25 select * from performance_schema.setup_actors;
26
27 select * from performance_schema.setup_actors
28 where user = '%';
29
30 insert into performance_schema.setup_actors
31 set user='Joe', host='localhost';
32
33 insert into performance_schema.setup_actors
34 set user='Joe', host='%';
35
36 insert into performance_schema.setup_actors
37 set user='%', host='server1';
38
39 insert into performance_schema.setup_actors
40 set user='%', host='%';
41
42 # Insert with wrong value for ENABLED column
43 --error 1265
44 insert into performance_schema.setup_actors
45 values ('localhost', 'user1', '%', 'NO%', 'NO');
46
47 # Insert with wrong value for HISTORY column
48 --error 1265
49 insert into performance_schema.setup_actors
50 values ('localhost', 'user1', '%', 'NO', 'KO');
51
52 select * from performance_schema.setup_actors
53 order by USER, HOST;
54
55 --error ER_WRONG_PERFSCHEMA_USAGE
56 update performance_schema.setup_actors
57 set user='ILLEGAL';
58
59 --error ER_WRONG_PERFSCHEMA_USAGE
60 update performance_schema.setup_actors
61 set host='ILLEGAL';
62
63 --error ER_WRONG_PERFSCHEMA_USAGE
64 update performance_schema.setup_actors
65 set role='ILLEGAL';
66
67 # update on ENABLED column is allowed
68 update performance_schema.setup_actors
69 set ENABLED='YES';
70
71 # update on HISTORY column is allowed
72 update performance_schema.setup_actors
73 set HISTORY='YES';
74
75 # update on ENABLED column with wrong values
76 #throws error
77 --error 1265
78 update performance_schema.setup_actors
79 set ENABLED='';
80
81 --error 1265
82 update performance_schema.setup_actors
83 set ENABLED='YESS';
84
85 --error 1265
86 update performance_schema.setup_actors
87 set ENABLED='NO%';
88
89 --error ER_BAD_NULL_ERROR
90 update performance_schema.setup_actors
91 set ENABLED=NULL;
92
93 --error 1265
94 update performance_schema.setup_actors
95 set HISTORY='YESS';
96
97 --error 1265
98 update performance_schema.setup_actors
99 set HISTORY='NO%';
100
101 --error ER_BAD_NULL_ERROR
102 update performance_schema.setup_actors
103 set HISTORY=NULL;
104
105 select * from performance_schema.setup_actors
106 order by USER, HOST;
107
108 delete from performance_schema.setup_actors
109 where user = 'Joe' and host = 'localhost';
110
111 select * from performance_schema.setup_actors
112 order by USER, HOST;
113
114 delete from performance_schema.setup_actors;
115
116 select * from performance_schema.setup_actors
117 order by USER, HOST;
118
119 LOCK TABLES performance_schema.setup_actors READ;
120 UNLOCK TABLES;
121
122 LOCK TABLES performance_schema.setup_actors WRITE;
123 UNLOCK TABLES;
124
125 --echo #
126 --echo # WL#2284: Increase the length of a user name
127 --echo #
128
129 insert into performance_schema.setup_actors
130 set user='user_name_len_22_01234', host='localhost';
131
132 delete from performance_schema.setup_actors
133 where user = 'user_name_len_22_01234' and host = 'localhost';
134
135
136 # Restore the setup
137 truncate table performance_schema.setup_actors;
138 insert into performance_schema.setup_actors
139 select * from test.setup_actors;
140 drop table test.setup_actors;
141
142 --echo #
143 --echo # MDEV-25325 column_comment for performance_schema tables
144 --echo #
145 select column_name, column_comment
146 from information_schema.columns
147 where table_schema='performance_schema' and table_name='setup_actors';