1SET @start_global_value = @@global.max_write_lock_count; 2SELECT @start_global_value; 3@start_global_value 418446744073709551615 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 1018446744073709551615 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 150 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; 45SELECT @@global.max_write_lock_count; 46@@global.max_write_lock_count 474294967296 48SET @@global.max_write_lock_count = -1; 49Warnings: 50Warning 1292 Truncated incorrect max_write_lock_count value: '-1' 51SELECT @@global.max_write_lock_count; 52@@global.max_write_lock_count 531 54SET @@global.max_write_lock_count = 429496729500; 55SELECT @@global.max_write_lock_count; 56@@global.max_write_lock_count 57429496729500 58SET @@global.max_write_lock_count = 65530.34; 59ERROR 42000: Incorrect argument type to variable 'max_write_lock_count' 60SELECT @@global.max_write_lock_count; 61@@global.max_write_lock_count 62429496729500 63SET @@global.max_write_lock_count = test; 64ERROR 42000: Incorrect argument type to variable 'max_write_lock_count' 65SELECT @@global.max_write_lock_count; 66@@global.max_write_lock_count 67429496729500 68'#------------------FN_DYNVARS_088_05-----------------------#' 69SELECT @@global.max_write_lock_count = VARIABLE_VALUE 70FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 71WHERE VARIABLE_NAME='max_write_lock_count'; 72@@global.max_write_lock_count = VARIABLE_VALUE 731 74'#------------------FN_DYNVARS_088_06-----------------------#' 75SET @@global.max_write_lock_count = TRUE; 76SELECT @@global.max_write_lock_count; 77@@global.max_write_lock_count 781 79SET @@global.max_write_lock_count = FALSE; 80Warnings: 81Warning 1292 Truncated incorrect max_write_lock_count value: '0' 82SELECT @@global.max_write_lock_count; 83@@global.max_write_lock_count 841 85'#---------------------FN_DYNVARS_088_07----------------------#' 86SET @@global.max_write_lock_count = 20; 87SELECT @@max_write_lock_count = @@global.max_write_lock_count; 88@@max_write_lock_count = @@global.max_write_lock_count 891 90'#---------------------FN_DYNVARS_088_08----------------------#' 91SET @@global.max_write_lock_count = 102; 92SELECT @@max_write_lock_count; 93@@max_write_lock_count 94102 95SELECT local.max_write_lock_count; 96ERROR 42S02: Unknown table 'local' in field list 97SELECT global.max_write_lock_count; 98ERROR 42S02: Unknown table 'global' in field list 99SELECT max_write_lock_count = @@global.max_write_lock_count; 100ERROR 42S22: Unknown column 'max_write_lock_count' in 'field list' 101SET @@global.max_write_lock_count = @start_global_value; 102SELECT @@global.max_write_lock_count; 103@@global.max_write_lock_count 10418446744073709551615 105