Debian Codegraph @

mysql-test/suite/sys_vars/t/pfs_digests_size_basic.test

raw
1 # Copyright (C) 2010 Sun Microsystems, Inc.
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 as published by
5 # the Free Software Foundation; version 2 of the License.
6 #
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.
11 #
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
14 # Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1335 USA
15
16 --source include/not_embedded.inc
17 --source include/have_perfschema.inc
18
19 #
20 # Only global
21 #
22
23 select @@global.performance_schema_digests_size;
24
25 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
26 select @@session.performance_schema_digests_size;
27
28 show global variables like 'performance_schema_digests_size';
29
30 show session variables like 'performance_schema_digests_size';
31
32 select * from information_schema.global_variables
33 where variable_name='performance_schema_digests_size';
34
35 select * from information_schema.session_variables
36 where variable_name='performance_schema_digests_size';
37
38 #
39 # Read-only
40 #
41
42 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
43 set global performance_schema_digests_size=1;
44
45 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
46 set session performance_schema_digests_size=1;
47