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. 75SELECT @@global.delayed_queue_size; 76@@global.delayed_queue_size 7742949672950 78Warnings: 79Warning 1287 '@@delayed_queue_size' is deprecated and will be removed in a future release. 80SET @@global.delayed_queue_size = 429496729.5; 81ERROR 42000: Incorrect argument type to variable 'delayed_queue_size' 82SELECT @@global.delayed_queue_size; 83@@global.delayed_queue_size 8442949672950 85Warnings: 86Warning 1287 '@@delayed_queue_size' is deprecated and will be removed in a future release. 87SET @@global.delayed_queue_size = ON; 88ERROR 42000: Incorrect argument type to variable 'delayed_queue_size' 89SELECT @@delayed_queue_size; 90@@delayed_queue_size 9142949672950 92Warnings: 93Warning 1287 '@@delayed_queue_size' is deprecated and will be removed in a future release. 94'#-------------------FN_DYNVARS_026_05----------------------------#' 95SET @@session.delayed_queue_size = 0; 96ERROR HY000: Variable 'delayed_queue_size' is a GLOBAL variable and should be set with SET GLOBAL 97SELECT @@session.delayed_queue_size; 98ERROR HY000: Variable 'delayed_queue_size' is a GLOBAL variable 99'#----------------------FN_DYNVARS_026_06------------------------#' 100SELECT VARIABLE_VALUE 101FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 102WHERE VARIABLE_NAME='delayed_queue_size' 103into @tmp; 104SELECT @@global.delayed_queue_size = @tmp; 105@@global.delayed_queue_size = @tmp 1061 107Warnings: 108Warning 1287 '@@delayed_queue_size' is deprecated and will be removed in a future release. 109SELECT VARIABLE_VALUE 110FROM INFORMATION_SCHEMA.SESSION_VARIABLES 111WHERE VARIABLE_NAME='delayed_queue_size' 112into @tmp; 113SELECT @@delayed_queue_size = @tmp; 114@@delayed_queue_size = @tmp 1151 116Warnings: 117Warning 1287 '@@delayed_queue_size' is deprecated and will be removed in a future release. 118'#---------------------FN_DYNVARS_026_07----------------------#' 119SET @@global.delayed_queue_size = TRUE; 120Warnings: 121Warning 1287 '@@delayed_queue_size' is deprecated and will be removed in a future release. 122SELECT @@global.delayed_queue_size; 123@@global.delayed_queue_size 1241 125Warnings: 126Warning 1287 '@@delayed_queue_size' is deprecated and will be removed in a future release. 127SET @@global.delayed_queue_size = FALSE; 128Warnings: 129Warning 1287 '@@delayed_queue_size' is deprecated and will be removed in a future release. 130Warning 1292 Truncated incorrect delayed_queue_size value: '0' 131SELECT @@global.delayed_queue_size; 132@@global.delayed_queue_size 1331 134Warnings: 135Warning 1287 '@@delayed_queue_size' is deprecated and will be removed in a future release. 136'#---------------------FN_DYNVARS_026_08----------------------#' 137SET @@global.delayed_queue_size = 1; 138Warnings: 139Warning 1287 '@@delayed_queue_size' is deprecated and will be removed in a future release. 140SELECT @@delayed_queue_size = @@global.delayed_queue_size; 141@@delayed_queue_size = @@global.delayed_queue_size 1421 143Warnings: 144Warning 1287 '@@delayed_queue_size' is deprecated and will be removed in a future release. 145Warning 1287 '@@delayed_queue_size' is deprecated and will be removed in a future release. 146'#---------------------FN_DYNVARS_026_09----------------------#' 147SET delayed_queue_size = 1; 148ERROR HY000: Variable 'delayed_queue_size' is a GLOBAL variable and should be set with SET GLOBAL 149SELECT @@delayed_queue_size; 150@@delayed_queue_size 1511 152Warnings: 153Warning 1287 '@@delayed_queue_size' is deprecated and will be removed in a future release. 154SET local.delayed_queue_size = 1; 155ERROR 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 'local.delayed_queue_size = 1' at line 1 156SELECT local.delayed_queue_size; 157ERROR 42S02: Unknown table 'local' in field list 158SET global.delayed_queue_size = 1; 159ERROR 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 'global.delayed_queue_size = 1' at line 1 160SELECT global.delayed_queue_size; 161ERROR 42S02: Unknown table 'global' in field list 162SELECT delayed_queue_size = @@session.delayed_queue_size; 163ERROR 42S22: Unknown column 'delayed_queue_size' in 'field list' 164SET @@global.delayed_queue_size = @start_value; 165Warnings: 166Warning 1287 '@@delayed_queue_size' is deprecated and will be removed in a future release. 167SELECT @@global.delayed_queue_size; 168@@global.delayed_queue_size 1691000 170Warnings: 171Warning 1287 '@@delayed_queue_size' is deprecated and will be removed in a future release. 172