diff options
Diffstat (limited to 'mysql-test/suite/perfschema/t/dml_setup_objects.test')
-rw-r--r-- | mysql-test/suite/perfschema/t/dml_setup_objects.test | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/mysql-test/suite/perfschema/t/dml_setup_objects.test b/mysql-test/suite/perfschema/t/dml_setup_objects.test index 29594bf32f9..3868da276a0 100644 --- a/mysql-test/suite/perfschema/t/dml_setup_objects.test +++ b/mysql-test/suite/perfschema/t/dml_setup_objects.test @@ -26,10 +26,12 @@ select * from performance_schema.setup_objects select * from performance_schema.setup_objects order by object_type, object_schema, object_name; +set sql_mode= ''; --error ER_NO_REFERENCED_ROW_2 insert into performance_schema.setup_objects set object_type='ILLEGAL', object_schema='FOO', object_name='BAR', enabled='YES', timed='YES'; +set sql_mode= DEFAULT; insert into performance_schema.setup_objects set object_type='TABLE', object_schema='FOO', object_name='BAR', @@ -53,9 +55,11 @@ insert into performance_schema.setup_objects select * from performance_schema.setup_objects order by object_type, object_schema, object_name; +set sql_mode= ''; --error ER_WRONG_PERFSCHEMA_USAGE update performance_schema.setup_objects set object_type='ILLEGAL'; +set sql_mode= DEFAULT; --error ER_WRONG_PERFSCHEMA_USAGE update performance_schema.setup_objects |