Debian Codegraph @

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

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