1SET @start_global_value = @@global.max_delayed_threads; 2SELECT @start_global_value; 3@start_global_value 420 5SET @start_session_value = @@session.max_delayed_threads; 6SELECT @start_session_value; 7@start_session_value 820 9'#--------------------FN_DYNVARS_075_01-------------------------#' 10SET @@global.max_delayed_threads = 1000; 11SET @@global.max_delayed_threads = DEFAULT; 12SELECT @@global.max_delayed_threads; 13@@global.max_delayed_threads 1420 15SET @@session.max_delayed_threads = 1000; 16ERROR 42000: Variable 'max_delayed_threads' can't be set to the value of '1000' 17SET @@session.max_delayed_threads = DEFAULT; 18SELECT @@session.max_delayed_threads; 19@@session.max_delayed_threads 2020 21'#--------------------FN_DYNVARS_075_02-------------------------#' 22SET @@global.max_delayed_threads = DEFAULT; 23SELECT @@global.max_delayed_threads = 20; 24@@global.max_delayed_threads = 20 251 26SET @@session.max_delayed_threads = DEFAULT; 27SELECT @@session.max_delayed_threads = 20; 28@@session.max_delayed_threads = 20 291 30'#--------------------FN_DYNVARS_075_03-------------------------#' 31SET @@global.max_delayed_threads = 1; 32SELECT @@global.max_delayed_threads; 33@@global.max_delayed_threads 341 35SET @@global.max_delayed_threads = 1025; 36SELECT @@global.max_delayed_threads; 37@@global.max_delayed_threads 381025 39SET @@global.max_delayed_threads = 0; 40SELECT @@global.max_delayed_threads; 41@@global.max_delayed_threads 420 43SET @@global.max_delayed_threads = 16384; 44SELECT @@global.max_delayed_threads; 45@@global.max_delayed_threads 4616384 47SET @@global.max_delayed_threads = 16383; 48SELECT @@global.max_delayed_threads; 49@@global.max_delayed_threads 5016383 51'#--------------------FN_DYNVARS_075_04-------------------------#' 52SET @@session.max_delayed_threads = 1; 53ERROR 42000: Variable 'max_delayed_threads' can't be set to the value of '1' 54SELECT @@session.max_delayed_threads; 55@@session.max_delayed_threads 5620 57SET @@session.max_delayed_threads = 1025; 58ERROR 42000: Variable 'max_delayed_threads' can't be set to the value of '1025' 59SELECT @@session.max_delayed_threads; 60@@session.max_delayed_threads 6120 62SET @@session.max_delayed_threads = 0; 63SELECT @@session.max_delayed_threads; 64@@session.max_delayed_threads 650 66SET @@session.max_delayed_threads = 16384; 67ERROR 42000: Variable 'max_delayed_threads' can't be set to the value of '16384' 68SELECT @@session.max_delayed_threads; 69@@session.max_delayed_threads 700 71SET @@session.max_delayed_threads = 16383; 72SELECT @@session.max_delayed_threads; 73@@session.max_delayed_threads 7416383 75'#------------------FN_DYNVARS_075_05-----------------------#' 76SET @@global.max_delayed_threads = -1024; 77Warnings: 78Warning 1292 Truncated incorrect max_delayed_threads value: '-1024' 79SELECT @@global.max_delayed_threads; 80@@global.max_delayed_threads 810 82SET @@global.max_delayed_threads = -1; 83Warnings: 84Warning 1292 Truncated incorrect max_delayed_threads value: '-1' 85SELECT @@global.max_delayed_threads; 86@@global.max_delayed_threads 870 88SET @@global.max_delayed_threads = 16385; 89Warnings: 90Warning 1292 Truncated incorrect max_delayed_threads value: '16385' 91SELECT @@global.max_delayed_threads; 92@@global.max_delayed_threads 9316384 94SET @@global.max_delayed_threads = 65530.34; 95ERROR 42000: Incorrect argument type to variable 'max_delayed_threads' 96SELECT @@global.max_delayed_threads; 97@@global.max_delayed_threads 9816384 99SET @@global.max_delayed_threads = test; 100ERROR 42000: Incorrect argument type to variable 'max_delayed_threads' 101SELECT @@global.max_delayed_threads; 102@@global.max_delayed_threads 10316384 104SET @@session.max_delayed_threads = 16385; 105Warnings: 106Warning 1292 Truncated incorrect max_delayed_threads value: '16385' 107SELECT @@session.max_delayed_threads; 108@@session.max_delayed_threads 10916384 110SET @@session.max_delayed_threads = -1; 111Warnings: 112Warning 1292 Truncated incorrect max_delayed_threads value: '-1' 113SELECT @@session.max_delayed_threads; 114@@session.max_delayed_threads 1150 116SET @@session.max_delayed_threads = -2; 117Warnings: 118Warning 1292 Truncated incorrect max_delayed_threads value: '-2' 119SELECT @@session.max_delayed_threads; 120@@session.max_delayed_threads 1210 122SET @@session.max_delayed_threads = 65530.34; 123ERROR 42000: Incorrect argument type to variable 'max_delayed_threads' 124SET @@session.max_delayed_threads = 10737418241; 125Warnings: 126Warning 1292 Truncated incorrect max_delayed_threads value: '10737418241' 127SELECT @@session.max_delayed_threads; 128@@session.max_delayed_threads 12916384 130SET @@session.max_delayed_threads = test; 131ERROR 42000: Incorrect argument type to variable 'max_delayed_threads' 132SELECT @@session.max_delayed_threads; 133@@session.max_delayed_threads 13416384 135'#------------------FN_DYNVARS_075_06-----------------------#' 136SELECT @@global.max_delayed_threads = VARIABLE_VALUE 137FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 138WHERE VARIABLE_NAME='max_delayed_threads'; 139@@global.max_delayed_threads = VARIABLE_VALUE 1401 141'#------------------FN_DYNVARS_075_07-----------------------#' 142SELECT @@session.max_delayed_threads = VARIABLE_VALUE 143FROM INFORMATION_SCHEMA.SESSION_VARIABLES 144WHERE VARIABLE_NAME='max_delayed_threads'; 145@@session.max_delayed_threads = VARIABLE_VALUE 1461 147'#------------------FN_DYNVARS_075_08-----------------------#' 148SET @@global.max_delayed_threads = TRUE; 149SELECT @@global.max_delayed_threads; 150@@global.max_delayed_threads 1511 152SET @@global.max_delayed_threads = FALSE; 153SELECT @@global.max_delayed_threads; 154@@global.max_delayed_threads 1550 156'#---------------------FN_DYNVARS_001_09----------------------#' 157SET @@global.max_delayed_threads = 2048; 158SELECT @@max_delayed_threads = @@global.max_delayed_threads; 159@@max_delayed_threads = @@global.max_delayed_threads 1600 161'#---------------------FN_DYNVARS_001_10----------------------#' 162SET @@max_delayed_threads = 100000; 163ERROR 42000: Variable 'max_delayed_threads' can't be set to the value of '100000' 164SELECT @@max_delayed_threads = @@local.max_delayed_threads; 165@@max_delayed_threads = @@local.max_delayed_threads 1661 167SELECT @@local.max_delayed_threads = @@session.max_delayed_threads; 168@@local.max_delayed_threads = @@session.max_delayed_threads 1691 170'#---------------------FN_DYNVARS_001_11----------------------#' 171SET max_delayed_threads = 1024; 172ERROR 42000: Variable 'max_delayed_threads' can't be set to the value of '1024' 173SELECT @@max_delayed_threads; 174@@max_delayed_threads 17516384 176SELECT local.max_delayed_threads; 177ERROR 42S02: Unknown table 'local' in field list 178SELECT session.max_delayed_threads; 179ERROR 42S02: Unknown table 'session' in field list 180SELECT max_delayed_threads = @@session.max_delayed_threads; 181ERROR 42S22: Unknown column 'max_delayed_threads' in 'field list' 182SET @@global.max_delayed_threads = @start_global_value; 183SELECT @@global.max_delayed_threads; 184@@global.max_delayed_threads 18520 186SET @@session.max_delayed_threads = @start_session_value; 187SELECT @@session.max_delayed_threads; 188@@session.max_delayed_threads 18920 190