1SET @start_value = @@global.delayed_insert_limit; 2Warnings: 3Warning 1287 '@@delayed_insert_limit' is deprecated and will be removed in a future release. 4SELECT @start_value; 5@start_value 6100 7'#--------------------FN_DYNVARS_024_01------------------------#' 8SET @@global.delayed_insert_limit = 100; 9Warnings: 10Warning 1287 '@@delayed_insert_limit' is deprecated and will be removed in a future release. 11SET @@global.delayed_insert_limit = DEFAULT; 12Warnings: 13Warning 1287 '@@delayed_insert_limit' is deprecated and will be removed in a future release. 14SELECT @@global.delayed_insert_limit; 15@@global.delayed_insert_limit 16100 17Warnings: 18Warning 1287 '@@delayed_insert_limit' is deprecated and will be removed in a future release. 19'#---------------------FN_DYNVARS_024_02-------------------------#' 20SET @@global.delayed_insert_limit = @start_value; 21Warnings: 22Warning 1287 '@@delayed_insert_limit' is deprecated and will be removed in a future release. 23SELECT @@global.delayed_insert_limit = 100; 24@@global.delayed_insert_limit = 100 251 26Warnings: 27Warning 1287 '@@delayed_insert_limit' is deprecated and will be removed in a future release. 28'#--------------------FN_DYNVARS_024_03------------------------#' 29SET @@global.delayed_insert_limit = 10000; 30Warnings: 31Warning 1287 '@@delayed_insert_limit' is deprecated and will be removed in a future release. 32SELECT @@global.delayed_insert_limit; 33@@global.delayed_insert_limit 3410000 35Warnings: 36Warning 1287 '@@delayed_insert_limit' is deprecated and will be removed in a future release. 37SET @@global.delayed_insert_limit = 4294967295; 38Warnings: 39Warning 1287 '@@delayed_insert_limit' is deprecated and will be removed in a future release. 40SELECT @@global.delayed_insert_limit; 41@@global.delayed_insert_limit 424294967295 43Warnings: 44Warning 1287 '@@delayed_insert_limit' is deprecated and will be removed in a future release. 45SET @@global.delayed_insert_limit = 1; 46Warnings: 47Warning 1287 '@@delayed_insert_limit' is deprecated and will be removed in a future release. 48SELECT @@global.delayed_insert_limit; 49@@global.delayed_insert_limit 501 51Warnings: 52Warning 1287 '@@delayed_insert_limit' is deprecated and will be removed in a future release. 53'#--------------------FN_DYNVARS_024_04-------------------------#' 54SET @@global.delayed_insert_limit = 0; 55Warnings: 56Warning 1287 '@@delayed_insert_limit' is deprecated and will be removed in a future release. 57Warning 1292 Truncated incorrect delayed_insert_limit value: '0' 58SELECT @@global.delayed_insert_limit; 59@@global.delayed_insert_limit 601 61Warnings: 62Warning 1287 '@@delayed_insert_limit' is deprecated and will be removed in a future release. 63SET @@global.delayed_insert_limit = -1024; 64Warnings: 65Warning 1287 '@@delayed_insert_limit' is deprecated and will be removed in a future release. 66Warning 1292 Truncated incorrect delayed_insert_limit value: '-1024' 67SELECT @@global.delayed_insert_limit; 68@@global.delayed_insert_limit 691 70Warnings: 71Warning 1287 '@@delayed_insert_limit' is deprecated and will be removed in a future release. 72SET @@global.delayed_insert_limit = 42949672950; 73Warnings: 74Warning 1287 '@@delayed_insert_limit' is deprecated and will be removed in a future release. 75SELECT @@global.delayed_insert_limit; 76@@global.delayed_insert_limit 7742949672950 78Warnings: 79Warning 1287 '@@delayed_insert_limit' is deprecated and will be removed in a future release. 80SET @@global.delayed_insert_limit = 429496729.5; 81ERROR 42000: Incorrect argument type to variable 'delayed_insert_limit' 82SELECT @@global.delayed_insert_limit; 83@@global.delayed_insert_limit 8442949672950 85Warnings: 86Warning 1287 '@@delayed_insert_limit' is deprecated and will be removed in a future release. 87SET @@global.delayed_insert_limit = ON; 88ERROR 42000: Incorrect argument type to variable 'delayed_insert_limit' 89SELECT @@global.delayed_insert_limit; 90@@global.delayed_insert_limit 9142949672950 92Warnings: 93Warning 1287 '@@delayed_insert_limit' is deprecated and will be removed in a future release. 94'#-------------------FN_DYNVARS_024_05----------------------------#' 95SET @@session.delayed_insert_limit = 0; 96ERROR HY000: Variable 'delayed_insert_limit' is a GLOBAL variable and should be set with SET GLOBAL 97SELECT @@Session.delayed_insert_limit; 98ERROR HY000: Variable 'delayed_insert_limit' is a GLOBAL variable 99'#----------------------FN_DYNVARS_024_06------------------------#' 100SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 101WHERE VARIABLE_NAME='delayed_insert_limit' 102 into @tmp; 103SELECT @@global.delayed_insert_limit = @tmp; 104@@global.delayed_insert_limit = @tmp 1051 106Warnings: 107Warning 1287 '@@delayed_insert_limit' is deprecated and will be removed in a future release. 108SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.SESSION_VARIABLES 109WHERE VARIABLE_NAME='delayed_insert_limit' 110 into @tmp; 111SELECT @@delayed_insert_limit = @tmp; 112@@delayed_insert_limit = @tmp 1131 114Warnings: 115Warning 1287 '@@delayed_insert_limit' is deprecated and will be removed in a future release. 116'#---------------------FN_DYNVARS_024_07----------------------#' 117SET @@global.delayed_insert_limit = TRUE; 118Warnings: 119Warning 1287 '@@delayed_insert_limit' is deprecated and will be removed in a future release. 120SELECT @@global.delayed_insert_limit; 121@@global.delayed_insert_limit 1221 123Warnings: 124Warning 1287 '@@delayed_insert_limit' is deprecated and will be removed in a future release. 125SET @@global.delayed_insert_limit = FALSE; 126Warnings: 127Warning 1287 '@@delayed_insert_limit' is deprecated and will be removed in a future release. 128Warning 1292 Truncated incorrect delayed_insert_limit value: '0' 129SELECT @@global.delayed_insert_limit; 130@@global.delayed_insert_limit 1311 132Warnings: 133Warning 1287 '@@delayed_insert_limit' is deprecated and will be removed in a future release. 134'#---------------------FN_DYNVARS_024_08----------------------#' 135SET @@global.delayed_insert_limit = 1; 136Warnings: 137Warning 1287 '@@delayed_insert_limit' is deprecated and will be removed in a future release. 138SELECT @@delayed_insert_limit = @@global.delayed_insert_limit; 139@@delayed_insert_limit = @@global.delayed_insert_limit 1401 141Warnings: 142Warning 1287 '@@delayed_insert_limit' is deprecated and will be removed in a future release. 143Warning 1287 '@@delayed_insert_limit' is deprecated and will be removed in a future release. 144'#---------------------FN_DYNVARS_024_09----------------------#' 145SET delayed_insert_limit = 1; 146ERROR HY000: Variable 'delayed_insert_limit' is a GLOBAL variable and should be set with SET GLOBAL 147SELECT @@delayed_insert_limit; 148@@delayed_insert_limit 1491 150Warnings: 151Warning 1287 '@@delayed_insert_limit' is deprecated and will be removed in a future release. 152SET local.delayed_insert_limit = 1; 153ERROR 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_insert_limit = 1' at line 1 154SELECT local.delayed_insert_limit; 155ERROR 42S02: Unknown table 'local' in field list 156SET global.delayed_insert_limit = 1; 157ERROR 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_insert_limit = 1' at line 1 158SELECT global.delayed_insert_limit; 159ERROR 42S02: Unknown table 'global' in field list 160SELECT delayed_insert_limit = @@session.delayed_insert_limit; 161ERROR 42S22: Unknown column 'delayed_insert_limit' in 'field list' 162SET @@global.delayed_insert_limit = @start_value; 163Warnings: 164Warning 1287 '@@delayed_insert_limit' is deprecated and will be removed in a future release. 165SELECT @@global.delayed_insert_limit; 166@@global.delayed_insert_limit 167100 168Warnings: 169Warning 1287 '@@delayed_insert_limit' is deprecated and will be removed in a future release. 170