41 lines
1.4 KiB
Plaintext
41 lines
1.4 KiB
Plaintext
# This line and the line below is a temporary line for tests that do not need MyISAM in future, but need to be kept for tests that need it.
|
|
--source include/have_myisam.inc
|
|
|
|
# Tests for PERFORMANCE_SCHEMA
|
|
|
|
#--disable_result_log
|
|
select * from performance_schema.prepared_statements_instances
|
|
where owner_object_name like 'XXYYZZ%' limit 1;
|
|
|
|
select * from performance_schema.prepared_statements_instances
|
|
where owner_object_name='XXYYZZ';
|
|
#--enable_result_log
|
|
|
|
--error ER_TABLEACCESS_DENIED_ERROR
|
|
insert into performance_schema.prepared_statements_instances
|
|
set owner_object_name='XXYYZZ', count_execute=1, sum_timer_execute=2,
|
|
min_timer_execute=3, avg_timer_execute=4, max_timer_execute=5;
|
|
|
|
--error ER_TABLEACCESS_DENIED_ERROR
|
|
update performance_schema.prepared_statements_instances set count_execute=12;
|
|
|
|
--error ER_TABLEACCESS_DENIED_ERROR
|
|
update performance_schema.prepared_statements_instances
|
|
set count_execute=12 where owner_object_name like "XXYYZZ";
|
|
|
|
--error ER_TABLEACCESS_DENIED_ERROR
|
|
delete from performance_schema.prepared_statements_instances
|
|
where count_execute=1;
|
|
|
|
--error ER_TABLEACCESS_DENIED_ERROR
|
|
delete from performance_schema.prepared_statements_instances;
|
|
|
|
-- error ER_TABLEACCESS_DENIED_ERROR
|
|
LOCK TABLES performance_schema.prepared_statements_instances READ;
|
|
UNLOCK TABLES;
|
|
|
|
-- error ER_TABLEACCESS_DENIED_ERROR
|
|
LOCK TABLES performance_schema.prepared_statements_instances WRITE;
|
|
UNLOCK TABLES;
|
|
|