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;
105 #
106 # MDEV-25325 column_comment for performance_schema tables
107 #
108 select column_name, column_comment
109 from information_schema.columns
110 where table_schema='performance_schema' and table_name='setup_actors';
111 column_name column_comment
112 HOST Host name, either a literal, or the % wildcard representing any host.
113 USER User name, either a literal or the % wildcard representing any name.
114 ROLE Unused
115 ENABLED Whether to enable instrumentation for foreground threads matched by the row.
116 HISTORY Whether to log historical events for foreground threads matched by the row.