1SET @start_value = @@global.delayed_queue_size; 2Warnings: 3Warning 1287 '@@delayed_queue_size' is deprecated and will be removed in a future release. 4SELECT @start_value; 5@start_value 61000 7'#--------------------FN_DYNVARS_026_01------------------------#' 8SET @@global.delayed_queue_size = 100; 9Warnings: 10Warning 1287 '@@delayed_queue_size' is deprecated and will be removed in a future release. 11SET @@global.delayed_queue_size = DEFAULT; 12Warnings: 13Warning 1287 '@@delayed_queue_size' is deprecated and will be removed in a future release. 14SELECT @@global.delayed_queue_size; 15@@global.delayed_queue_size 161000 17Warnings: 18Warning 1287 '@@delayed_queue_size' is deprecated and will be removed in a future release. 19'#---------------------FN_DYNVARS_026_02-------------------------#' 20SET @@global.delayed_queue_size = @start_value; 21Warnings: 22Warning 1287 '@@delayed_queue_size' is deprecated and will be removed in a future release. 23SELECT @@global.delayed_queue_size = 1000; 24@@global.delayed_queue_size = 1000 251 26Warnings: 27Warning 1287 '@@delayed_queue_size' is deprecated and will be removed in a future release. 28'#--------------------FN_DYNVARS_026_03------------------------#' 29SET @@global.delayed_queue_size = 10000; 30Warnings: 31Warning 1287 '@@delayed_queue_size' is deprecated and will be removed in a future release. 32SELECT @@global.delayed_queue_size; 33@@global.delayed_queue_size 3410000 35Warnings: 36Warning 1287 '@@delayed_queue_size' is deprecated and will be removed in a future release. 37SET @@global.delayed_queue_size = 4294967295; 38Warnings: 39Warning 1287 '@@delayed_queue_size' is deprecated and will be removed in a future release. 40SELECT @@global.delayed_queue_size; 41@@global.delayed_queue_size 424294967295 43Warnings: 44Warning 1287 '@@delayed_queue_size' is deprecated and will be removed in a future release. 45SET @@global.delayed_queue_size = 1; 46Warnings: 47Warning 1287 '@@delayed_queue_size' is deprecated and will be removed in a future release. 48SELECT @@global.delayed_queue_size; 49@@global.delayed_queue_size 501 51Warnings: 52Warning 1287 '@@delayed_queue_size' is deprecated and will be removed in a future release. 53'#--------------------FN_DYNVARS_026_04-------------------------#' 54SET @@global.delayed_queue_size = 0; 55Warnings: 56Warning 1287 '@@delayed_queue_size' is deprecated and will be removed in a future release. 57Warning 1292 Truncated incorrect delayed_queue_size value: '0' 58SELECT @@global.delayed_queue_size; 59@@global.delayed_queue_size 601 61Warnings: 62Warning 1287 '@@delayed_queue_size' is deprecated and will be removed in a future release. 63SET @@global.delayed_queue_size = -1024; 64Warnings: 65Warning 1287 '@@delayed_queue_size' is deprecated and will be removed in a future release. 66Warning 1292 Truncated incorrect delayed_queue_size value: '-1024' 67SELECT @@global.delayed_queue_size; 68@@global.delayed_queue_size 691 70Warnings: 71Warning 1287 '@@delayed_queue_size' is deprecated and will be removed in a future release. 72SET @@global.delayed_queue_size = 42949672950; 73Warnings: 74Warning 1287 '@@delayed_queue_size' is deprecated and will be removed in a future release. 75Warning 1292 Truncated incorrect delayed_queue_size value: '42949672950' 76SELECT @@global.delayed_queue_size; 77@@global.delayed_queue_size 784294967295 79Warnings: 80Warning 1287 '@@delayed_queue_size' is deprecated and will be removed in a future release. 81SET @@global.delayed_queue_size = 429496729.5; 82ERROR 42000: Incorrect argument type to variable 'delayed_queue_size' 83SELECT @@global.delayed_queue_size; 84@@global.delayed_queue_size 854294967295 86Warnings: 87Warning 1287 '@@delayed_queue_size' is deprecated and will be removed in a future release. 88SET @@global.delayed_queue_size = ON; 89ERROR 42000: Incorrect argument type to variable 'delayed_queue_size' 90SELECT @@delayed_queue_size; 91@@delayed_queue_size 924294967295 93Warnings: 94Warning 1287 '@@delayed_queue_size' is deprecated and will be removed in a future release. 95'#-------------------FN_DYNVARS_026_05----------------------------#' 96SET @@session.delayed_queue_size = 0; 97ERROR HY000: Variable 'delayed_queue_size' is a GLOBAL variable and should be set with SET GLOBAL 98SELECT @@session.delayed_queue_size; 99ERROR HY000: Variable 'delayed_queue_size' is a GLOBAL variable 100'#----------------------FN_DYNVARS_026_06------------------------#' 101SELECT @@global.delayed_queue_size = VARIABLE_VALUE 102FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 103WHERE VARIABLE_NAME='delayed_queue_size'; 104@@global.delayed_queue_size = VARIABLE_VALUE 1051 106Warnings: 107Warning 1287 '@@delayed_queue_size' is deprecated and will be removed in a future release. 108SELECT @@delayed_queue_size = VARIABLE_VALUE 109FROM INFORMATION_SCHEMA.SESSION_VARIABLES 110WHERE VARIABLE_NAME='delayed_queue_size'; 111@@delayed_queue_size = VARIABLE_VALUE 1121 113Warnings: 114Warning 1287 '@@delayed_queue_size' is deprecated and will be removed in a future release. 115'#---------------------FN_DYNVARS_026_07----------------------#' 116SET @@global.delayed_queue_size = TRUE; 117Warnings: 118Warning 1287 '@@delayed_queue_size' is deprecated and will be removed in a future release. 119SELECT @@global.delayed_queue_size; 120@@global.delayed_queue_size 1211 122Warnings: 123Warning 1287 '@@delayed_queue_size' is deprecated and will be removed in a future release. 124SET @@global.delayed_queue_size = FALSE; 125Warnings: 126Warning 1287 '@@delayed_queue_size' is deprecated and will be removed in a future release. 127Warning 1292 Truncated incorrect delayed_queue_size value: '0' 128SELECT @@global.delayed_queue_size; 129@@global.delayed_queue_size 1301 131Warnings: 132Warning 1287 '@@delayed_queue_size' is deprecated and will be removed in a future release. 133'#---------------------FN_DYNVARS_026_08----------------------#' 134SET @@global.delayed_queue_size = 1; 135Warnings: 136Warning 1287 '@@delayed_queue_size' is deprecated and will be removed in a future release. 137SELECT @@delayed_queue_size = @@global.delayed_queue_size; 138@@delayed_queue_size = @@global.delayed_queue_size 1391 140Warnings: 141Warning 1287 '@@delayed_queue_size' is deprecated and will be removed in a future release. 142Warning 1287 '@@delayed_queue_size' is deprecated and will be removed in a future release. 143'#---------------------FN_DYNVARS_026_09----------------------#' 144SET delayed_queue_size = 1; 145ERROR HY000: Variable 'delayed_queue_size' is a GLOBAL variable and should be set with SET GLOBAL 146SELECT @@delayed_queue_size; 147@@delayed_queue_size 1481 149Warnings: 150Warning 1287 '@@delayed_queue_size' is deprecated and will be removed in a future release. 151SET local.delayed_queue_size = 1; 152ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'delayed_queue_size = 1' at line 1 153SELECT local.delayed_queue_size; 154ERROR 42S02: Unknown table 'local' in field list 155SET global.delayed_queue_size = 1; 156ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'delayed_queue_size = 1' at line 1 157SELECT global.delayed_queue_size; 158ERROR 42S02: Unknown table 'global' in field list 159SELECT delayed_queue_size = @@session.delayed_queue_size; 160ERROR 42S22: Unknown column 'delayed_queue_size' in 'field list' 161SET @@global.delayed_queue_size = @start_value; 162Warnings: 163Warning 1287 '@@delayed_queue_size' is deprecated and will be removed in a future release. 164SELECT @@global.delayed_queue_size; 165@@global.delayed_queue_size 1661000 167Warnings: 168Warning 1287 '@@delayed_queue_size' is deprecated and will be removed in a future release. 169