Debian Codegraph @

mysql-test/suite/sys_vars/r/innodb_flush_log_at_timeout_basic.result

raw
1 SET @global_start_value = @@global.innodb_flush_log_at_timeout;
2 SELECT @global_start_value;
3 @global_start_value
4 1
5 '#--------------------FN_DYNVARS_046_01------------------------#'
6 SET @@global.innodb_flush_log_at_timeout = 0;
7 SET @@global.innodb_flush_log_at_timeout = DEFAULT;
8 SELECT @@global.innodb_flush_log_at_timeout;
9 @@global.innodb_flush_log_at_timeout
10 1
11 '#---------------------FN_DYNVARS_046_02-------------------------#'
12 SET innodb_flush_log_at_timeout = 1;
13 ERROR HY000: Variable 'innodb_flush_log_at_timeout' is a GLOBAL variable and should be set with SET GLOBAL
14 SELECT @@innodb_flush_log_at_timeout;
15 @@innodb_flush_log_at_timeout
16 1
17 SELECT local.innodb_flush_log_at_timeout;
18 ERROR 42S02: Unknown table 'local' in field list
19 SET global innodb_flush_log_at_timeout = 0;
20 SELECT @@global.innodb_flush_log_at_timeout;
21 @@global.innodb_flush_log_at_timeout
22 0
23 '#--------------------FN_DYNVARS_046_03------------------------#'
24 SET @@global.innodb_flush_log_at_timeout = 0;
25 SELECT @@global.innodb_flush_log_at_timeout;
26 @@global.innodb_flush_log_at_timeout
27 0
28 SET @@global.innodb_flush_log_at_timeout = 10;
29 SELECT @@global.innodb_flush_log_at_timeout;
30 @@global.innodb_flush_log_at_timeout
31 10
32 SET @@global.innodb_flush_log_at_timeout = 2700;
33 SELECT @@global.innodb_flush_log_at_timeout;
34 @@global.innodb_flush_log_at_timeout
35 2700
36 '#--------------------FN_DYNVARS_046_04-------------------------#'
37 SET @@global.innodb_flush_log_at_timeout = -1;
38 Warnings:
39 Warning 1292 Truncated incorrect innodb_flush_log_at_timeout value: '-1'
40 SELECT @@global.innodb_flush_log_at_timeout;
41 @@global.innodb_flush_log_at_timeout
42 0
43 SET @@global.innodb_flush_log_at_timeout = "T";
44 ERROR 42000: Incorrect argument type to variable 'innodb_flush_log_at_timeout'
45 SELECT @@global.innodb_flush_log_at_timeout;
46 @@global.innodb_flush_log_at_timeout
47 0
48 SET @@global.innodb_flush_log_at_timeout = "Y";
49 ERROR 42000: Incorrect argument type to variable 'innodb_flush_log_at_timeout'
50 SELECT @@global.innodb_flush_log_at_timeout;
51 @@global.innodb_flush_log_at_timeout
52 0
53 SET @@global.innodb_flush_log_at_timeout = 2701;
54 Warnings:
55 Warning 1292 Truncated incorrect innodb_flush_log_at_timeout value: '2701'
56 SELECT @@global.innodb_flush_log_at_timeout;
57 @@global.innodb_flush_log_at_timeout
58 2700
59 SET @@global.innodb_flush_log_at_timeout = ' ';
60 ERROR 42000: Incorrect argument type to variable 'innodb_flush_log_at_timeout'
61 SELECT @@global.innodb_flush_log_at_timeout;
62 @@global.innodb_flush_log_at_timeout
63 2700
64 SET @@global.innodb_flush_log_at_timeout = " ";
65 ERROR 42000: Incorrect argument type to variable 'innodb_flush_log_at_timeout'
66 SELECT @@global.innodb_flush_log_at_timeout;
67 @@global.innodb_flush_log_at_timeout
68 2700
69 SET @@global.innodb_flush_log_at_timeout = 1.1;
70 ERROR 42000: Incorrect argument type to variable 'innodb_flush_log_at_timeout'
71 SELECT @@global.innodb_flush_log_at_timeout;
72 @@global.innodb_flush_log_at_timeout
73 2700
74 '#----------------------FN_DYNVARS_046_05------------------------#'
75 SELECT @@global.innodb_flush_log_at_timeout =
76 VARIABLE_VALUE FROM performance_schema.global_variables
77 WHERE VARIABLE_NAME='innodb_flush_log_at_timeout';
78 @@global.innodb_flush_log_at_timeout =
79 VARIABLE_VALUE
80 1
81 SELECT @@global.innodb_flush_log_at_timeout;
82 @@global.innodb_flush_log_at_timeout
83 2700
84 SELECT VARIABLE_VALUE FROM performance_schema.global_variables
85 WHERE VARIABLE_NAME='innodb_flush_log_at_timeout';
86 VARIABLE_VALUE
87 2700
88 '#---------------------FN_DYNVARS_046_06-------------------------#'
89 SET @@global.innodb_flush_log_at_timeout = OFF;
90 ERROR 42000: Incorrect argument type to variable 'innodb_flush_log_at_timeout'
91 SELECT @@global.innodb_flush_log_at_timeout;
92 @@global.innodb_flush_log_at_timeout
93 2700
94 SET @@global.innodb_flush_log_at_timeout = ON;
95 ERROR 42000: Incorrect argument type to variable 'innodb_flush_log_at_timeout'
96 SELECT @@global.innodb_flush_log_at_timeout;
97 @@global.innodb_flush_log_at_timeout
98 2700
99 '#---------------------FN_DYNVARS_046_07----------------------#'
100 SET @@global.innodb_flush_log_at_timeout = TRUE;
101 SELECT @@global.innodb_flush_log_at_timeout;
102 @@global.innodb_flush_log_at_timeout
103 1
104 SET @@global.innodb_flush_log_at_timeout = FALSE;
105 SELECT @@global.innodb_flush_log_at_timeout;
106 @@global.innodb_flush_log_at_timeout
107 0
108 SET @@global.innodb_flush_log_at_timeout = @global_start_value;
109 SELECT @@global.innodb_flush_log_at_timeout;
110 @@global.innodb_flush_log_at_timeout
111 1