1
SET @start_global_value = @@global.keep_files_on_create;
2
SELECT @start_global_value;
5
SET @start_session_value = @@session.keep_files_on_create;
6
SELECT @start_session_value;
9
'#--------------------FN_DYNVARS_054_01-------------------------#'
10
SET @@global.keep_files_on_create = ON;
11
SET @@global.keep_files_on_create = DEFAULT;
12
SELECT @@global.keep_files_on_create;
13
@@global.keep_files_on_create
15
SET @@session.keep_files_on_create = ON;
16
SET @@session.keep_files_on_create = DEFAULT;
17
SELECT @@session.keep_files_on_create;
18
@@session.keep_files_on_create
20
'#--------------------FN_DYNVARS_054_02-------------------------#'
21
SET @@global.keep_files_on_create = DEFAULT;
22
SELECT @@global.keep_files_on_create = 'OFF';
23
@@global.keep_files_on_create = 'OFF'
26
Warning 1292 Truncated incorrect DOUBLE value: 'OFF'
27
SET @@session.keep_files_on_create = DEFAULT;
28
SELECT @@session.keep_files_on_create = 'OFF';
29
@@session.keep_files_on_create = 'OFF'
32
Warning 1292 Truncated incorrect DOUBLE value: 'OFF'
33
'#--------------------FN_DYNVARS_054_03-------------------------#'
34
SET @@global.keep_files_on_create = ON;
35
SELECT @@global.keep_files_on_create;
36
@@global.keep_files_on_create
38
SET @@global.keep_files_on_create = OFF;
39
SELECT @@global.keep_files_on_create;
40
@@global.keep_files_on_create
42
SET @@global.keep_files_on_create = 0;
43
SELECT @@global.keep_files_on_create;
44
@@global.keep_files_on_create
46
SET @@global.keep_files_on_create = 1;
47
SELECT @@global.keep_files_on_create;
48
@@global.keep_files_on_create
50
SET @@global.keep_files_on_create = TRUE;
51
SELECT @@global.keep_files_on_create;
52
@@global.keep_files_on_create
54
SET @@global.keep_files_on_create = FALSE;
55
SELECT @@global.keep_files_on_create;
56
@@global.keep_files_on_create
58
'#--------------------FN_DYNVARS_054_04-------------------------#'
59
SET @@session.keep_files_on_create = ON;
60
SELECT @@session.keep_files_on_create;
61
@@session.keep_files_on_create
63
SET @@session.keep_files_on_create = OFF;
64
SELECT @@session.keep_files_on_create;
65
@@session.keep_files_on_create
67
SET @@session.keep_files_on_create = 0;
68
SELECT @@session.keep_files_on_create;
69
@@session.keep_files_on_create
71
SET @@session.keep_files_on_create = 1;
72
SELECT @@session.keep_files_on_create;
73
@@session.keep_files_on_create
75
SET @@session.keep_files_on_create = TRUE;
76
SELECT @@session.keep_files_on_create;
77
@@session.keep_files_on_create
79
SET @@session.keep_files_on_create = FALSE;
80
SELECT @@session.keep_files_on_create;
81
@@session.keep_files_on_create
83
'#------------------FN_DYNVARS_054_05-----------------------#'
84
SET @@global.keep_files_on_create = 'ONN';
85
ERROR 42000: Variable 'keep_files_on_create' can't be set to the value of 'ONN'
86
SET @@global.keep_files_on_create = "OFFF";
87
ERROR 42000: Variable 'keep_files_on_create' can't be set to the value of 'OFFF'
88
SET @@global.keep_files_on_create = TTRUE;
89
ERROR 42000: Variable 'keep_files_on_create' can't be set to the value of 'TTRUE'
90
SET @@global.keep_files_on_create = FELSE;
91
ERROR 42000: Variable 'keep_files_on_create' can't be set to the value of 'FELSE'
92
SET @@global.keep_files_on_create = -1024;
93
ERROR 42000: Variable 'keep_files_on_create' can't be set to the value of '-1024'
94
SET @@global.keep_files_on_create = 65536;
95
ERROR 42000: Variable 'keep_files_on_create' can't be set to the value of '65536'
96
SET @@global.keep_files_on_create = 65530.34;
97
ERROR 42000: Variable 'keep_files_on_create' can't be set to the value of '65530'
98
SET @@global.keep_files_on_create = test;
99
ERROR 42000: Variable 'keep_files_on_create' can't be set to the value of 'test'
100
SET @@session.keep_files_on_create = ONN;
101
ERROR 42000: Variable 'keep_files_on_create' can't be set to the value of 'ONN'
102
SET @@session.keep_files_on_create = ONF;
103
ERROR 42000: Variable 'keep_files_on_create' can't be set to the value of 'ONF'
104
SET @@session.keep_files_on_create = OF;
105
SELECT @@session.keep_files_on_create;
106
@@session.keep_files_on_create
108
'Bug# 34828: FN_DYNVARS_054_05 - OF is also working as OFF and no error is coming';
109
SET @@session.keep_files_on_create = 'OFN';
110
ERROR 42000: Variable 'keep_files_on_create' can't be set to the value of 'OFN'
111
SET @@session.keep_files_on_create = -2;
112
ERROR 42000: Variable 'keep_files_on_create' can't be set to the value of '-2'
113
SET @@session.keep_files_on_create = 65530.34.;
114
ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '.' at line 1
115
SET @@session.keep_files_on_create = 65550;
116
ERROR 42000: Variable 'keep_files_on_create' can't be set to the value of '65550'
117
SET @@session.keep_files_on_create = test;
118
ERROR 42000: Variable 'keep_files_on_create' can't be set to the value of 'test'
119
SELECT @@session.keep_files_on_create;
120
@@session.keep_files_on_create
122
'#------------------FN_DYNVARS_054_06-----------------------#'
123
SELECT @@global.keep_files_on_create = VARIABLE_VALUE
124
FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
125
WHERE VARIABLE_NAME='keep_files_on_create';
126
@@global.keep_files_on_create = VARIABLE_VALUE
128
'#------------------FN_DYNVARS_054_07-----------------------#'
129
SELECT @@session.keep_files_on_create = VARIABLE_VALUE
130
FROM INFORMATION_SCHEMA.SESSION_VARIABLES
131
WHERE VARIABLE_NAME='keep_files_on_create';
132
@@session.keep_files_on_create = VARIABLE_VALUE
134
'#---------------------FN_DYNVARS_001_08----------------------#'
135
SET @@keep_files_on_create = OFF;
136
SET @@global.keep_files_on_create = ON;
137
SELECT @@keep_files_on_create = @@global.keep_files_on_create;
138
@@keep_files_on_create = @@global.keep_files_on_create
140
'#---------------------FN_DYNVARS_001_09----------------------#'
141
SET @@keep_files_on_create = ON;
142
SELECT @@keep_files_on_create = @@local.keep_files_on_create;
143
@@keep_files_on_create = @@local.keep_files_on_create
145
SELECT @@local.keep_files_on_create = @@session.keep_files_on_create;
146
@@local.keep_files_on_create = @@session.keep_files_on_create
148
'#---------------------FN_DYNVARS_001_10----------------------#'
149
SET keep_files_on_create = 1;
150
SELECT @@keep_files_on_create;
151
@@keep_files_on_create
153
SELECT local.keep_files_on_create;
154
ERROR 42S02: Unknown table 'local' in field list
155
SELECT session.keep_files_on_create;
156
ERROR 42S02: Unknown table 'session' in field list
157
SELECT keep_files_on_create = @@session.keep_files_on_create;
158
ERROR 42S22: Unknown column 'keep_files_on_create' in 'field list'
159
SET @@global.keep_files_on_create = @start_global_value;
160
SELECT @@global.keep_files_on_create;
161
@@global.keep_files_on_create
163
SET @@session.keep_files_on_create = @start_session_value;
164
SELECT @@session.keep_files_on_create;
165
@@session.keep_files_on_create