1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
|
SET @start_global_value = @@global.storage_engine;
SET @start_session_value = @@session.storage_engine;
'#--------------------FN_DYNVARS_005_01-------------------------#'
SET @@global.storage_engine = INNODB;
Warnings:
Warning 1287 '@@storage_engine' is deprecated and will be removed in a future release. Please use '@@default_storage_engine' instead
SET @@global.storage_engine = DEFAULT;
Warnings:
Warning 1287 '@@storage_engine' is deprecated and will be removed in a future release. Please use '@@default_storage_engine' instead
SELECT @@global.storage_engine;
@@global.storage_engine
InnoDB
SET @@session.storage_engine = INNODB;
Warnings:
Warning 1287 '@@storage_engine' is deprecated and will be removed in a future release. Please use '@@default_storage_engine' instead
SET @@session.storage_engine = DEFAULT;
Warnings:
Warning 1287 '@@storage_engine' is deprecated and will be removed in a future release. Please use '@@default_storage_engine' instead
SELECT @@session.storage_engine;
@@session.storage_engine
InnoDB
'#--------------------FN_DYNVARS_005_02-------------------------#'
SET @@global.storage_engine = MYISAM;
Warnings:
Warning 1287 '@@storage_engine' is deprecated and will be removed in a future release. Please use '@@default_storage_engine' instead
SELECT @@global.storage_engine;
@@global.storage_engine
MyISAM
SET @@global.storage_engine = MERGE;
Warnings:
Warning 1287 '@@storage_engine' is deprecated and will be removed in a future release. Please use '@@default_storage_engine' instead
SELECT @@global.storage_engine;
@@global.storage_engine
MRG_MyISAM
SET @@global.storage_engine = MEMORY;
Warnings:
Warning 1287 '@@storage_engine' is deprecated and will be removed in a future release. Please use '@@default_storage_engine' instead
SELECT @@global.storage_engine;
@@global.storage_engine
MEMORY
SET @@global.storage_engine = INNODB;
Warnings:
Warning 1287 '@@storage_engine' is deprecated and will be removed in a future release. Please use '@@default_storage_engine' instead
SELECT @@global.storage_engine;
@@global.storage_engine
InnoDB
'#--------------------FN_DYNVARS_005_03-------------------------#'
SET @@session.storage_engine = MYISAM;
Warnings:
Warning 1287 '@@storage_engine' is deprecated and will be removed in a future release. Please use '@@default_storage_engine' instead
SELECT @@session.storage_engine;
@@session.storage_engine
MyISAM
SET @@session.storage_engine = MERGE;
Warnings:
Warning 1287 '@@storage_engine' is deprecated and will be removed in a future release. Please use '@@default_storage_engine' instead
SELECT @@session.storage_engine;
@@session.storage_engine
MRG_MyISAM
SET @@session.storage_engine = MEMORY;
Warnings:
Warning 1287 '@@storage_engine' is deprecated and will be removed in a future release. Please use '@@default_storage_engine' instead
SELECT @@session.storage_engine;
@@session.storage_engine
MEMORY
SET @@session.storage_engine = INNODB;
Warnings:
Warning 1287 '@@storage_engine' is deprecated and will be removed in a future release. Please use '@@default_storage_engine' instead
SELECT @@session.storage_engine;
@@session.storage_engine
InnoDB
'#------------------FN_DYNVARS_005_04-----------------------#'
SET @@global.storage_engine = 8199;
ERROR 42000: Incorrect argument type to variable 'storage_engine'
SET @@global.storage_engine = NULL;
ERROR 42000: Variable 'storage_engine' can't be set to the value of 'NULL'
SET @@global.storage_engine = -1024;
ERROR 42000: Incorrect argument type to variable 'storage_engine'
SET @@global.storage_engine = 65530.34;
ERROR 42000: Incorrect argument type to variable 'storage_engine'
SET @@global.storage_engine = FILE;
ERROR 42000: Unknown storage engine 'FILE'
SET @@session.storage_engine = 8199;
ERROR 42000: Incorrect argument type to variable 'storage_engine'
SET @@session.storage_engine = 65530.34;
ERROR 42000: Incorrect argument type to variable 'storage_engine'
SET @@session.storage_engine = RECORD;
ERROR 42000: Unknown storage engine 'RECORD'
'#------------------FN_DYNVARS_005_05-----------------------#'
SELECT @@global.storage_engine =
VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
WHERE VARIABLE_NAME='storage_engine';
@@global.storage_engine =
VARIABLE_VALUE
1
'#------------------FN_DYNVARS_005_06-----------------------#'
SELECT @@session.storage_engine =
VARIABLE_VALUE FROM INFORMATION_SCHEMA.SESSION_VARIABLES
WHERE VARIABLE_NAME='storage_engine';
@@session.storage_engine =
VARIABLE_VALUE
1
'#------------------FN_DYNVARS_005_07-----------------------#'
SET @@global.storage_engine = TRUE;
ERROR 42000: Incorrect argument type to variable 'storage_engine'
SET @@global.storage_engine = FALSE;
ERROR 42000: Incorrect argument type to variable 'storage_engine'
'#---------------------FN_DYNVARS_001_8----------------------#'
SET @@storage_engine = MYISAM;
Warnings:
Warning 1287 '@@storage_engine' is deprecated and will be removed in a future release. Please use '@@default_storage_engine' instead
SELECT @@storage_engine = @@local.storage_engine;
@@storage_engine = @@local.storage_engine
1
SELECT @@local.storage_engine = @@session.storage_engine;
@@local.storage_engine = @@session.storage_engine
1
'#---------------------FN_DYNVARS_001_9----------------------#'
SET storage_engine = MEMORY;
Warnings:
Warning 1287 '@@storage_engine' is deprecated and will be removed in a future release. Please use '@@default_storage_engine' instead
SELECT @@storage_engine;
@@storage_engine
MEMORY
SELECT local.storage_engine;
ERROR 42S02: Unknown table 'local' in SELECT
SELECT session.storage_engine;
ERROR 42S02: Unknown table 'session' in SELECT
SELECT storage_engine = @@session.storage_engine;
ERROR 42S22: Unknown column 'storage_engine' in 'SELECT'
SET @@storage_engine = @start_global_value;
Warnings:
Warning 1287 '@@storage_engine' is deprecated and will be removed in a future release. Please use '@@default_storage_engine' instead
SET @@global.storage_engine = @start_global_value;
Warnings:
Warning 1287 '@@storage_engine' is deprecated and will be removed in a future release. Please use '@@default_storage_engine' instead
SET @@session.storage_engine = @start_session_value;
Warnings:
Warning 1287 '@@storage_engine' is deprecated and will be removed in a future release. Please use '@@default_storage_engine' instead
|
