← Back to branch summary

~jlukas79/+junk/mysql-server

« back to all changes in this revision

Viewing changes to mysql-test/r/innodb_flush_log_at_trx_commit_basic.result

manual merge 6.0-main --> 6.0-bka-review

Show diffs side-by-side

added added

removed removed

Lines of Context:
mysql-test/r/innodb_flush_log_at_trx_commit_basic.result
 
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 flush_log_at_trx_commit value: '18446744073709551615'
 
40
SELECT @@global.innodb_flush_log_at_trx_commit;
 
41
@@global.innodb_flush_log_at_trx_commit
 
42
2
 
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
2
 
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
2
 
53
SET @@global.innodb_flush_log_at_trx_commit = 1001;
 
54
Warnings:
 
55
Warning 1292    Truncated incorrect 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
'#----------------------FN_DYNVARS_046_05------------------------#'
 
60
SELECT @@global.innodb_flush_log_at_trx_commit =
 
61
VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
 
62
WHERE VARIABLE_NAME='innodb_flush_log_at_trx_commit';
 
63
@@global.innodb_flush_log_at_trx_commit =
 
64
VARIABLE_VALUE
 
65
1
 
66
SELECT @@global.innodb_flush_log_at_trx_commit;
 
67
@@global.innodb_flush_log_at_trx_commit
 
68
2
 
69
SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
 
70
WHERE VARIABLE_NAME='innodb_flush_log_at_trx_commit';
 
71
VARIABLE_VALUE
 
72
2
 
73
'#---------------------FN_DYNVARS_046_06-------------------------#'
 
74
SET @@global.innodb_flush_log_at_trx_commit = OFF;
 
75
ERROR 42000: Incorrect argument type to variable 'innodb_flush_log_at_trx_commit'
 
76
SELECT @@global.innodb_flush_log_at_trx_commit;
 
77
@@global.innodb_flush_log_at_trx_commit
 
78
2
 
79
SET @@global.innodb_flush_log_at_trx_commit = ON;
 
80
ERROR 42000: Incorrect argument type to variable 'innodb_flush_log_at_trx_commit'
 
81
SELECT @@global.innodb_flush_log_at_trx_commit;
 
82
@@global.innodb_flush_log_at_trx_commit
 
83
2
 
84
'#---------------------FN_DYNVARS_046_07----------------------#'
 
85
SET @@global.innodb_flush_log_at_trx_commit = TRUE;
 
86
SELECT @@global.innodb_flush_log_at_trx_commit;
 
87
@@global.innodb_flush_log_at_trx_commit
 
88
1
 
89
SET @@global.innodb_flush_log_at_trx_commit = FALSE;
 
90
SELECT @@global.innodb_flush_log_at_trx_commit;
 
91
@@global.innodb_flush_log_at_trx_commit
 
92
0
 
93
SET @@global.innodb_flush_log_at_trx_commit = @global_start_value;
 
94
SELECT @@global.innodb_flush_log_at_trx_commit;
 
95
@@global.innodb_flush_log_at_trx_commit
 
96
1