diff options
Diffstat (limited to 'mysql-test/suite/perfschema/r/dml_setup_actors.result')
-rw-r--r-- | mysql-test/suite/perfschema/r/dml_setup_actors.result | 60 |
1 files changed, 60 insertions, 0 deletions
diff --git a/mysql-test/suite/perfschema/r/dml_setup_actors.result b/mysql-test/suite/perfschema/r/dml_setup_actors.result new file mode 100644 index 00000000000..9ff49d8b7e2 --- /dev/null +++ b/mysql-test/suite/perfschema/r/dml_setup_actors.result @@ -0,0 +1,60 @@ +drop table if exists test.setup_actors; +create table test.setup_actors as +select * from performance_schema.setup_actors; +truncate table performance_schema.setup_actors; +select * from performance_schema.setup_actors; +HOST USER ROLE +select * from performance_schema.setup_actors +where user = '%'; +HOST USER ROLE +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='%'; +select * from performance_schema.setup_actors +order by USER, HOST; +HOST USER ROLE +% % % +server1 % % +% Joe % +localhost Joe % +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. +select * from performance_schema.setup_actors +order by USER, HOST; +HOST USER ROLE +% % % +server1 % % +% Joe % +localhost Joe % +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 +% % % +server1 % % +% Joe % +delete from performance_schema.setup_actors; +select * from performance_schema.setup_actors +order by USER, HOST; +HOST USER ROLE +LOCK TABLES performance_schema.setup_actors READ; +UNLOCK TABLES; +LOCK TABLES performance_schema.setup_actors WRITE; +UNLOCK TABLES; +truncate table performance_schema.setup_actors; +insert into performance_schema.setup_actors +select * from test.setup_actors; +drop table test.setup_actors; |