← Back to branch summary

~jlukas79/+junk/mysql-server

« back to all changes in this revision

Viewing changes to mysql-test/r/innodb_fast_shutdown_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_fast_shutdown_basic.result
 
1
SET @global_start_value = @@global.innodb_fast_shutdown;
 
2
SELECT @@global.innodb_fast_shutdown;
 
3
@@global.innodb_fast_shutdown
 
4
1
 
5
'#--------------------FN_DYNVARS_042_01------------------------#'
 
6
SET @@global.innodb_fast_shutdown = 0;
 
7
SET @@global.innodb_fast_shutdown = DEFAULT;
 
8
SELECT @@global.innodb_fast_shutdown;
 
9
@@global.innodb_fast_shutdown
 
10
1
 
11
'#---------------------FN_DYNVARS_042_02-------------------------#'
 
12
SET innodb_fast_shutdown = 1;
 
13
ERROR HY000: Variable 'innodb_fast_shutdown' is a GLOBAL variable and should be set with SET GLOBAL
 
14
SELECT @@innodb_fast_shutdown;
 
15
@@innodb_fast_shutdown
 
16
1
 
17
SELECT global.innodb_fast_shutdown;
 
18
ERROR 42S02: Unknown table 'global' in field list
 
19
SET global innodb_fast_shutdown = 1;
 
20
SELECT @@global.innodb_fast_shutdown;
 
21
@@global.innodb_fast_shutdown
 
22
1
 
23
'#--------------------FN_DYNVARS_042_03------------------------#'
 
24
SET @@global.innodb_fast_shutdown = 0;
 
25
SELECT @@global.innodb_fast_shutdown;
 
26
@@global.innodb_fast_shutdown
 
27
0
 
28
SET @@global.innodb_fast_shutdown = 1;
 
29
SELECT @@global.innodb_fast_shutdown;
 
30
@@global.innodb_fast_shutdown
 
31
1
 
32
SET @@global.innodb_fast_shutdown = 2;
 
33
SELECT @@global.innodb_fast_shutdown;
 
34
@@global.innodb_fast_shutdown
 
35
2
 
36
'#--------------------FN_DYNVARS_042_04-------------------------#'
 
37
SET @@global.innodb_fast_shutdown = -1;
 
38
Warnings:
 
39
Warning 1292    Truncated incorrect fast_shutdown value: '18446744073709551615'
 
40
SELECT @@global.innodb_fast_shutdown;
 
41
@@global.innodb_fast_shutdown
 
42
2
 
43
SET @@global.innodb_fast_shutdown = TRU;
 
44
ERROR 42000: Incorrect argument type to variable 'innodb_fast_shutdown'
 
45
SELECT @@global.innodb_fast_shutdown;
 
46
@@global.innodb_fast_shutdown
 
47
2
 
48
SET @@global.innodb_fast_shutdown = TRUE_F;
 
49
ERROR 42000: Incorrect argument type to variable 'innodb_fast_shutdown'
 
50
SELECT @@global.innodb_fast_shutdown;
 
51
@@global.innodb_fast_shutdown
 
52
2
 
53
SET @@global.innodb_fast_shutdown = FALS;
 
54
ERROR 42000: Incorrect argument type to variable 'innodb_fast_shutdown'
 
55
SELECT @@global.innodb_fast_shutdown;
 
56
@@global.innodb_fast_shutdown
 
57
2
 
58
SET @@global.innodb_fast_shutdown = OON;
 
59
ERROR 42000: Incorrect argument type to variable 'innodb_fast_shutdown'
 
60
SELECT @@global.innodb_fast_shutdown;
 
61
@@global.innodb_fast_shutdown
 
62
2
 
63
SET @@global.innodb_fast_shutdown = ONN;
 
64
ERROR 42000: Incorrect argument type to variable 'innodb_fast_shutdown'
 
65
SELECT @@global.innodb_fast_shutdown;
 
66
@@global.innodb_fast_shutdown
 
67
2
 
68
SET @@global.innodb_fast_shutdown = OOFF;
 
69
ERROR 42000: Incorrect argument type to variable 'innodb_fast_shutdown'
 
70
SELECT @@global.innodb_fast_shutdown;
 
71
@@global.innodb_fast_shutdown
 
72
2
 
73
SET @@global.innodb_fast_shutdown = 0FF;
 
74
ERROR 42000: Incorrect argument type to variable 'innodb_fast_shutdown'
 
75
SELECT @@global.innodb_fast_shutdown;
 
76
@@global.innodb_fast_shutdown
 
77
2
 
78
SET @@global.innodb_fast_shutdown = '1';
 
79
ERROR 42000: Incorrect argument type to variable 'innodb_fast_shutdown'
 
80
SELECT @@global.innodb_fast_shutdown;
 
81
@@global.innodb_fast_shutdown
 
82
2
 
83
SET @@global.innodb_fast_shutdown = "0";
 
84
ERROR 42000: Incorrect argument type to variable 'innodb_fast_shutdown'
 
85
SELECT @@global.innodb_fast_shutdown;
 
86
@@global.innodb_fast_shutdown
 
87
2
 
88
'#-------------------FN_DYNVARS_042_05----------------------------#'
 
89
SET @@session.innodb_fast_shutdown = 0;
 
90
ERROR HY000: Variable 'innodb_fast_shutdown' is a GLOBAL variable and should be set with SET GLOBAL
 
91
SET @@innodb_fast_shutdown = 0;
 
92
ERROR HY000: Variable 'innodb_fast_shutdown' is a GLOBAL variable and should be set with SET GLOBAL
 
93
SET @@local.innodb_fast_shutdown = 0;
 
94
ERROR HY000: Variable 'innodb_fast_shutdown' is a GLOBAL variable and should be set with SET GLOBAL
 
95
'#----------------------FN_DYNVARS_042_06------------------------#'
 
96
SELECT count(VARIABLE_VALUE) AS res_is_0 
 
97
FROM INFORMATION_SCHEMA.SESSION_VARIABLES 
 
98
WHERE VARIABLE_NAME='innodb_fast_shutdown';
 
99
res_is_0
 
100
1
 
101
'#----------------------FN_DYNVARS_042_07------------------------#'
 
102
SELECT @@global.innodb_fast_shutdown =
 
103
VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 
 
104
WHERE VARIABLE_NAME='innodb_fast_shutdown';
 
105
@@global.innodb_fast_shutdown =
 
106
VARIABLE_VALUE
 
107
1
 
108
'#---------------------FN_DYNVARS_042_08-------------------------#'
 
109
SET @@global.innodb_fast_shutdown = OFF;
 
110
ERROR 42000: Incorrect argument type to variable 'innodb_fast_shutdown'
 
111
SELECT @@global.innodb_fast_shutdown;
 
112
@@global.innodb_fast_shutdown
 
113
2
 
114
SET @@global.innodb_fast_shutdown = ON;
 
115
ERROR 42000: Incorrect argument type to variable 'innodb_fast_shutdown'
 
116
SELECT @@global.innodb_fast_shutdown;
 
117
@@global.innodb_fast_shutdown
 
118
2
 
119
'#---------------------FN_DYNVARS_042_09----------------------#'
 
120
SET @@global.innodb_fast_shutdown = TRUE;
 
121
SELECT @@global.innodb_fast_shutdown;
 
122
@@global.innodb_fast_shutdown
 
123
1
 
124
SET @@global.innodb_fast_shutdown = FALSE;
 
125
SELECT @@global.innodb_fast_shutdown;
 
126
@@global.innodb_fast_shutdown
 
127
0