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.