Debian Codegraph @

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

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