Debian Codegraph @

mysql-test/suite/perfschema/r/dml_handler.result

raw
1
2 # Create a temporary table of performance schema table names
3
4 CREATE TEMPORARY TABLE table_list (id INT AUTO_INCREMENT, PRIMARY KEY (id)) AS
5 SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES
6 WHERE TABLE_SCHEMA='performance_schema' ORDER BY TABLE_NAME;
7 SELECT COUNT(*) FROM table_list INTO @table_count;
8
9 # For each table in the performance schema, attempt HANDLER...OPEN,
10 # which should fail with an error 1031, ER_ILLEGAL_HA.
11
12 SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=111;
13 HANDLER performance_schema.variables_info OPEN;
14 ERROR HY000: Table storage engine for 'variables_info' doesn't have this option
15 SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=110;
16 HANDLER performance_schema.variables_by_thread OPEN;
17 ERROR HY000: Table storage engine for 'variables_by_thread' doesn't have this option
18 SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=109;
19 HANDLER performance_schema.users OPEN;
20 ERROR HY000: Table storage engine for 'users' doesn't have this option
21 SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=108;
22 HANDLER performance_schema.user_variables_by_thread OPEN;
23 ERROR HY000: Table storage engine for 'user_variables_by_thread' doesn't have this option
24 SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=107;
25 HANDLER performance_schema.user_defined_functions OPEN;
26 ERROR HY000: Table storage engine for 'user_defined_functions' doesn't have this option
27 SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=106;
28 HANDLER performance_schema.tls_channel_status OPEN;
29 ERROR HY000: Table storage engine for 'tls_channel_status' doesn't have this option
30 SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=105;
31 HANDLER performance_schema.threads OPEN;
32 ERROR HY000: Table storage engine for 'threads' doesn't have this option
33 SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=104;
34 HANDLER performance_schema.table_lock_waits_summary_by_table OPEN;
35 ERROR HY000: Table storage engine for 'table_lock_waits_summary_by_table' doesn't have this option
36 SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=103;
37 HANDLER performance_schema.table_io_waits_summary_by_table OPEN;
38 ERROR HY000: Table storage engine for 'table_io_waits_summary_by_table' doesn't have this option
39 SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=102;
40 HANDLER performance_schema.table_io_waits_summary_by_index_usage OPEN;
41 ERROR HY000: Table storage engine for 'table_io_waits_summary_by_index_usage' doesn't have this option
42 SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=101;
43 HANDLER performance_schema.table_handles OPEN;
44 ERROR HY000: Table storage engine for 'table_handles' doesn't have this option
45 SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=100;
46 HANDLER performance_schema.status_by_user OPEN;
47 ERROR HY000: Table storage engine for 'status_by_user' doesn't have this option
48 SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=99;
49 HANDLER performance_schema.status_by_thread OPEN;
50 ERROR HY000: Table storage engine for 'status_by_thread' doesn't have this option
51 SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=98;
52 HANDLER performance_schema.status_by_host OPEN;
53 ERROR HY000: Table storage engine for 'status_by_host' doesn't have this option
54 SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=97;
55 HANDLER performance_schema.status_by_account OPEN;
56 ERROR HY000: Table storage engine for 'status_by_account' doesn't have this option
57 SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=96;
58 HANDLER performance_schema.socket_summary_by_instance OPEN;
59 ERROR HY000: Table storage engine for 'socket_summary_by_instance' doesn't have this option
60 SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=95;
61 HANDLER performance_schema.socket_summary_by_event_name OPEN;
62 ERROR HY000: Table storage engine for 'socket_summary_by_event_name' doesn't have this option
63 SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=94;
64 HANDLER performance_schema.socket_instances OPEN;
65 ERROR HY000: Table storage engine for 'socket_instances' doesn't have this option
66 SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=93;
67 HANDLER performance_schema.setup_threads OPEN;
68 ERROR HY000: Table storage engine for 'setup_threads' doesn't have this option
69 SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=92;
70 HANDLER performance_schema.setup_objects OPEN;
71 ERROR HY000: Table storage engine for 'setup_objects' doesn't have this option
72 SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=91;
73 HANDLER performance_schema.setup_instruments OPEN;
74 ERROR HY000: Table storage engine for 'setup_instruments' doesn't have this option
75 SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=90;
76 HANDLER performance_schema.setup_consumers OPEN;
77 ERROR HY000: Table storage engine for 'setup_consumers' doesn't have this option
78 SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=89;
79 HANDLER performance_schema.setup_actors OPEN;
80 ERROR HY000: Table storage engine for 'setup_actors' doesn't have this option
81 SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=88;
82 HANDLER performance_schema.session_variables OPEN;
83 ERROR HY000: Table storage engine for 'session_variables' doesn't have this option
84 SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=87;
85 HANDLER performance_schema.session_status OPEN;
86 ERROR HY000: Table storage engine for 'session_status' doesn't have this option
87 SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=86;
88 HANDLER performance_schema.session_connect_attrs OPEN;
89 ERROR HY000: Table storage engine for 'session_connect_attrs' doesn't have this option
90 SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=85;
91 HANDLER performance_schema.session_account_connect_attrs OPEN;
92 ERROR HY000: Table storage engine for 'session_account_connect_attrs' doesn't have this option
93 SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=84;
94 HANDLER performance_schema.rwlock_instances OPEN;
95 ERROR HY000: Table storage engine for 'rwlock_instances' doesn't have this option
96 SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=83;
97 HANDLER performance_schema.replication_group_members OPEN;
98 ERROR HY000: Table storage engine for 'replication_group_members' doesn't have this option
99 SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=82;
100 HANDLER performance_schema.replication_group_member_stats OPEN;
101 ERROR HY000: Table storage engine for 'replication_group_member_stats' doesn't have this option
102 SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=81;
103 HANDLER performance_schema.replication_connection_status OPEN;
104 ERROR HY000: Table storage engine for 'replication_connection_status' doesn't have this option
105 SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=80;
106 HANDLER performance_schema.replication_connection_configuration OPEN;
107 ERROR HY000: Table storage engine for 'replication_connection_configuration' doesn't have this option
108 SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=79;
109 HANDLER performance_schema.replication_asynchronous_connection_failover_managed OPEN;
110 ERROR HY000: Table storage engine for 'replication_asynchronous_connection_failover_managed' doesn't have this option
111 SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=78;
112 HANDLER performance_schema.replication_asynchronous_connection_failover OPEN;
113 ERROR HY000: Table storage engine for 'replication_asynchronous_connection_failover' doesn't have this option
114 SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=77;
115 HANDLER performance_schema.replication_applier_status_by_worker OPEN;
116 ERROR HY000: Table storage engine for 'replication_applier_status_by_worker' doesn't have this option
117 SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=76;
118 HANDLER performance_schema.replication_applier_status_by_coordinator OPEN;
119 ERROR HY000: Table storage engine for 'replication_applier_status_by_coordinator' doesn't have this option
120 SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=75;
121 HANDLER performance_schema.replication_applier_status OPEN;
122 ERROR HY000: Table storage engine for 'replication_applier_status' doesn't have this option
123 SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=74;
124 HANDLER performance_schema.replication_applier_global_filters OPEN;
125 ERROR HY000: Table storage engine for 'replication_applier_global_filters' doesn't have this option
126 SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=73;
127 HANDLER performance_schema.replication_applier_filters OPEN;
128 ERROR HY000: Table storage engine for 'replication_applier_filters' doesn't have this option
129 SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=72;
130 HANDLER performance_schema.replication_applier_configuration OPEN;
131 ERROR HY000: Table storage engine for 'replication_applier_configuration' doesn't have this option
132 SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=71;
133 HANDLER performance_schema.processlist OPEN;
134 ERROR HY000: Table storage engine for 'processlist' doesn't have this option
135 SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=70;
136 HANDLER performance_schema.prepared_statements_instances OPEN;
137 ERROR HY000: Table storage engine for 'prepared_statements_instances' doesn't have this option
138 SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=69;
139 HANDLER performance_schema.persisted_variables OPEN;
140 ERROR HY000: Table storage engine for 'persisted_variables' doesn't have this option
141 SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=68;
142 HANDLER performance_schema.performance_timers OPEN;
143 ERROR HY000: Table storage engine for 'performance_timers' doesn't have this option
144 SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=67;
145 HANDLER performance_schema.objects_summary_global_by_type OPEN;
146 ERROR HY000: Table storage engine for 'objects_summary_global_by_type' doesn't have this option
147 SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=66;
148 HANDLER performance_schema.mutex_instances OPEN;
149 ERROR HY000: Table storage engine for 'mutex_instances' doesn't have this option
150 SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=65;
151 HANDLER performance_schema.metadata_locks OPEN;
152 ERROR HY000: Table storage engine for 'metadata_locks' doesn't have this option
153 SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=64;
154 HANDLER performance_schema.memory_summary_global_by_event_name OPEN;
155 ERROR HY000: Table storage engine for 'memory_summary_global_by_event_name' doesn't have this option
156 SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=63;
157 HANDLER performance_schema.memory_summary_by_user_by_event_name OPEN;
158 ERROR HY000: Table storage engine for 'memory_summary_by_user_by_event_name' doesn't have this option
159 SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=62;
160 HANDLER performance_schema.memory_summary_by_thread_by_event_name OPEN;
161 ERROR HY000: Table storage engine for 'memory_summary_by_thread_by_event_name' doesn't have this option
162 SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=61;
163 HANDLER performance_schema.memory_summary_by_host_by_event_name OPEN;
164 ERROR HY000: Table storage engine for 'memory_summary_by_host_by_event_name' doesn't have this option
165 SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=60;
166 HANDLER performance_schema.memory_summary_by_account_by_event_name OPEN;
167 ERROR HY000: Table storage engine for 'memory_summary_by_account_by_event_name' doesn't have this option
168 SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=59;
169 HANDLER performance_schema.log_status OPEN;
170 ERROR HY000: Table storage engine for 'log_status' doesn't have this option
171 SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=58;
172 HANDLER performance_schema.keyring_keys OPEN;
173 ERROR HY000: Table storage engine for 'keyring_keys' doesn't have this option
174 SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=57;
175 HANDLER performance_schema.keyring_component_status OPEN;
176 ERROR HY000: Table storage engine for 'keyring_component_status' doesn't have this option
177 SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=56;
178 HANDLER performance_schema.innodb_redo_log_files OPEN;
179 ERROR HY000: Table storage engine for 'innodb_redo_log_files' doesn't have this option
180 SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=55;
181 HANDLER performance_schema.hosts OPEN;
182 ERROR HY000: Table storage engine for 'hosts' doesn't have this option
183 SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=54;
184 HANDLER performance_schema.host_cache OPEN;
185 ERROR HY000: Table storage engine for 'host_cache' doesn't have this option
186 SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=53;
187 HANDLER performance_schema.global_variables OPEN;
188 ERROR HY000: Table storage engine for 'global_variables' doesn't have this option
189 SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=52;
190 HANDLER performance_schema.global_status OPEN;
191 ERROR HY000: Table storage engine for 'global_status' doesn't have this option
192 SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=51;
193 HANDLER performance_schema.file_summary_by_instance OPEN;
194 ERROR HY000: Table storage engine for 'file_summary_by_instance' doesn't have this option
195 SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=50;
196 HANDLER performance_schema.file_summary_by_event_name OPEN;
197 ERROR HY000: Table storage engine for 'file_summary_by_event_name' doesn't have this option
198 SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=49;
199 HANDLER performance_schema.file_instances OPEN;
200 ERROR HY000: Table storage engine for 'file_instances' doesn't have this option
201 SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=48;
202 HANDLER performance_schema.events_waits_summary_global_by_event_name OPEN;
203 ERROR HY000: Table storage engine for 'events_waits_summary_global_by_event_name' doesn't have this option
204 SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=47;
205 HANDLER performance_schema.events_waits_summary_by_user_by_event_name OPEN;
206 ERROR HY000: Table storage engine for 'events_waits_summary_by_user_by_event_name' doesn't have this option
207 SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=46;
208 HANDLER performance_schema.events_waits_summary_by_thread_by_event_name OPEN;
209 ERROR HY000: Table storage engine for 'events_waits_summary_by_thread_by_event_name' doesn't have this option
210 SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=45;
211 HANDLER performance_schema.events_waits_summary_by_instance OPEN;
212 ERROR HY000: Table storage engine for 'events_waits_summary_by_instance' doesn't have this option
213 SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=44;
214 HANDLER performance_schema.events_waits_summary_by_host_by_event_name OPEN;
215 ERROR HY000: Table storage engine for 'events_waits_summary_by_host_by_event_name' doesn't have this option
216 SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=43;
217 HANDLER performance_schema.events_waits_summary_by_account_by_event_name OPEN;
218 ERROR HY000: Table storage engine for 'events_waits_summary_by_account_by_event_name' doesn't have this option
219 SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=42;
220 HANDLER performance_schema.events_waits_history_long OPEN;
221 ERROR HY000: Table storage engine for 'events_waits_history_long' doesn't have this option
222 SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=41;
223 HANDLER performance_schema.events_waits_history OPEN;
224 ERROR HY000: Table storage engine for 'events_waits_history' doesn't have this option
225 SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=40;
226 HANDLER performance_schema.events_waits_current OPEN;
227 ERROR HY000: Table storage engine for 'events_waits_current' doesn't have this option
228 SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=39;
229 HANDLER performance_schema.events_transactions_summary_global_by_event_name OPEN;
230 ERROR HY000: Table storage engine for 'events_transactions_summary_global_by_event_name' doesn't have this option
231 SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=38;
232 HANDLER performance_schema.events_transactions_summary_by_user_by_event_name OPEN;
233 ERROR HY000: Table storage engine for 'events_transactions_summary_by_user_by_event_name' doesn't have this option
234 SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=37;
235 HANDLER performance_schema.events_transactions_summary_by_thread_by_event_name OPEN;
236 ERROR HY000: Table storage engine for 'events_transactions_summary_by_thread_by_event_name' doesn't have this option
237 SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=36;
238 HANDLER performance_schema.events_transactions_summary_by_host_by_event_name OPEN;
239 ERROR HY000: Table storage engine for 'events_transactions_summary_by_host_by_event_name' doesn't have this option
240 SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=35;
241 HANDLER performance_schema.events_transactions_summary_by_account_by_event_name OPEN;
242 ERROR HY000: Table storage engine for 'events_transactions_summary_by_account_by_event_name' doesn't have this option
243 SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=34;
244 HANDLER performance_schema.events_transactions_history_long OPEN;
245 ERROR HY000: Table storage engine for 'events_transactions_history_long' doesn't have this option
246 SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=33;
247 HANDLER performance_schema.events_transactions_history OPEN;
248 ERROR HY000: Table storage engine for 'events_transactions_history' doesn't have this option
249 SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=32;
250 HANDLER performance_schema.events_transactions_current OPEN;
251 ERROR HY000: Table storage engine for 'events_transactions_current' doesn't have this option
252 SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=31;
253 HANDLER performance_schema.events_statements_summary_global_by_event_name OPEN;
254 ERROR HY000: Table storage engine for 'events_statements_summary_global_by_event_name' doesn't have this option
255 SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=30;
256 HANDLER performance_schema.events_statements_summary_by_user_by_event_name OPEN;
257 ERROR HY000: Table storage engine for 'events_statements_summary_by_user_by_event_name' doesn't have this option
258 SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=29;
259 HANDLER performance_schema.events_statements_summary_by_thread_by_event_name OPEN;
260 ERROR HY000: Table storage engine for 'events_statements_summary_by_thread_by_event_name' doesn't have this option
261 SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=28;
262 HANDLER performance_schema.events_statements_summary_by_program OPEN;
263 ERROR HY000: Table storage engine for 'events_statements_summary_by_program' doesn't have this option
264 SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=27;
265 HANDLER performance_schema.events_statements_summary_by_host_by_event_name OPEN;
266 ERROR HY000: Table storage engine for 'events_statements_summary_by_host_by_event_name' doesn't have this option
267 SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=26;
268 HANDLER performance_schema.events_statements_summary_by_digest OPEN;
269 ERROR HY000: Table storage engine for 'events_statements_summary_by_digest' doesn't have this option
270 SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=25;
271 HANDLER performance_schema.events_statements_summary_by_account_by_event_name OPEN;
272 ERROR HY000: Table storage engine for 'events_statements_summary_by_account_by_event_name' doesn't have this option
273 SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=24;
274 HANDLER performance_schema.events_statements_history_long OPEN;
275 ERROR HY000: Table storage engine for 'events_statements_history_long' doesn't have this option
276 SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=23;
277 HANDLER performance_schema.events_statements_history OPEN;
278 ERROR HY000: Table storage engine for 'events_statements_history' doesn't have this option
279 SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=22;
280 HANDLER performance_schema.events_statements_histogram_global OPEN;
281 ERROR HY000: Table storage engine for 'events_statements_histogram_global' doesn't have this option
282 SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=21;
283 HANDLER performance_schema.events_statements_histogram_by_digest OPEN;
284 ERROR HY000: Table storage engine for 'events_statements_histogram_by_digest' doesn't have this option
285 SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=20;
286 HANDLER performance_schema.events_statements_current OPEN;
287 ERROR HY000: Table storage engine for 'events_statements_current' doesn't have this option
288 SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=19;
289 HANDLER performance_schema.events_stages_summary_global_by_event_name OPEN;
290 ERROR HY000: Table storage engine for 'events_stages_summary_global_by_event_name' doesn't have this option
291 SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=18;
292 HANDLER performance_schema.events_stages_summary_by_user_by_event_name OPEN;
293 ERROR HY000: Table storage engine for 'events_stages_summary_by_user_by_event_name' doesn't have this option
294 SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=17;
295 HANDLER performance_schema.events_stages_summary_by_thread_by_event_name OPEN;
296 ERROR HY000: Table storage engine for 'events_stages_summary_by_thread_by_event_name' doesn't have this option
297 SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=16;
298 HANDLER performance_schema.events_stages_summary_by_host_by_event_name OPEN;
299 ERROR HY000: Table storage engine for 'events_stages_summary_by_host_by_event_name' doesn't have this option
300 SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=15;
301 HANDLER performance_schema.events_stages_summary_by_account_by_event_name OPEN;
302 ERROR HY000: Table storage engine for 'events_stages_summary_by_account_by_event_name' doesn't have this option
303 SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=14;
304 HANDLER performance_schema.events_stages_history_long OPEN;
305 ERROR HY000: Table storage engine for 'events_stages_history_long' doesn't have this option
306 SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=13;
307 HANDLER performance_schema.events_stages_history OPEN;
308 ERROR HY000: Table storage engine for 'events_stages_history' doesn't have this option
309 SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=12;
310 HANDLER performance_schema.events_stages_current OPEN;
311 ERROR HY000: Table storage engine for 'events_stages_current' doesn't have this option
312 SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=11;
313 HANDLER performance_schema.events_errors_summary_global_by_error OPEN;
314 ERROR HY000: Table storage engine for 'events_errors_summary_global_by_error' doesn't have this option
315 SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=10;
316 HANDLER performance_schema.events_errors_summary_by_user_by_error OPEN;
317 ERROR HY000: Table storage engine for 'events_errors_summary_by_user_by_error' doesn't have this option
318 SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=9;
319 HANDLER performance_schema.events_errors_summary_by_thread_by_error OPEN;
320 ERROR HY000: Table storage engine for 'events_errors_summary_by_thread_by_error' doesn't have this option
321 SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=8;
322 HANDLER performance_schema.events_errors_summary_by_host_by_error OPEN;
323 ERROR HY000: Table storage engine for 'events_errors_summary_by_host_by_error' doesn't have this option
324 SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=7;
325 HANDLER performance_schema.events_errors_summary_by_account_by_error OPEN;
326 ERROR HY000: Table storage engine for 'events_errors_summary_by_account_by_error' doesn't have this option
327 SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=6;
328 HANDLER performance_schema.error_log OPEN;
329 ERROR HY000: Table storage engine for 'error_log' doesn't have this option
330 SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=5;
331 HANDLER performance_schema.data_locks OPEN;
332 ERROR HY000: Table storage engine for 'data_locks' doesn't have this option
333 SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=4;
334 HANDLER performance_schema.data_lock_waits OPEN;
335 ERROR HY000: Table storage engine for 'data_lock_waits' doesn't have this option
336 SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=3;
337 HANDLER performance_schema.cond_instances OPEN;
338 ERROR HY000: Table storage engine for 'cond_instances' doesn't have this option
339 SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=2;
340 HANDLER performance_schema.binary_log_transaction_compression_stats OPEN;
341 ERROR HY000: Table storage engine for 'binary_log_transaction_compression_stats' doesn't have this option
342 SELECT TABLE_NAME INTO @table_name FROM table_list WHERE id=1;
343 HANDLER performance_schema.accounts OPEN;
344 ERROR HY000: Table storage engine for 'accounts' doesn't have this option
345 DROP TEMPORARY TABLE table_list;