1SET @global_start_value = @@global.innodb_commit_concurrency;
2SELECT @global_start_value;
3@global_start_value
40
5'#--------------------FN_DYNVARS_046_01------------------------#'
6SET @@global.innodb_commit_concurrency = 0;
7SET @@global.innodb_commit_concurrency = DEFAULT;
8SELECT @@global.innodb_commit_concurrency;
9@@global.innodb_commit_concurrency
100
11'#---------------------FN_DYNVARS_046_02-------------------------#'
12SET innodb_commit_concurrency = 1;
13ERROR HY000: Variable 'innodb_commit_concurrency' is a GLOBAL variable and should be set with SET GLOBAL
14SELECT @@innodb_commit_concurrency;
15@@innodb_commit_concurrency
160
17SELECT local.innodb_commit_concurrency;
18ERROR 42S02: Unknown table 'local' in field list
19SET global innodb_commit_concurrency = 0;
20SELECT @@global.innodb_commit_concurrency;
21@@global.innodb_commit_concurrency
220
23'#--------------------FN_DYNVARS_046_03------------------------#'
24SET @@global.innodb_commit_concurrency = 0;
25SELECT @@global.innodb_commit_concurrency;
26@@global.innodb_commit_concurrency
270
28'#--------------------FN_DYNVARS_046_04-------------------------#'
29SET @@global.innodb_commit_concurrency = 1;
30ERROR 42000: Variable 'innodb_commit_concurrency' can't be set to the value of '1'
31SELECT @@global.innodb_commit_concurrency;
32@@global.innodb_commit_concurrency
330
34SET @@global.innodb_commit_concurrency = -1;
35ERROR 42000: Variable 'innodb_commit_concurrency' can't be set to the value of '-1'
36SELECT @@global.innodb_commit_concurrency;
37@@global.innodb_commit_concurrency
380
39SET @@global.innodb_commit_concurrency = "T";
40ERROR 42000: Incorrect argument type to variable 'innodb_commit_concurrency'
41SELECT @@global.innodb_commit_concurrency;
42@@global.innodb_commit_concurrency
430
44SET @@global.innodb_commit_concurrency = "Y";
45ERROR 42000: Incorrect argument type to variable 'innodb_commit_concurrency'
46SELECT @@global.innodb_commit_concurrency;
47@@global.innodb_commit_concurrency
480
49SET @@global.innodb_commit_concurrency = 1.1;
50ERROR 42000: Incorrect argument type to variable 'innodb_commit_concurrency'
51SELECT @@global.innodb_commit_concurrency;
52@@global.innodb_commit_concurrency
530
54SET @@global.innodb_commit_concurrency = 1001;
55ERROR 42000: Variable 'innodb_commit_concurrency' can't be set to the value of '1001'
56SELECT @@global.innodb_commit_concurrency;
57@@global.innodb_commit_concurrency
580
59'#----------------------FN_DYNVARS_046_05------------------------#'
60SELECT @@global.innodb_commit_concurrency =
61VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
62WHERE VARIABLE_NAME='innodb_commit_concurrency';
63@@global.innodb_commit_concurrency =
64VARIABLE_VALUE
651
66SELECT @@global.innodb_commit_concurrency;
67@@global.innodb_commit_concurrency
680
69SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
70WHERE VARIABLE_NAME='innodb_commit_concurrency';
71VARIABLE_VALUE
720
73'#---------------------FN_DYNVARS_046_06-------------------------#'
74SET @@global.innodb_commit_concurrency = OFF;
75ERROR 42000: Incorrect argument type to variable 'innodb_commit_concurrency'
76SELECT @@global.innodb_commit_concurrency;
77@@global.innodb_commit_concurrency
780
79SET @@global.innodb_commit_concurrency = ON;
80ERROR 42000: Incorrect argument type to variable 'innodb_commit_concurrency'
81SELECT @@global.innodb_commit_concurrency;
82@@global.innodb_commit_concurrency
830
84SET @@global.innodb_commit_concurrency = @global_start_value;
85SELECT @@global.innodb_commit_concurrency;
86@@global.innodb_commit_concurrency
870
88