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