1SET @global_start_value = @@global.innodb_thread_concurrency;
2SELECT @global_start_value;
3@global_start_value
40
5'#--------------------FN_DYNVARS_046_01------------------------#'
6SET @@global.innodb_thread_concurrency = 0;
7SET @@global.innodb_thread_concurrency = DEFAULT;
8SELECT @@global.innodb_thread_concurrency;
9@@global.innodb_thread_concurrency
100
11'#---------------------FN_DYNVARS_046_02-------------------------#'
12SET innodb_thread_concurrency = 1;
13ERROR HY000: Variable 'innodb_thread_concurrency' is a GLOBAL variable and should be set with SET GLOBAL
14SELECT @@innodb_thread_concurrency;
15@@innodb_thread_concurrency
160
17SELECT local.innodb_thread_concurrency;
18ERROR 42S02: Unknown table 'local' in field list
19SET global innodb_thread_concurrency = 0;
20SELECT @@global.innodb_thread_concurrency;
21@@global.innodb_thread_concurrency
220
23'#--------------------FN_DYNVARS_046_03------------------------#'
24SET @@global.innodb_thread_concurrency = 0;
25SELECT @@global.innodb_thread_concurrency;
26@@global.innodb_thread_concurrency
270
28SET @@global.innodb_thread_concurrency = 1;
29SELECT @@global.innodb_thread_concurrency;
30@@global.innodb_thread_concurrency
311
32SET @@global.innodb_thread_concurrency = 1000;
33SELECT @@global.innodb_thread_concurrency;
34@@global.innodb_thread_concurrency
351000
36'#--------------------FN_DYNVARS_046_04-------------------------#'
37SET @@global.innodb_thread_concurrency = -1;
38Warnings:
39Warning	1292	Truncated incorrect innodb_thread_concurrency value: '-1'
40SELECT @@global.innodb_thread_concurrency;
41@@global.innodb_thread_concurrency
420
43SET @@global.innodb_thread_concurrency = "T";
44ERROR 42000: Incorrect argument type to variable 'innodb_thread_concurrency'
45SELECT @@global.innodb_thread_concurrency;
46@@global.innodb_thread_concurrency
470
48SET @@global.innodb_thread_concurrency = "Y";
49ERROR 42000: Incorrect argument type to variable 'innodb_thread_concurrency'
50SELECT @@global.innodb_thread_concurrency;
51@@global.innodb_thread_concurrency
520
53SET @@global.innodb_thread_concurrency = ' ';
54ERROR 42000: Incorrect argument type to variable 'innodb_thread_concurrency'
55SELECT @@global.innodb_thread_concurrency;
56@@global.innodb_thread_concurrency
570
58SET @@global.innodb_thread_concurrency = " ";
59ERROR 42000: Incorrect argument type to variable 'innodb_thread_concurrency'
60SELECT @@global.innodb_thread_concurrency;
61@@global.innodb_thread_concurrency
620
63SET @@global.innodb_thread_concurrency = 1001;
64Warnings:
65Warning	1292	Truncated incorrect innodb_thread_concurrency value: '1001'
66SELECT @@global.innodb_thread_concurrency;
67@@global.innodb_thread_concurrency
681000
69SET @@global.innodb_thread_concurrency = 255.01;
70ERROR 42000: Incorrect argument type to variable 'innodb_thread_concurrency'
71SELECT @@global.innodb_thread_concurrency;
72@@global.innodb_thread_concurrency
731000
74'#----------------------FN_DYNVARS_046_05------------------------#'
75SELECT @@global.innodb_thread_concurrency =
76VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
77WHERE VARIABLE_NAME='innodb_thread_concurrency';
78@@global.innodb_thread_concurrency =
79VARIABLE_VALUE
801
81SELECT @@global.innodb_thread_concurrency;
82@@global.innodb_thread_concurrency
831000
84SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
85WHERE VARIABLE_NAME='innodb_thread_concurrency';
86VARIABLE_VALUE
871000
88'#---------------------FN_DYNVARS_046_06-------------------------#'
89SET @@global.innodb_thread_concurrency = OFF;
90ERROR 42000: Incorrect argument type to variable 'innodb_thread_concurrency'
91SELECT @@global.innodb_thread_concurrency;
92@@global.innodb_thread_concurrency
931000
94SET @@global.innodb_thread_concurrency = ON;
95ERROR 42000: Incorrect argument type to variable 'innodb_thread_concurrency'
96SELECT @@global.innodb_thread_concurrency;
97@@global.innodb_thread_concurrency
981000
99'#---------------------FN_DYNVARS_046_07----------------------#'
100SET @@global.innodb_thread_concurrency = TRUE;
101SELECT @@global.innodb_thread_concurrency;
102@@global.innodb_thread_concurrency
1031
104SET @@global.innodb_thread_concurrency = FALSE;
105SELECT @@global.innodb_thread_concurrency;
106@@global.innodb_thread_concurrency
1070
108SET @@global.innodb_thread_concurrency = @global_start_value;
109SELECT @@global.innodb_thread_concurrency;
110@@global.innodb_thread_concurrency
1110
112