Debian Codegraph @

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

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