1
# Copyright (c) 2009, 2010, Oracle and/or its affiliates. All rights reserved.
3
# This program is free software; you can redistribute it and/or modify
4
# it under the terms of the GNU General Public License as published by
5
# the Free Software Foundation; version 2 of the License.
7
# This program is distributed in the hope that it will be useful,
8
# but WITHOUT ANY WARRANTY; without even the implied warranty of
9
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
10
# GNU General Public License for more details.
12
# You should have received a copy of the GNU General Public License
13
# along with this program; if not, write to the Free Software Foundation,
14
# 51 Franklin Street, Suite 500, Boston, MA 02110-1335 USA
16
# Tests for PERFORMANCE_SCHEMA
18
--source include/not_embedded.inc
19
--source include/have_perfschema.inc
22
select * from performance_schema.events_statements_summary_by_digest
23
where digest like 'XXYYZZ%' limit 1;
25
select * from performance_schema.events_statements_summary_by_digest
26
where digest='XXYYZZ';
29
--error ER_TABLEACCESS_DENIED_ERROR
30
insert into performance_schema.events_statements_summary_by_digest
31
set digest='XXYYZZ', count_star=1, sum_timer_wait=2, min_timer_wait=3,
32
avg_timer_wait=4, max_timer_wait=5;
34
--error ER_TABLEACCESS_DENIED_ERROR
35
update performance_schema.events_statements_summary_by_digest
38
--error ER_TABLEACCESS_DENIED_ERROR
39
update performance_schema.events_statements_summary_by_digest
40
set count_star=12 where digest like "XXYYZZ";
42
--error ER_TABLEACCESS_DENIED_ERROR
43
delete from performance_schema.events_statements_summary_by_digest
46
--error ER_TABLEACCESS_DENIED_ERROR
47
delete from performance_schema.events_statements_summary_by_digest;
49
-- error ER_TABLEACCESS_DENIED_ERROR
50
LOCK TABLES performance_schema.events_statements_summary_by_digest READ;
53
-- error ER_TABLEACCESS_DENIED_ERROR
54
LOCK TABLES performance_schema.events_statements_summary_by_digest WRITE;