1
SET @start_global_value = @@global.storage_engine;
2
SELECT @start_global_value;
5
SET @start_session_value = @@session.storage_engine;
6
SELECT @start_session_value;
9
'#--------------------FN_DYNVARS_005_01-------------------------#'
10
SET @@global.storage_engine = MYISAM;
11
SET @@global.storage_engine = DEFAULT;
12
ERROR 42000: Variable 'storage_engine' doesn't have a default value
13
SELECT @@global.storage_engine;
14
@@global.storage_engine
16
SET @@session.storage_engine = INNODB;
17
SET @@session.storage_engine = DEFAULT;
18
SELECT @@session.storage_engine;
19
@@session.storage_engine
21
'#--------------------FN_DYNVARS_005_02-------------------------#'
22
SET @@global.storage_engine = MYISAM;
23
SELECT @@global.storage_engine;
24
@@global.storage_engine
26
SET @@global.storage_engine = MERGE;
27
SELECT @@global.storage_engine;
28
@@global.storage_engine
30
SET @@global.storage_engine = MEMORY;
31
SELECT @@global.storage_engine;
32
@@global.storage_engine
34
SET @@global.storage_engine = INNODB;
35
SELECT @@global.storage_engine;
36
@@global.storage_engine
38
'#--------------------FN_DYNVARS_005_03-------------------------#'
39
SET @@session.storage_engine = MYISAM;
40
SELECT @@session.storage_engine;
41
@@session.storage_engine
43
SET @@session.storage_engine = MERGE;
44
SELECT @@session.storage_engine;
45
@@session.storage_engine
47
SET @@session.storage_engine = MEMORY;
48
SELECT @@session.storage_engine;
49
@@session.storage_engine
51
SET @@session.storage_engine = INNODB;
52
SELECT @@session.storage_engine;
53
@@session.storage_engine
55
'#------------------FN_DYNVARS_005_04-----------------------#'
56
SET @@global.storage_engine = 8199;
57
ERROR 42000: Incorrect argument type to variable 'storage_engine'
58
SET @@global.storage_engine = -1024;
59
ERROR 42000: Incorrect argument type to variable 'storage_engine'
60
SET @@global.storage_engine = 65530.34.;
61
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
62
SET @@global.storage_engine = FILE;
63
ERROR 42000: Unknown table engine 'FILE'
64
SET @@session.storage_engine = 8199;
65
ERROR 42000: Incorrect argument type to variable 'storage_engine'
66
SET @@session.storage_engine = 65530.34.;
67
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
68
SET @@session.storage_engine = RECORD;
69
ERROR 42000: Unknown table engine 'RECORD'
70
'#------------------FN_DYNVARS_005_05-----------------------#'
71
SELECT @@global.storage_engine =
72
VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
73
WHERE VARIABLE_NAME='storage_engine';
74
@@global.storage_engine =
77
'#------------------FN_DYNVARS_005_06-----------------------#'
78
SELECT @@session.storage_engine =
79
VARIABLE_VALUE FROM INFORMATION_SCHEMA.SESSION_VARIABLES
80
WHERE VARIABLE_NAME='storage_engine';
81
@@session.storage_engine =
84
'#------------------FN_DYNVARS_005_07-----------------------#'
85
SET @@global.storage_engine = TRUE;
86
ERROR 42000: Incorrect argument type to variable 'storage_engine'
87
SET @@global.storage_engine = FALSE;
88
ERROR 42000: Incorrect argument type to variable 'storage_engine'
89
'#---------------------FN_DYNVARS_001_8----------------------#'
90
SET @@storage_engine = MYISAM;
91
SELECT @@storage_engine = @@local.storage_engine;
92
@@storage_engine = @@local.storage_engine
94
SELECT @@local.storage_engine = @@session.storage_engine;
95
@@local.storage_engine = @@session.storage_engine
97
'#---------------------FN_DYNVARS_001_9----------------------#'
98
SET storage_engine = MEMORY;
99
SELECT @@storage_engine;
102
SELECT local.storage_engine;
103
ERROR 42S02: Unknown table 'local' in field list
104
SELECT session.storage_engine;
105
ERROR 42S02: Unknown table 'session' in field list
106
SELECT storage_engine = @@session.storage_engine;
107
ERROR 42S22: Unknown column 'storage_engine' in 'field list'
108
SET @@global.storage_engine = @start_global_value;
109
SELECT @@global.storage_engine;
110
@@global.storage_engine
112
SET @@session.storage_engine = @start_session_value;
113
SELECT @@session.storage_engine;
114
@@session.storage_engine