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