Debian Codegraph @

mysql-test/suite/sys_vars/r/default_storage_engine_basic_myisam.result

raw
1 SET @start_global_value = @@global.default_storage_engine;
2 SELECT @start_global_value;
3 @start_global_value
4 MyISAM
5 SET @start_session_value = @@session.default_storage_engine;
6 SELECT @start_session_value;
7 @start_session_value
8 MyISAM
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
14 MyISAM
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
19 MyISAM
20 '#--------------------FN_DYNVARS_005_02-------------------------#'
21 SET @@global.default_storage_engine = MYISAM;
22 SELECT @@global.default_storage_engine;
23 @@global.default_storage_engine
24 MyISAM
25 '#--------------------FN_DYNVARS_005_03-------------------------#'
26 SET @@session.default_storage_engine = MYISAM;
27 SELECT @@session.default_storage_engine;
28 @@session.default_storage_engine
29 MyISAM
30 '#---------------------FN_DYNVARS_001_8----------------------#'
31 SET @@default_storage_engine = MYISAM;
32 SELECT @@default_storage_engine = @@local.default_storage_engine;
33 @@default_storage_engine = @@local.default_storage_engine
34 1
35 SELECT @@local.default_storage_engine = @@session.default_storage_engine;
36 @@local.default_storage_engine = @@session.default_storage_engine
37 1
38 SET @@default_storage_engine = @start_global_value;
39 SET @@global.default_storage_engine = @start_global_value;
40 SELECT @@global.default_storage_engine;
41 @@global.default_storage_engine
42 MyISAM
43 SET @@session.default_storage_engine = @start_session_value;
44 SELECT @@session.default_storage_engine;
45 @@session.default_storage_engine
46 MyISAM