diff options
Diffstat (limited to 'mysql-test/suite/perfschema/r/dml_setup_objects.result')
| -rw-r--r-- | mysql-test/suite/perfschema/r/dml_setup_objects.result | 67 |
1 files changed, 67 insertions, 0 deletions
diff --git a/mysql-test/suite/perfschema/r/dml_setup_objects.result b/mysql-test/suite/perfschema/r/dml_setup_objects.result new file mode 100644 index 00000000000..075114a9b5a --- /dev/null +++ b/mysql-test/suite/perfschema/r/dml_setup_objects.result @@ -0,0 +1,67 @@ +drop table if exists test.setup_objects; +create table test.setup_objects as +select * from performance_schema.setup_objects; +truncate table performance_schema.setup_objects; +select * from performance_schema.setup_objects; +OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME ENABLED TIMED +select * from performance_schema.setup_objects +order by object_type, object_schema, object_name; +OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME ENABLED TIMED +select * from performance_schema.setup_objects +where object_type = 'TABLE' + order by object_type, object_schema, object_name; +OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME ENABLED TIMED +select * from performance_schema.setup_objects +order by object_type, object_schema, object_name; +OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME ENABLED TIMED +insert into performance_schema.setup_objects +set object_type='ILLEGAL', object_schema='FOO', object_name='BAR', +enabled='YES', timed='YES'; +ERROR 23000: Cannot add or update a child row: a foreign key constraint fails () +insert into performance_schema.setup_objects +set object_type='TABLE', object_schema='FOO', object_name='BAR', +enabled='YES', timed='YES'; +insert into performance_schema.setup_objects +set object_type='TABLE', object_schema='FOO', object_name='BAR', +enabled='YES', timed='NO'; +ERROR 23000: Can't write; duplicate key in table 'setup_objects' +delete from performance_schema.setup_objects +where object_type='TABLE' and object_schema='FOO'; +select * from performance_schema.setup_objects +order by object_type, object_schema, object_name; +OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME ENABLED TIMED +insert into performance_schema.setup_objects +set object_type='TABLE', object_schema='FOO', object_name='BAR', +enabled='NO', timed='YES'; +select * from performance_schema.setup_objects +order by object_type, object_schema, object_name; +OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME ENABLED TIMED +TABLE FOO BAR NO YES +update performance_schema.setup_objects +set object_type='ILLEGAL'; +ERROR HY000: Invalid performance_schema usage. +update performance_schema.setup_objects +set object_schema='ILLEGAL'; +ERROR HY000: Invalid performance_schema usage. +update performance_schema.setup_objects +set object_name='ILLEGAL'; +ERROR HY000: Invalid performance_schema usage. +update performance_schema.setup_objects +set enabled='NO', timed='NO'; +select * from performance_schema.setup_objects +order by object_type, object_schema, object_name; +OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME ENABLED TIMED +TABLE FOO BAR NO NO +update performance_schema.setup_objects +set enabled='YES', timed='YES'; +delete from performance_schema.setup_objects +where object_type = 'TABLE'; +delete from performance_schema.setup_objects; +LOCK TABLES performance_schema.setup_objects READ; +UNLOCK TABLES; +LOCK TABLES performance_schema.setup_objects WRITE; +UNLOCK TABLES; +truncate table performance_schema.setup_objects; +insert into performance_schema.setup_objects +select * from test.setup_objects; +drop table test.setup_objects; |