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 VARIABLE_VALUE 102FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 103WHERE VARIABLE_NAME='delayed_queue_size' 104into @tmp; 105SELECT @@global.delayed_queue_size = @tmp; 106@@global.delayed_queue_size = @tmp 1071 108Warnings: 109Warning 1287 '@@delayed_queue_size' is deprecated and will be removed in a future release. 110SELECT VARIABLE_VALUE 111FROM INFORMATION_SCHEMA.SESSION_VARIABLES 112WHERE VARIABLE_NAME='delayed_queue_size' 113into @tmp; 114SELECT @@delayed_queue_size = @tmp; 115@@delayed_queue_size = @tmp 1161 117Warnings: 118Warning 1287 '@@delayed_queue_size' is deprecated and will be removed in a future release. 119'#---------------------FN_DYNVARS_026_07----------------------#' 120SET @@global.delayed_queue_size = TRUE; 121Warnings: 122Warning 1287 '@@delayed_queue_size' is deprecated and will be removed in a future release. 123SELECT @@global.delayed_queue_size; 124@@global.delayed_queue_size 1251 126Warnings: 127Warning 1287 '@@delayed_queue_size' is deprecated and will be removed in a future release. 128SET @@global.delayed_queue_size = FALSE; 129Warnings: 130Warning 1287 '@@delayed_queue_size' is deprecated and will be removed in a future release. 131Warning 1292 Truncated incorrect delayed_queue_size value: '0' 132SELECT @@global.delayed_queue_size; 133@@global.delayed_queue_size 1341 135Warnings: 136Warning 1287 '@@delayed_queue_size' is deprecated and will be removed in a future release. 137'#---------------------FN_DYNVARS_026_08----------------------#' 138SET @@global.delayed_queue_size = 1; 139Warnings: 140Warning 1287 '@@delayed_queue_size' is deprecated and will be removed in a future release. 141SELECT @@delayed_queue_size = @@global.delayed_queue_size; 142@@delayed_queue_size = @@global.delayed_queue_size 1431 144Warnings: 145Warning 1287 '@@delayed_queue_size' is deprecated and will be removed in a future release. 146Warning 1287 '@@delayed_queue_size' is deprecated and will be removed in a future release. 147'#---------------------FN_DYNVARS_026_09----------------------#' 148SET delayed_queue_size = 1; 149ERROR HY000: Variable 'delayed_queue_size' is a GLOBAL variable and should be set with SET GLOBAL 150SELECT @@delayed_queue_size; 151@@delayed_queue_size 1521 153Warnings: 154Warning 1287 '@@delayed_queue_size' is deprecated and will be removed in a future release. 155SET local.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 'local.delayed_queue_size = 1' at line 1 157SELECT local.delayed_queue_size; 158ERROR 42S02: Unknown table 'local' in field list 159SET global.delayed_queue_size = 1; 160ERROR 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 161SELECT global.delayed_queue_size; 162ERROR 42S02: Unknown table 'global' in field list 163SELECT delayed_queue_size = @@session.delayed_queue_size; 164ERROR 42S22: Unknown column 'delayed_queue_size' in 'field list' 165SET @@global.delayed_queue_size = @start_value; 166Warnings: 167Warning 1287 '@@delayed_queue_size' is deprecated and will be removed in a future release. 168SELECT @@global.delayed_queue_size; 169@@global.delayed_queue_size 1701000 171Warnings: 172Warning 1287 '@@delayed_queue_size' is deprecated and will be removed in a future release. 173