Debian Codegraph @

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

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