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. 75Warning 1292 Truncated incorrect delayed_insert_limit value: '42949672950' 76SELECT @@global.delayed_insert_limit; 77@@global.delayed_insert_limit 784294967295 79Warnings: 80Warning 1287 '@@delayed_insert_limit' is deprecated and will be removed in a future release. 81SET @@global.delayed_insert_limit = 429496729.5; 82ERROR 42000: Incorrect argument type to variable 'delayed_insert_limit' 83SELECT @@global.delayed_insert_limit; 84@@global.delayed_insert_limit 854294967295 86Warnings: 87Warning 1287 '@@delayed_insert_limit' is deprecated and will be removed in a future release. 88SET @@global.delayed_insert_limit = ON; 89ERROR 42000: Incorrect argument type to variable 'delayed_insert_limit' 90SELECT @@global.delayed_insert_limit; 91@@global.delayed_insert_limit 924294967295 93Warnings: 94Warning 1287 '@@delayed_insert_limit' is deprecated and will be removed in a future release. 95'#-------------------FN_DYNVARS_024_05----------------------------#' 96SET @@session.delayed_insert_limit = 0; 97ERROR HY000: Variable 'delayed_insert_limit' is a GLOBAL variable and should be set with SET GLOBAL 98SELECT @@Session.delayed_insert_limit; 99ERROR HY000: Variable 'delayed_insert_limit' is a GLOBAL variable 100'#----------------------FN_DYNVARS_024_06------------------------#' 101SELECT @@global.delayed_insert_limit = 102VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 103WHERE VARIABLE_NAME='delayed_insert_limit'; 104@@global.delayed_insert_limit = 105VARIABLE_VALUE 1061 107Warnings: 108Warning 1287 '@@delayed_insert_limit' is deprecated and will be removed in a future release. 109SELECT @@delayed_insert_limit = 110VARIABLE_VALUE FROM INFORMATION_SCHEMA.SESSION_VARIABLES 111WHERE VARIABLE_NAME='delayed_insert_limit'; 112@@delayed_insert_limit = 113VARIABLE_VALUE 1141 115Warnings: 116Warning 1287 '@@delayed_insert_limit' is deprecated and will be removed in a future release. 117'#---------------------FN_DYNVARS_024_07----------------------#' 118SET @@global.delayed_insert_limit = TRUE; 119Warnings: 120Warning 1287 '@@delayed_insert_limit' is deprecated and will be removed in a future release. 121SELECT @@global.delayed_insert_limit; 122@@global.delayed_insert_limit 1231 124Warnings: 125Warning 1287 '@@delayed_insert_limit' is deprecated and will be removed in a future release. 126SET @@global.delayed_insert_limit = FALSE; 127Warnings: 128Warning 1287 '@@delayed_insert_limit' is deprecated and will be removed in a future release. 129Warning 1292 Truncated incorrect delayed_insert_limit value: '0' 130SELECT @@global.delayed_insert_limit; 131@@global.delayed_insert_limit 1321 133Warnings: 134Warning 1287 '@@delayed_insert_limit' is deprecated and will be removed in a future release. 135'#---------------------FN_DYNVARS_024_08----------------------#' 136SET @@global.delayed_insert_limit = 1; 137Warnings: 138Warning 1287 '@@delayed_insert_limit' is deprecated and will be removed in a future release. 139SELECT @@delayed_insert_limit = @@global.delayed_insert_limit; 140@@delayed_insert_limit = @@global.delayed_insert_limit 1411 142Warnings: 143Warning 1287 '@@delayed_insert_limit' is deprecated and will be removed in a future release. 144Warning 1287 '@@delayed_insert_limit' is deprecated and will be removed in a future release. 145'#---------------------FN_DYNVARS_024_09----------------------#' 146SET delayed_insert_limit = 1; 147ERROR HY000: Variable 'delayed_insert_limit' is a GLOBAL variable and should be set with SET GLOBAL 148SELECT @@delayed_insert_limit; 149@@delayed_insert_limit 1501 151Warnings: 152Warning 1287 '@@delayed_insert_limit' is deprecated and will be removed in a future release. 153SET local.delayed_insert_limit = 1; 154ERROR 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_insert_limit = 1' at line 1 155SELECT local.delayed_insert_limit; 156ERROR 42S02: Unknown table 'local' in field list 157SET global.delayed_insert_limit = 1; 158ERROR 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_insert_limit = 1' at line 1 159SELECT global.delayed_insert_limit; 160ERROR 42S02: Unknown table 'global' in field list 161SELECT delayed_insert_limit = @@session.delayed_insert_limit; 162ERROR 42S22: Unknown column 'delayed_insert_limit' in 'field list' 163SET @@global.delayed_insert_limit = @start_value; 164Warnings: 165Warning 1287 '@@delayed_insert_limit' is deprecated and will be removed in a future release. 166SELECT @@global.delayed_insert_limit; 167@@global.delayed_insert_limit 168100 169Warnings: 170Warning 1287 '@@delayed_insert_limit' is deprecated and will be removed in a future release. 171