diff options
Diffstat (limited to 'mysql-test/suite/perfschema/r/setup_objects.result')
-rw-r--r-- | mysql-test/suite/perfschema/r/setup_objects.result | 16 |
1 files changed, 8 insertions, 8 deletions
diff --git a/mysql-test/suite/perfschema/r/setup_objects.result b/mysql-test/suite/perfschema/r/setup_objects.result index e623aeb8521..01744df940a 100644 --- a/mysql-test/suite/perfschema/r/setup_objects.result +++ b/mysql-test/suite/perfschema/r/setup_objects.result @@ -27,25 +27,25 @@ insert into performance_schema.setup_objects values ('TABLE', 'db4', '%', 'YES', 'NO'); insert into performance_schema.setup_objects values ('SOMETHING', 'bad1', 'bad1', 'YES', 'NO'); -ERROR 23000: Cannot add or update a child row: a foreign key constraint fails () +ERROR 23000: Cannot add or update a child row: a foreign key constraint fails show warnings; Level Code Message Warning 1265 Data truncated for column 'OBJECT_TYPE' at row 1 -Error 1452 Cannot add or update a child row: a foreign key constraint fails () +Error 1452 Cannot add or update a child row: a foreign key constraint fails insert into performance_schema.setup_objects values ('TABLE', 'bad2', 'bad2', 'MAYBE', 'NO'); -ERROR 23000: Cannot add or update a child row: a foreign key constraint fails () +ERROR 23000: Cannot add or update a child row: a foreign key constraint fails show warnings; Level Code Message Warning 1265 Data truncated for column 'ENABLED' at row 1 -Error 1452 Cannot add or update a child row: a foreign key constraint fails () +Error 1452 Cannot add or update a child row: a foreign key constraint fails insert into performance_schema.setup_objects values ('TABLE', 'bad3', 'bad3', 'YES', 'MAYBE NOT'); -ERROR 23000: Cannot add or update a child row: a foreign key constraint fails () +ERROR 23000: Cannot add or update a child row: a foreign key constraint fails show warnings; Level Code Message Warning 1265 Data truncated for column 'TIMED' at row 1 -Error 1452 Cannot add or update a child row: a foreign key constraint fails () +Error 1452 Cannot add or update a child row: a foreign key constraint fails select * from performance_schema.setup_objects order by OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME; OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME ENABLED TIMED @@ -64,10 +64,10 @@ set OBJECT_TYPE='SOMETHING' where OBJECT_SCHEMA='db1' and OBJECT_NAME='t1'; ERROR HY000: Invalid performance_schema usage. update performance_schema.setup_objects set ENABLED='MAYBE' where OBJECT_SCHEMA='db1' and OBJECT_NAME='t1'; -ERROR 23000: Cannot add or update a child row: a foreign key constraint fails () +ERROR 23000: Cannot add or update a child row: a foreign key constraint fails update performance_schema.setup_objects set TIMED='MAYBE NOT' where OBJECT_SCHEMA='db1' and OBJECT_NAME='t1'; -ERROR 23000: Cannot add or update a child row: a foreign key constraint fails () +ERROR 23000: Cannot add or update a child row: a foreign key constraint fails select * from performance_schema.setup_objects order by OBJECT_TYPE, OBJECT_SCHEMA, OBJECT_NAME; OBJECT_TYPE OBJECT_SCHEMA OBJECT_NAME ENABLED TIMED |