Debian Codegraph @

mysql-test/suite/perfschema/r/dml_setup_actors.result

raw
1 drop table if exists test.setup_actors;
2 create table test.setup_actors as
3 select * from performance_schema.setup_actors;
4 insert into performance_schema.setup_actors
5 values ('%','%','%','YES', 'YES');
6 ERROR 23000: Can't write; duplicate key in table 'setup_actors'
7 insert into performance_schema.setup_actors
8 values ('%','%','%','NO', 'NO');
9 ERROR 23000: Can't write; duplicate key in table 'setup_actors'
10 truncate table performance_schema.setup_actors;
11 select * from performance_schema.setup_actors;
12 HOST USER ROLE ENABLED HISTORY
13 select * from performance_schema.setup_actors
14 where user = '%';
15 HOST USER ROLE ENABLED HISTORY
16 insert into performance_schema.setup_actors
17 set user='Joe', host='localhost';
18 insert into performance_schema.setup_actors
19 set user='Joe', host='%';
20 insert into performance_schema.setup_actors
21 set user='%', host='server1';
22 insert into performance_schema.setup_actors
23 set user='%', host='%';
24 insert into performance_schema.setup_actors
25 values ('localhost', 'user1', '%', 'NO%', 'NO');
26 ERROR 01000: Data truncated for column 'ENABLED' at row 1
27 insert into performance_schema.setup_actors
28 values ('localhost', 'user1', '%', 'NO', 'KO');
29 ERROR 01000: Data truncated for column 'HISTORY' at row 1
30 select * from performance_schema.setup_actors
31 order by USER, HOST;
32 HOST USER ROLE ENABLED HISTORY
33 % % % YES YES
34 server1 % % YES YES
35 % Joe % YES YES
36 localhost Joe % YES YES
37 update performance_schema.setup_actors
38 set user='ILLEGAL';
39 ERROR HY000: Invalid performance_schema usage.
40 update performance_schema.setup_actors
41 set host='ILLEGAL';
42 ERROR HY000: Invalid performance_schema usage.
43 update performance_schema.setup_actors
44 set `role`='ILLEGAL';
45 ERROR HY000: Invalid performance_schema usage.
46 update performance_schema.setup_actors
47 set ENABLED='YES';
48 update performance_schema.setup_actors
49 set HISTORY='YES';
50 update performance_schema.setup_actors
51 set ENABLED='';
52 ERROR 01000: Data truncated for column 'ENABLED' at row 1
53 update performance_schema.setup_actors
54 set ENABLED='YESS';
55 ERROR 01000: Data truncated for column 'ENABLED' at row 1
56 update performance_schema.setup_actors
57 set ENABLED='NO%';
58 ERROR 01000: Data truncated for column 'ENABLED' at row 1
59 update performance_schema.setup_actors
60 set ENABLED=NULL;
61 ERROR 23000: Column 'ENABLED' cannot be null
62 update performance_schema.setup_actors
63 set HISTORY='YESS';
64 ERROR 01000: Data truncated for column 'HISTORY' at row 1
65 update performance_schema.setup_actors
66 set HISTORY='NO%';
67 ERROR 01000: Data truncated for column 'HISTORY' at row 1
68 update performance_schema.setup_actors
69 set HISTORY=NULL;
70 ERROR 23000: Column 'HISTORY' cannot be null
71 select * from performance_schema.setup_actors
72 order by USER, HOST;
73 HOST USER ROLE ENABLED HISTORY
74 % % % YES YES
75 server1 % % YES YES
76 % Joe % YES YES
77 localhost Joe % YES YES
78 delete from performance_schema.setup_actors
79 where user = 'Joe' and host = 'localhost';
80 select * from performance_schema.setup_actors
81 order by USER, HOST;
82 HOST USER ROLE ENABLED HISTORY
83 % % % YES YES
84 server1 % % YES YES
85 % Joe % YES YES
86 delete from performance_schema.setup_actors;
87 select * from performance_schema.setup_actors
88 order by USER, HOST;
89 HOST USER ROLE ENABLED HISTORY
90 LOCK TABLES performance_schema.setup_actors READ;
91 UNLOCK TABLES;
92 LOCK TABLES performance_schema.setup_actors WRITE;
93 UNLOCK TABLES;
94 #
95 # WL#2284: Increase the length of a user name
96 #
97 insert into performance_schema.setup_actors
98 set user='user_name_len_22_01234', host='localhost';
99 delete from performance_schema.setup_actors
100 where user = 'user_name_len_22_01234' and host = 'localhost';
101 truncate table performance_schema.setup_actors;
102 insert into performance_schema.setup_actors
103 select * from test.setup_actors;
104 drop table test.setup_actors;