1
SET @start_global_value = @@global.default_storage_engine;
2
SELECT @start_global_value;
5
SET @start_session_value = @@session.default_storage_engine;
6
SELECT @start_session_value;
9
'#--------------------FN_DYNVARS_005_01-------------------------#'
10
SET @@global.default_storage_engine = INNODB;
11
SET @@global.default_storage_engine = DEFAULT;
12
SELECT @@global.default_storage_engine;
13
@@global.default_storage_engine
15
SET @@session.default_storage_engine = INNODB;
16
SET @@session.default_storage_engine = DEFAULT;
17
SELECT @@session.default_storage_engine;
18
@@session.default_storage_engine
20
'#--------------------FN_DYNVARS_005_02-------------------------#'
21
SET @@global.default_storage_engine = MYISAM;
22
SELECT @@global.default_storage_engine;
23
@@global.default_storage_engine
25
SET @@global.default_storage_engine = MERGE;
26
SELECT @@global.default_storage_engine;
27
@@global.default_storage_engine
29
SET @@global.default_storage_engine = MEMORY;
30
SELECT @@global.default_storage_engine;
31
@@global.default_storage_engine
33
SET @@global.default_storage_engine = INNODB;
34
SELECT @@global.default_storage_engine;
35
@@global.default_storage_engine
37
'#--------------------FN_DYNVARS_005_03-------------------------#'
38
SET @@session.default_storage_engine = MYISAM;
39
SELECT @@session.default_storage_engine;
40
@@session.default_storage_engine
42
SET @@session.default_storage_engine = MERGE;
43
SELECT @@session.default_storage_engine;
44
@@session.default_storage_engine
46
SET @@session.default_storage_engine = MEMORY;
47
SELECT @@session.default_storage_engine;
48
@@session.default_storage_engine
50
SET @@session.default_storage_engine = INNODB;
51
SELECT @@session.default_storage_engine;
52
@@session.default_storage_engine
54
'#------------------FN_DYNVARS_005_04-----------------------#'
55
SET @@global.default_storage_engine = 8199;
56
ERROR 42000: Incorrect argument type to variable 'default_storage_engine'
57
SET @@global.default_storage_engine = NULL;
58
ERROR 42000: Variable 'default_storage_engine' can't be set to the value of 'NULL'
59
SET @@global.default_storage_engine = -1024;
60
ERROR 42000: Incorrect argument type to variable 'default_storage_engine'
61
SET @@global.default_storage_engine = 65530.34;
62
ERROR 42000: Incorrect argument type to variable 'default_storage_engine'
63
SET @@global.default_storage_engine = FILE;
64
ERROR 42000: Unknown storage engine 'FILE'
65
SET @@session.default_storage_engine = 8199;
66
ERROR 42000: Incorrect argument type to variable 'default_storage_engine'
67
SET @@session.default_storage_engine = 65530.34;
68
ERROR 42000: Incorrect argument type to variable 'default_storage_engine'
69
SET @@session.default_storage_engine = RECORD;
70
ERROR 42000: Unknown storage engine 'RECORD'
71
'#------------------FN_DYNVARS_005_05-----------------------#'
72
SELECT @@global.default_storage_engine =
73
VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
74
WHERE VARIABLE_NAME='default_storage_engine';
75
@@global.default_storage_engine =
78
'#------------------FN_DYNVARS_005_06-----------------------#'
79
SELECT @@session.default_storage_engine =
80
VARIABLE_VALUE FROM INFORMATION_SCHEMA.SESSION_VARIABLES
81
WHERE VARIABLE_NAME='default_storage_engine';
82
@@session.default_storage_engine =
85
'#------------------FN_DYNVARS_005_07-----------------------#'
86
SET @@global.default_storage_engine = TRUE;
87
ERROR 42000: Incorrect argument type to variable 'default_storage_engine'
88
SET @@global.default_storage_engine = FALSE;
89
ERROR 42000: Incorrect argument type to variable 'default_storage_engine'
90
'#---------------------FN_DYNVARS_001_8----------------------#'
91
SET @@default_storage_engine = MYISAM;
92
SELECT @@default_storage_engine = @@local.default_storage_engine;
93
@@default_storage_engine = @@local.default_storage_engine
95
SELECT @@local.default_storage_engine = @@session.default_storage_engine;
96
@@local.default_storage_engine = @@session.default_storage_engine
98
'#---------------------FN_DYNVARS_001_9----------------------#'
99
SET default_storage_engine = MEMORY;
100
SELECT @@default_storage_engine;
101
@@default_storage_engine
103
SELECT local.default_storage_engine;
104
ERROR 42S02: Unknown table 'local' in field list
105
SELECT session.default_storage_engine;
106
ERROR 42S02: Unknown table 'session' in field list
107
SELECT default_storage_engine = @@session.default_storage_engine;
108
ERROR 42S22: Unknown column 'default_storage_engine' in 'field list'
109
SET @@default_storage_engine = @start_global_value;
110
SET @@global.default_storage_engine = @start_global_value;
111
SELECT @@global.default_storage_engine;
112
@@global.default_storage_engine
114
SET @@session.default_storage_engine = @start_session_value;
115
SELECT @@session.default_storage_engine;
116
@@session.default_storage_engine