Debian Codegraph @

mysql-test/suite/sys_vars/t/max_digest_length_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
18 #
19 # Only global
20 #
21
22 select @@global.max_digest_length;
23
24 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
25 select @@session.max_digest_length;
26
27 show global variables like 'max_digest_length';
28
29 show session variables like 'max_digest_length';
30
31 select * from information_schema.global_variables
32 where variable_name='max_digest_length';
33
34 select * from information_schema.session_variables
35 where variable_name='max_digest_length';
36
37 #
38 # Read-only
39 #
40
41 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
42 set global max_digest_length=1;
43
44 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
45 set session max_digest_length=1;
46