1SET @start_global_value = @@global.max_write_lock_count; 2SELECT @start_global_value; 3@start_global_value 44294967295 5'#--------------------FN_DYNVARS_088_01-------------------------#' 6SET @@global.max_write_lock_count = 1000; 7SET @@global.max_write_lock_count = DEFAULT; 8SELECT @@global.max_write_lock_count; 9@@global.max_write_lock_count 104294967295 11'#--------------------FN_DYNVARS_088_02-------------------------#' 12SET @@global.max_write_lock_count = DEFAULT; 13SELECT @@global.max_write_lock_count = 4294967295; 14@@global.max_write_lock_count = 4294967295 151 16'#--------------------FN_DYNVARS_088_03-------------------------#' 17SET @@global.max_write_lock_count = 1; 18SELECT @@global.max_write_lock_count; 19@@global.max_write_lock_count 201 21SET @@global.max_write_lock_count = 2; 22SELECT @@global.max_write_lock_count; 23@@global.max_write_lock_count 242 25SET @@global.max_write_lock_count = 65536; 26SELECT @@global.max_write_lock_count; 27@@global.max_write_lock_count 2865536 29SET @@global.max_write_lock_count = 4294967295; 30SELECT @@global.max_write_lock_count; 31@@global.max_write_lock_count 324294967295 33SET @@global.max_write_lock_count = 4294967294; 34SELECT @@global.max_write_lock_count; 35@@global.max_write_lock_count 364294967294 37'#------------------FN_DYNVARS_088_04-----------------------#' 38SET @@global.max_write_lock_count = -1024; 39Warnings: 40Warning 1292 Truncated incorrect max_write_lock_count value: '-1024' 41SELECT @@global.max_write_lock_count; 42@@global.max_write_lock_count 431 44SET @@global.max_write_lock_count = 4294967296; 45Warnings: 46Warning 1292 Truncated incorrect max_write_lock_count value: '4294967296' 47SELECT @@global.max_write_lock_count; 48@@global.max_write_lock_count 494294967295 50SET @@global.max_write_lock_count = -1; 51Warnings: 52Warning 1292 Truncated incorrect max_write_lock_count value: '-1' 53SELECT @@global.max_write_lock_count; 54@@global.max_write_lock_count 551 56SET @@global.max_write_lock_count = 429496729500; 57Warnings: 58Warning 1292 Truncated incorrect max_write_lock_count value: '429496729500' 59SELECT @@global.max_write_lock_count; 60@@global.max_write_lock_count 614294967295 62SET @@global.max_write_lock_count = 65530.34; 63ERROR 42000: Incorrect argument type to variable 'max_write_lock_count' 64SELECT @@global.max_write_lock_count; 65@@global.max_write_lock_count 664294967295 67SET @@global.max_write_lock_count = test; 68ERROR 42000: Incorrect argument type to variable 'max_write_lock_count' 69SELECT @@global.max_write_lock_count; 70@@global.max_write_lock_count 714294967295 72'#------------------FN_DYNVARS_088_05-----------------------#' 73SELECT @@global.max_write_lock_count = VARIABLE_VALUE 74FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 75WHERE VARIABLE_NAME='max_write_lock_count'; 76@@global.max_write_lock_count = VARIABLE_VALUE 771 78'#------------------FN_DYNVARS_088_06-----------------------#' 79SET @@global.max_write_lock_count = TRUE; 80SELECT @@global.max_write_lock_count; 81@@global.max_write_lock_count 821 83SET @@global.max_write_lock_count = FALSE; 84Warnings: 85Warning 1292 Truncated incorrect max_write_lock_count value: '0' 86SELECT @@global.max_write_lock_count; 87@@global.max_write_lock_count 881 89'#---------------------FN_DYNVARS_088_07----------------------#' 90SET @@global.max_write_lock_count = 20; 91SELECT @@max_write_lock_count = @@global.max_write_lock_count; 92@@max_write_lock_count = @@global.max_write_lock_count 931 94'#---------------------FN_DYNVARS_088_08----------------------#' 95SET @@global.max_write_lock_count = 102; 96SELECT @@max_write_lock_count; 97@@max_write_lock_count 98102 99SELECT local.max_write_lock_count; 100ERROR 42S02: Unknown table 'local' in field list 101SELECT global.max_write_lock_count; 102ERROR 42S02: Unknown table 'global' in field list 103SELECT max_write_lock_count = @@global.max_write_lock_count; 104ERROR 42S22: Unknown column 'max_write_lock_count' in 'field list' 105SET @@global.max_write_lock_count = @start_global_value; 106SELECT @@global.max_write_lock_count; 107@@global.max_write_lock_count 1084294967295 109