mirror of
https://github.com/MariaDB/server.git
synced 2025-02-12 00:15:35 +01:00
8fe927e6de
Cover all columns that did not have comments. Adjust docs based off of MariaDB implementation.
116 lines
4.2 KiB
Text
116 lines
4.2 KiB
Text
drop table if exists test.setup_actors;
|
|
create table test.setup_actors as
|
|
select * from performance_schema.setup_actors;
|
|
insert into performance_schema.setup_actors
|
|
values ('%','%','%','YES', 'YES');
|
|
ERROR 23000: Can't write; duplicate key in table 'setup_actors'
|
|
insert into performance_schema.setup_actors
|
|
values ('%','%','%','NO', 'NO');
|
|
ERROR 23000: Can't write; duplicate key in table 'setup_actors'
|
|
truncate table performance_schema.setup_actors;
|
|
select * from performance_schema.setup_actors;
|
|
HOST USER ROLE ENABLED HISTORY
|
|
select * from performance_schema.setup_actors
|
|
where user = '%';
|
|
HOST USER ROLE ENABLED HISTORY
|
|
insert into performance_schema.setup_actors
|
|
set user='Joe', host='localhost';
|
|
insert into performance_schema.setup_actors
|
|
set user='Joe', host='%';
|
|
insert into performance_schema.setup_actors
|
|
set user='%', host='server1';
|
|
insert into performance_schema.setup_actors
|
|
set user='%', host='%';
|
|
insert into performance_schema.setup_actors
|
|
values ('localhost', 'user1', '%', 'NO%', 'NO');
|
|
ERROR 01000: Data truncated for column 'ENABLED' at row 1
|
|
insert into performance_schema.setup_actors
|
|
values ('localhost', 'user1', '%', 'NO', 'KO');
|
|
ERROR 01000: Data truncated for column 'HISTORY' at row 1
|
|
select * from performance_schema.setup_actors
|
|
order by USER, HOST;
|
|
HOST USER ROLE ENABLED HISTORY
|
|
% % % YES YES
|
|
server1 % % YES YES
|
|
% Joe % YES YES
|
|
localhost Joe % YES YES
|
|
update performance_schema.setup_actors
|
|
set user='ILLEGAL';
|
|
ERROR HY000: Invalid performance_schema usage
|
|
update performance_schema.setup_actors
|
|
set host='ILLEGAL';
|
|
ERROR HY000: Invalid performance_schema usage
|
|
update performance_schema.setup_actors
|
|
set role='ILLEGAL';
|
|
ERROR HY000: Invalid performance_schema usage
|
|
update performance_schema.setup_actors
|
|
set ENABLED='YES';
|
|
update performance_schema.setup_actors
|
|
set HISTORY='YES';
|
|
update performance_schema.setup_actors
|
|
set ENABLED='';
|
|
ERROR 01000: Data truncated for column 'ENABLED' at row 1
|
|
update performance_schema.setup_actors
|
|
set ENABLED='YESS';
|
|
ERROR 01000: Data truncated for column 'ENABLED' at row 1
|
|
update performance_schema.setup_actors
|
|
set ENABLED='NO%';
|
|
ERROR 01000: Data truncated for column 'ENABLED' at row 1
|
|
update performance_schema.setup_actors
|
|
set ENABLED=NULL;
|
|
ERROR 23000: Column 'ENABLED' cannot be null
|
|
update performance_schema.setup_actors
|
|
set HISTORY='YESS';
|
|
ERROR 01000: Data truncated for column 'HISTORY' at row 1
|
|
update performance_schema.setup_actors
|
|
set HISTORY='NO%';
|
|
ERROR 01000: Data truncated for column 'HISTORY' at row 1
|
|
update performance_schema.setup_actors
|
|
set HISTORY=NULL;
|
|
ERROR 23000: Column 'HISTORY' cannot be null
|
|
select * from performance_schema.setup_actors
|
|
order by USER, HOST;
|
|
HOST USER ROLE ENABLED HISTORY
|
|
% % % YES YES
|
|
server1 % % YES YES
|
|
% Joe % YES YES
|
|
localhost Joe % YES YES
|
|
delete from performance_schema.setup_actors
|
|
where user = 'Joe' and host = 'localhost';
|
|
select * from performance_schema.setup_actors
|
|
order by USER, HOST;
|
|
HOST USER ROLE ENABLED HISTORY
|
|
% % % YES YES
|
|
server1 % % YES YES
|
|
% Joe % YES YES
|
|
delete from performance_schema.setup_actors;
|
|
select * from performance_schema.setup_actors
|
|
order by USER, HOST;
|
|
HOST USER ROLE ENABLED HISTORY
|
|
LOCK TABLES performance_schema.setup_actors READ;
|
|
UNLOCK TABLES;
|
|
LOCK TABLES performance_schema.setup_actors WRITE;
|
|
UNLOCK TABLES;
|
|
#
|
|
# WL#2284: Increase the length of a user name
|
|
#
|
|
insert into performance_schema.setup_actors
|
|
set user='user_name_len_22_01234', host='localhost';
|
|
delete from performance_schema.setup_actors
|
|
where user = 'user_name_len_22_01234' and host = 'localhost';
|
|
truncate table performance_schema.setup_actors;
|
|
insert into performance_schema.setup_actors
|
|
select * from test.setup_actors;
|
|
drop table test.setup_actors;
|
|
#
|
|
# MDEV-25325 column_comment for performance_schema tables
|
|
#
|
|
select column_name, column_comment
|
|
from information_schema.columns
|
|
where table_schema='performance_schema' and table_name='setup_actors';
|
|
column_name column_comment
|
|
HOST Host name, either a literal, or the % wildcard representing any host.
|
|
USER User name, either a literal or the % wildcard representing any name.
|
|
ROLE Unused
|
|
ENABLED Whether to enable instrumentation for foreground threads matched by the row.
|
|
HISTORY Whether to log historical events for foreground threads matched by the row.
|