Debian Codegraph @

mysql-test/suite/perfschema/t/ddl_esms_by_digest.test

raw
1 # Copyright (c) 2008, 2010, Oracle and/or its affiliates. All rights reserved.
2 #
3 # This program is free software; you can redistribute it and/or modify
4 # it under the terms of the GNU General Public License, version 2.0,
5 # as published by the Free Software Foundation.
6 #
7 # This program is also distributed with certain software (including
8 # but not limited to OpenSSL) that is licensed under separate terms,
9 # as designated in a particular file or component or in included license
10 # documentation. The authors of MySQL hereby grant you an additional
11 # permission to link the program and your derivative works with the
12 # separately licensed software that they have included with MySQL.
13 #
14 # This program is distributed in the hope that it will be useful,
15 # but WITHOUT ANY WARRANTY; without even the implied warranty of
16 # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
17 # GNU General Public License, version 2.0, for more details.
18 #
19 # You should have received a copy of the GNU General Public License
20 # along with this program; if not, write to the Free Software Foundation,
21 # 51 Franklin Street, Fifth Floor, Boston, MA 02110-1335 USA
22
23 # Tests for PERFORMANCE_SCHEMA
24
25 --source include/not_embedded.inc
26 --source include/have_perfschema.inc
27
28 -- error ER_DBACCESS_DENIED_ERROR
29 alter table performance_schema.events_statements_summary_by_digest
30 add column foo integer;
31
32 truncate table performance_schema.events_statements_summary_by_digest;
33
34 -- error ER_DBACCESS_DENIED_ERROR
35 ALTER TABLE performance_schema.events_statements_summary_by_digest ADD INDEX test_index(DIGEST);
36
37 -- error ER_DBACCESS_DENIED_ERROR
38 CREATE UNIQUE INDEX test_index
39 ON performance_schema.events_statements_summary_by_digest(DIGEST);
40