1SET @start_value = @@global.concurrent_insert; 2SELECT @start_value; 3@start_value 4AUTO 5'#--------------------FN_DYNVARS_018_01------------------------#' 6SET @@global.concurrent_insert = 0; 7SET @@global.concurrent_insert = DEFAULT; 8SELECT @@global.concurrent_insert; 9@@global.concurrent_insert 10AUTO 11'#---------------------FN_DYNVARS_018_02-------------------------#' 12SET @@global.concurrent_insert = DEFAULT; 13SELECT @@global.concurrent_insert = 1; 14@@global.concurrent_insert = 1 150 16Warnings: 17Warning 1292 Truncated incorrect DOUBLE value: 'AUTO' 18'#--------------------FN_DYNVARS_018_03------------------------#' 19SET @@global.concurrent_insert = 0; 20SELECT @@global.concurrent_insert; 21@@global.concurrent_insert 22NEVER 23SET @@global.concurrent_insert = 1; 24SELECT @@global.concurrent_insert; 25@@global.concurrent_insert 26AUTO 27SET @@global.concurrent_insert = 2; 28SELECT @@global.concurrent_insert; 29@@global.concurrent_insert 30ALWAYS 31SET @@global.concurrent_insert = NEVER; 32SELECT @@global.concurrent_insert; 33@@global.concurrent_insert 34NEVER 35SET @@global.concurrent_insert = AUTO; 36SELECT @@global.concurrent_insert; 37@@global.concurrent_insert 38AUTO 39SET @@global.concurrent_insert = ALWAYS; 40SELECT @@global.concurrent_insert; 41@@global.concurrent_insert 42ALWAYS 43'#--------------------FN_DYNVARS_018_04-------------------------#' 44SET @@global.concurrent_insert = -1; 45ERROR 42000: Variable 'concurrent_insert' can't be set to the value of '-1' 46SET @@global.concurrent_insert = 100; 47ERROR 42000: Variable 'concurrent_insert' can't be set to the value of '100' 48SET @@global.concurrent_insert = TRUEF; 49ERROR 42000: Variable 'concurrent_insert' can't be set to the value of 'TRUEF' 50SET @@global.concurrent_insert = TRUE_F; 51ERROR 42000: Variable 'concurrent_insert' can't be set to the value of 'TRUE_F' 52SET @@global.concurrent_insert = FALSE0; 53ERROR 42000: Variable 'concurrent_insert' can't be set to the value of 'FALSE0' 54SET @@global.concurrent_insert = OON; 55ERROR 42000: Variable 'concurrent_insert' can't be set to the value of 'OON' 56SET @@global.concurrent_insert = ONN; 57ERROR 42000: Variable 'concurrent_insert' can't be set to the value of 'ONN' 58SET @@global.concurrent_insert = OOFF; 59ERROR 42000: Variable 'concurrent_insert' can't be set to the value of 'OOFF' 60SET @@global.concurrent_insert = 0FF; 61ERROR 42000: Variable 'concurrent_insert' can't be set to the value of '0FF' 62SET @@global.concurrent_insert = ' '; 63ERROR 42000: Variable 'concurrent_insert' can't be set to the value of ' ' 64SET @@global.concurrent_insert = " "; 65ERROR 42000: Variable 'concurrent_insert' can't be set to the value of ' ' 66SET @@global.concurrent_insert = ''; 67ERROR 42000: Variable 'concurrent_insert' can't be set to the value of '' 68'#-------------------FN_DYNVARS_018_05----------------------------#' 69SET @@session.concurrent_insert = 1; 70ERROR HY000: Variable 'concurrent_insert' is a GLOBAL variable and should be set with SET GLOBAL 71SELECT @@session.concurrent_insert = 1; 72ERROR HY000: Variable 'concurrent_insert' is a GLOBAL variable 73'#----------------------FN_DYNVARS_018_06------------------------#' 74SELECT @@global.concurrent_insert = VARIABLE_VALUE 75FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 76WHERE VARIABLE_NAME='concurrent_insert'; 77@@global.concurrent_insert = VARIABLE_VALUE 781 79'#---------------------FN_DYNVARS_018_07----------------------#' 80SET @@global.concurrent_insert = OFF; 81ERROR 42000: Variable 'concurrent_insert' can't be set to the value of 'OFF' 82SET @@global.concurrent_insert = ON; 83ERROR 42000: Variable 'concurrent_insert' can't be set to the value of 'ON' 84'#---------------------FN_DYNVARS_018_08----------------------#' 85SET @@global.concurrent_insert = TRUE; 86SELECT @@global.concurrent_insert; 87@@global.concurrent_insert 88AUTO 89SET @@global.concurrent_insert = FALSE; 90SELECT @@global.concurrent_insert; 91@@global.concurrent_insert 92NEVER 93'#---------------------FN_DYNVARS_018_09----------------------#' 94SET @@global.concurrent_insert = 1; 95SELECT @@concurrent_insert = @@global.concurrent_insert; 96@@concurrent_insert = @@global.concurrent_insert 971 98'#---------------------FN_DYNVARS_018_10----------------------#' 99SET concurrent_insert = 1; 100ERROR HY000: Variable 'concurrent_insert' is a GLOBAL variable and should be set with SET GLOBAL 101SELECT @@concurrent_insert; 102@@concurrent_insert 103AUTO 104SELECT global.concurrent_insert; 105ERROR 42S02: Unknown table 'global' in field list 106SELECT concurrent_insert = @@session.concurrent_insert; 107ERROR 42S22: Unknown column 'concurrent_insert' in 'field list' 108SET @@global.concurrent_insert = @start_value; 109SELECT @@global.concurrent_insert; 110@@global.concurrent_insert 111AUTO 112