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