1####################################################################
2#   Displaying default value                                       #
3####################################################################
4SELECT @@GLOBAL.metadata_locks_hash_instances;
5@@GLOBAL.metadata_locks_hash_instances
68
7Warnings:
8Warning	1287	'@@metadata_locks_hash_instances' is deprecated and will be removed in a future release.
9####################################################################
10# Check that value cannot be set (this variable is settable only   #
11# at start-up).                                                    #
12####################################################################
13SET @@GLOBAL.metadata_locks_hash_instances=1;
14ERROR HY000: Variable 'metadata_locks_hash_instances' is a read only variable
15SELECT @@GLOBAL.metadata_locks_hash_instances;
16@@GLOBAL.metadata_locks_hash_instances
178
18Warnings:
19Warning	1287	'@@metadata_locks_hash_instances' is deprecated and will be removed in a future release.
20#################################################################
21# Check if the value in GLOBAL Table matches value in variable  #
22#################################################################
23SELECT VARIABLE_VALUE
24FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
25WHERE VARIABLE_NAME='metadata_locks_hash_instances'
26into @tmp;
27SELECT @@GLOBAL.metadata_locks_hash_instances = @tmp;
28@@GLOBAL.metadata_locks_hash_instances = @tmp
291
30Warnings:
31Warning	1287	'@@metadata_locks_hash_instances' is deprecated and will be removed in a future release.
32SELECT @@GLOBAL.metadata_locks_hash_instances;
33@@GLOBAL.metadata_locks_hash_instances
348
35Warnings:
36Warning	1287	'@@metadata_locks_hash_instances' is deprecated and will be removed in a future release.
37SELECT VARIABLE_VALUE
38FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
39WHERE VARIABLE_NAME='metadata_locks_hash_instances';
40VARIABLE_VALUE
418
42######################################################################
43#  Check if accessing variable with and without GLOBAL point to same #
44#  variable                                                          #
45######################################################################
46SELECT @@metadata_locks_hash_instances = @@GLOBAL.metadata_locks_hash_instances;
47@@metadata_locks_hash_instances = @@GLOBAL.metadata_locks_hash_instances
481
49Warnings:
50Warning	1287	'@@metadata_locks_hash_instances' is deprecated and will be removed in a future release.
51Warning	1287	'@@metadata_locks_hash_instances' is deprecated and will be removed in a future release.
52######################################################################
53#  Check if variable has only the GLOBAL scope                       #
54######################################################################
55SELECT @@metadata_locks_hash_instances;
56@@metadata_locks_hash_instances
578
58Warnings:
59Warning	1287	'@@metadata_locks_hash_instances' is deprecated and will be removed in a future release.
60SELECT @@GLOBAL.metadata_locks_hash_instances;
61@@GLOBAL.metadata_locks_hash_instances
628
63Warnings:
64Warning	1287	'@@metadata_locks_hash_instances' is deprecated and will be removed in a future release.
65SELECT @@local.metadata_locks_hash_instances;
66ERROR HY000: Variable 'metadata_locks_hash_instances' is a GLOBAL variable
67SELECT @@SESSION.metadata_locks_hash_instances;
68ERROR HY000: Variable 'metadata_locks_hash_instances' is a GLOBAL variable
69