Debian Codegraph @

mysql-test/suite/funcs_1/r/is_key_column_usage_embedded.result

raw
1 SHOW TABLES FROM information_schema LIKE 'KEY_COLUMN_USAGE';
2 Tables_in_information_schema (KEY_COLUMN_USAGE)
3 KEY_COLUMN_USAGE
4 #######################################################################
5 # Testcase 3.2.1.1: INFORMATION_SCHEMA tables can be queried via SELECT
6 #######################################################################
7 DROP VIEW IF EXISTS test.v1;
8 DROP PROCEDURE IF EXISTS test.p1;
9 DROP FUNCTION IF EXISTS test.f1;
10 CREATE VIEW test.v1 AS SELECT * FROM information_schema.KEY_COLUMN_USAGE;
11 CREATE PROCEDURE test.p1() SELECT * FROM information_schema.KEY_COLUMN_USAGE;
12 CREATE FUNCTION test.f1() returns BIGINT
13 BEGIN
14 DECLARE counter BIGINT DEFAULT NULL;
15 SELECT COUNT(*) INTO counter FROM information_schema.KEY_COLUMN_USAGE;
16 RETURN counter;
17 END//
18 # Attention: The printing of the next result sets is disabled.
19 SELECT * FROM information_schema.KEY_COLUMN_USAGE;
20 SELECT * FROM test.v1;
21 CALL test.p1;
22 SELECT test.f1();
23 DROP VIEW test.v1;
24 DROP PROCEDURE test.p1;
25 DROP FUNCTION test.f1;
26 #########################################################################
27 # Testcase 3.2.7.1: INFORMATION_SCHEMA.KEY_COLUMN_USAGE layout
28 #########################################################################
29 DESCRIBE information_schema.KEY_COLUMN_USAGE;
30 Field Type Null Key Default Extra
31 CONSTRAINT_CATALOG varchar(512) NO NULL
32 CONSTRAINT_SCHEMA varchar(64) NO NULL
33 CONSTRAINT_NAME varchar(64) NO NULL
34 TABLE_CATALOG varchar(512) NO NULL
35 TABLE_SCHEMA varchar(64) NO NULL
36 TABLE_NAME varchar(64) NO NULL
37 COLUMN_NAME varchar(64) NO NULL
38 ORDINAL_POSITION bigint(10) NO NULL
39 POSITION_IN_UNIQUE_CONSTRAINT bigint(10) YES NULL
40 REFERENCED_TABLE_SCHEMA varchar(64) YES NULL
41 REFERENCED_TABLE_NAME varchar(64) YES NULL
42 REFERENCED_COLUMN_NAME varchar(64) YES NULL
43 SHOW CREATE TABLE information_schema.KEY_COLUMN_USAGE;
44 Table Create Table
45 KEY_COLUMN_USAGE CREATE TEMPORARY TABLE `KEY_COLUMN_USAGE` (
46 `CONSTRAINT_CATALOG` varchar(512) NOT NULL,
47 `CONSTRAINT_SCHEMA` varchar(64) NOT NULL,
48 `CONSTRAINT_NAME` varchar(64) NOT NULL,
49 `TABLE_CATALOG` varchar(512) NOT NULL,
50 `TABLE_SCHEMA` varchar(64) NOT NULL,
51 `TABLE_NAME` varchar(64) NOT NULL,
52 `COLUMN_NAME` varchar(64) NOT NULL,
53 `ORDINAL_POSITION` bigint(10) NOT NULL,
54 `POSITION_IN_UNIQUE_CONSTRAINT` bigint(10),
55 `REFERENCED_TABLE_SCHEMA` varchar(64),
56 `REFERENCED_TABLE_NAME` varchar(64),
57 `REFERENCED_COLUMN_NAME` varchar(64)
58 ) ENGINE=MEMORY DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci
59 SHOW COLUMNS FROM information_schema.KEY_COLUMN_USAGE;
60 Field Type Null Key Default Extra
61 CONSTRAINT_CATALOG varchar(512) NO NULL
62 CONSTRAINT_SCHEMA varchar(64) NO NULL
63 CONSTRAINT_NAME varchar(64) NO NULL
64 TABLE_CATALOG varchar(512) NO NULL
65 TABLE_SCHEMA varchar(64) NO NULL
66 TABLE_NAME varchar(64) NO NULL
67 COLUMN_NAME varchar(64) NO NULL
68 ORDINAL_POSITION bigint(10) NO NULL
69 POSITION_IN_UNIQUE_CONSTRAINT bigint(10) YES NULL
70 REFERENCED_TABLE_SCHEMA varchar(64) YES NULL
71 REFERENCED_TABLE_NAME varchar(64) YES NULL
72 REFERENCED_COLUMN_NAME varchar(64) YES NULL
73 SELECT constraint_catalog, constraint_schema, constraint_name, table_catalog,
74 table_schema, table_name, column_name
75 FROM information_schema.key_column_usage
76 WHERE constraint_catalog IS NOT NULL OR table_catalog IS NOT NULL
77 ORDER BY BINARY table_schema, BINARY table_name, BINARY column_name, BINARY constraint_name;
78 constraint_catalog constraint_schema constraint_name table_catalog table_schema table_name column_name
79 def mysql PRIMARY def mysql column_stats column_name
80 def mysql PRIMARY def mysql column_stats db_name
81 def mysql PRIMARY def mysql column_stats table_name
82 def mysql PRIMARY def mysql columns_priv Column_name
83 def mysql PRIMARY def mysql columns_priv Db
84 def mysql PRIMARY def mysql columns_priv Host
85 def mysql PRIMARY def mysql columns_priv Table_name
86 def mysql PRIMARY def mysql columns_priv User
87 def mysql PRIMARY def mysql db Db
88 def mysql PRIMARY def mysql db Host
89 def mysql PRIMARY def mysql db User
90 def mysql PRIMARY def mysql event db
91 def mysql PRIMARY def mysql event name
92 def mysql PRIMARY def mysql func name
93 def mysql PRIMARY def mysql global_priv Host
94 def mysql PRIMARY def mysql global_priv User
95 def mysql PRIMARY def mysql gtid_slave_pos domain_id
96 def mysql PRIMARY def mysql gtid_slave_pos sub_id
97 def mysql PRIMARY def mysql help_category help_category_id
98 def mysql name def mysql help_category name
99 def mysql PRIMARY def mysql help_keyword help_keyword_id
100 def mysql name def mysql help_keyword name
101 def mysql PRIMARY def mysql help_relation help_keyword_id
102 def mysql PRIMARY def mysql help_relation help_topic_id
103 def mysql PRIMARY def mysql help_topic help_topic_id
104 def mysql name def mysql help_topic name
105 def mysql PRIMARY def mysql index_stats db_name
106 def mysql PRIMARY def mysql index_stats index_name
107 def mysql PRIMARY def mysql index_stats prefix_arity
108 def mysql PRIMARY def mysql index_stats table_name
109 def mysql PRIMARY def mysql innodb_index_stats database_name
110 def mysql PRIMARY def mysql innodb_index_stats index_name
111 def mysql PRIMARY def mysql innodb_index_stats stat_name
112 def mysql PRIMARY def mysql innodb_index_stats table_name
113 def mysql PRIMARY def mysql innodb_table_stats database_name
114 def mysql PRIMARY def mysql innodb_table_stats table_name
115 def mysql PRIMARY def mysql plugin name
116 def mysql PRIMARY def mysql proc db
117 def mysql PRIMARY def mysql proc name
118 def mysql PRIMARY def mysql proc type
119 def mysql PRIMARY def mysql procs_priv Db
120 def mysql PRIMARY def mysql procs_priv Host
121 def mysql PRIMARY def mysql procs_priv Routine_name
122 def mysql PRIMARY def mysql procs_priv Routine_type
123 def mysql PRIMARY def mysql procs_priv User
124 def mysql PRIMARY def mysql proxies_priv Host
125 def mysql PRIMARY def mysql proxies_priv Proxied_host
126 def mysql PRIMARY def mysql proxies_priv Proxied_user
127 def mysql PRIMARY def mysql proxies_priv User
128 def mysql Host def mysql roles_mapping Host
129 def mysql Host def mysql roles_mapping Role
130 def mysql Host def mysql roles_mapping User
131 def mysql PRIMARY def mysql servers Server_name
132 def mysql PRIMARY def mysql table_stats db_name
133 def mysql PRIMARY def mysql table_stats table_name
134 def mysql PRIMARY def mysql tables_priv Db
135 def mysql PRIMARY def mysql tables_priv Host
136 def mysql PRIMARY def mysql tables_priv Table_name
137 def mysql PRIMARY def mysql tables_priv User
138 def mysql PRIMARY def mysql time_zone Time_zone_id
139 def mysql PRIMARY def mysql time_zone_leap_second Transition_time
140 def mysql PRIMARY def mysql time_zone_name Name
141 def mysql PRIMARY def mysql time_zone_transition Time_zone_id
142 def mysql PRIMARY def mysql time_zone_transition Transition_time
143 def mysql PRIMARY def mysql time_zone_transition_type Time_zone_id
144 def mysql PRIMARY def mysql time_zone_transition_type Transition_type_id
145 def mysql commit_id def mysql transaction_registry commit_id
146 def mysql PRIMARY def mysql transaction_registry transaction_id
147 def sys PRIMARY def sys sys_config variable
148 ########################################################################################
149 # Testcase 3.2.7.2 + 3.2.7.3: INFORMATION_SCHEMA.KEY_COLUMN_USAGE accessible information
150 ########################################################################################
151 DROP DATABASE IF EXISTS db_datadict;
152 CREATE DATABASE db_datadict;
153 DROP USER 'testuser1'@'localhost';
154 CREATE USER 'testuser1'@'localhost';
155 DROP USER 'testuser2'@'localhost';
156 CREATE USER 'testuser2'@'localhost';
157 USE db_datadict;
158 CREATE TABLE t1_1
159 (f1 INT NOT NULL, PRIMARY KEY(f1),
160 f2 INT, INDEX f2_ind(f2))
161 ENGINE = <engine_type>;
162 GRANT SELECT ON t1_1 to 'testuser1'@'localhost';
163 CREATE TABLE t1_2
164 (f1 INT NOT NULL, PRIMARY KEY(f1),
165 f2 INT, INDEX f2_ind(f2))
166 ENGINE = <engine_type>;
167 GRANT SELECT ON t1_2 to 'testuser2'@'localhost';
168 SELECT * FROM information_schema.key_column_usage
169 WHERE table_name LIKE 't1_%'
170 ORDER BY constraint_catalog, constraint_schema, constraint_name,
171 table_catalog, table_schema, table_name, ordinal_position;
172 CONSTRAINT_CATALOG CONSTRAINT_SCHEMA CONSTRAINT_NAME TABLE_CATALOG TABLE_SCHEMA TABLE_NAME COLUMN_NAME ORDINAL_POSITION POSITION_IN_UNIQUE_CONSTRAINT REFERENCED_TABLE_SCHEMA REFERENCED_TABLE_NAME REFERENCED_COLUMN_NAME
173 def db_datadict PRIMARY def db_datadict t1_1 f1 1 NULL NULL NULL NULL
174 def db_datadict PRIMARY def db_datadict t1_2 f1 1 NULL NULL NULL NULL
175 connect testuser1, localhost, testuser1, , db_datadict;
176 SELECT * FROM information_schema.key_column_usage
177 WHERE table_name LIKE 't1_%'
178 ORDER BY constraint_catalog, constraint_schema, constraint_name,
179 table_catalog, table_schema, table_name, ordinal_position;
180 CONSTRAINT_CATALOG CONSTRAINT_SCHEMA CONSTRAINT_NAME TABLE_CATALOG TABLE_SCHEMA TABLE_NAME COLUMN_NAME ORDINAL_POSITION POSITION_IN_UNIQUE_CONSTRAINT REFERENCED_TABLE_SCHEMA REFERENCED_TABLE_NAME REFERENCED_COLUMN_NAME
181 def db_datadict PRIMARY def db_datadict t1_1 f1 1 NULL NULL NULL NULL
182 def db_datadict PRIMARY def db_datadict t1_2 f1 1 NULL NULL NULL NULL
183 connect testuser2, localhost, testuser2, , db_datadict;
184 SELECT * FROM information_schema.key_column_usage
185 WHERE table_name LIKE 't1_%'
186 ORDER BY constraint_catalog, constraint_schema, constraint_name,
187 table_catalog, table_schema, table_name, ordinal_position;
188 CONSTRAINT_CATALOG CONSTRAINT_SCHEMA CONSTRAINT_NAME TABLE_CATALOG TABLE_SCHEMA TABLE_NAME COLUMN_NAME ORDINAL_POSITION POSITION_IN_UNIQUE_CONSTRAINT REFERENCED_TABLE_SCHEMA REFERENCED_TABLE_NAME REFERENCED_COLUMN_NAME
189 def db_datadict PRIMARY def db_datadict t1_1 f1 1 NULL NULL NULL NULL
190 def db_datadict PRIMARY def db_datadict t1_2 f1 1 NULL NULL NULL NULL
191 connection default;
192 disconnect testuser1;
193 disconnect testuser2;
194 DROP USER 'testuser1'@'localhost';
195 DROP USER 'testuser2'@'localhost';
196 DROP TABLE t1_1;
197 DROP TABLE t1_2;
198 DROP DATABASE IF EXISTS db_datadict;
199 ########################################################################################
200 # Testcase 3.2.1.13+3.2.1.14+3.2.1.15: INFORMATION_SCHEMA.KEY_COLUMN_USAGE modifications
201 ########################################################################################
202 DROP DATABASE IF EXISTS db_datadict;
203 DROP TABLE IF EXISTS test.t1_my_table;
204 CREATE DATABASE db_datadict;
205 SELECT table_name FROM information_schema.key_column_usage
206 WHERE table_name LIKE 't1_my_table%';
207 table_name
208 CREATE TABLE test.t1_my_table
209 (f1 CHAR(12), f2 TIMESTAMP, f4 BIGINT, PRIMARY KEY(f1,f2))
210 DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci
211 ENGINE = <engine_type>;
212 SELECT * FROM information_schema.key_column_usage
213 WHERE table_name = 't1_my_table';
214 CONSTRAINT_CATALOG def
215 CONSTRAINT_SCHEMA test
216 CONSTRAINT_NAME PRIMARY
217 TABLE_CATALOG def
218 TABLE_SCHEMA test
219 TABLE_NAME t1_my_table
220 COLUMN_NAME f1
221 ORDINAL_POSITION 1
222 POSITION_IN_UNIQUE_CONSTRAINT NULL
223 REFERENCED_TABLE_SCHEMA NULL
224 REFERENCED_TABLE_NAME NULL
225 REFERENCED_COLUMN_NAME NULL
226 CONSTRAINT_CATALOG def
227 CONSTRAINT_SCHEMA test
228 CONSTRAINT_NAME PRIMARY
229 TABLE_CATALOG def
230 TABLE_SCHEMA test
231 TABLE_NAME t1_my_table
232 COLUMN_NAME f2
233 ORDINAL_POSITION 2
234 POSITION_IN_UNIQUE_CONSTRAINT NULL
235 REFERENCED_TABLE_SCHEMA NULL
236 REFERENCED_TABLE_NAME NULL
237 REFERENCED_COLUMN_NAME NULL
238 SELECT DISTINCT table_name FROM information_schema.key_column_usage
239 WHERE table_name LIKE 't1_my_table%';
240 table_name
241 t1_my_table
242 RENAME TABLE test.t1_my_table TO test.t1_my_tablex;
243 SELECT DISTINCT table_name FROM information_schema.key_column_usage
244 WHERE table_name LIKE 't1_my_table%';
245 table_name
246 t1_my_tablex
247 SELECT DISTINCT table_schema,table_name FROM information_schema.key_column_usage
248 WHERE table_name = 't1_my_tablex';
249 table_schema table_name
250 test t1_my_tablex
251 RENAME TABLE test.t1_my_tablex TO db_datadict.t1_my_tablex;
252 SELECT DISTINCT table_schema,table_name FROM information_schema.key_column_usage
253 WHERE table_name = 't1_my_tablex';
254 table_schema table_name
255 db_datadict t1_my_tablex
256 SELECT DISTINCT table_name, column_name FROM information_schema.key_column_usage
257 WHERE table_name = 't1_my_tablex'
258 ORDER BY table_name, column_name;
259 table_name column_name
260 t1_my_tablex f1
261 t1_my_tablex f2
262 ALTER TABLE db_datadict.t1_my_tablex CHANGE COLUMN f1 first_col CHAR(12);
263 SELECT DISTINCT table_name, column_name FROM information_schema.key_column_usage
264 WHERE table_name = 't1_my_tablex'
265 ORDER BY table_name, column_name;
266 table_name column_name
267 t1_my_tablex f2
268 t1_my_tablex first_col
269 SELECT constraint_schema, constraint_name, table_schema,
270 table_name, column_name, ordinal_position
271 FROM information_schema.key_column_usage
272 WHERE table_name = 't1_my_tablex'
273 ORDER BY constraint_schema, constraint_name, table_schema,
274 table_name, ordinal_position;
275 constraint_schema constraint_name table_schema table_name column_name ordinal_position
276 db_datadict PRIMARY db_datadict t1_my_tablex first_col 1
277 db_datadict PRIMARY db_datadict t1_my_tablex f2 2
278 CREATE INDEX f2 ON db_datadict.t1_my_tablex(f2);
279 SELECT constraint_schema, constraint_name, table_schema,
280 table_name, column_name, ordinal_position
281 FROM information_schema.key_column_usage
282 WHERE table_name = 't1_my_tablex'
283 ORDER BY constraint_schema, constraint_name, table_schema,
284 table_name, ordinal_position;
285 constraint_schema constraint_name table_schema table_name column_name ordinal_position
286 db_datadict PRIMARY db_datadict t1_my_tablex first_col 1
287 db_datadict PRIMARY db_datadict t1_my_tablex f2 2
288 DROP INDEX f2 ON db_datadict.t1_my_tablex;
289 SELECT constraint_schema, constraint_name, table_schema,
290 table_name, column_name, ordinal_position
291 FROM information_schema.key_column_usage
292 WHERE table_name = 't1_my_tablex'
293 ORDER BY constraint_schema, constraint_name, table_schema,
294 table_name, ordinal_position;
295 constraint_schema constraint_name table_schema table_name column_name ordinal_position
296 db_datadict PRIMARY db_datadict t1_my_tablex first_col 1
297 db_datadict PRIMARY db_datadict t1_my_tablex f2 2
298 ALTER TABLE db_datadict.t1_my_tablex ADD UNIQUE (f2);
299 SELECT constraint_schema, constraint_name, table_schema,
300 table_name, column_name, ordinal_position
301 FROM information_schema.key_column_usage
302 WHERE table_name = 't1_my_tablex'
303 ORDER BY constraint_schema, constraint_name, table_schema,
304 table_name, ordinal_position;
305 constraint_schema constraint_name table_schema table_name column_name ordinal_position
306 db_datadict f2 db_datadict t1_my_tablex f2 1
307 db_datadict PRIMARY db_datadict t1_my_tablex first_col 1
308 db_datadict PRIMARY db_datadict t1_my_tablex f2 2
309 DROP INDEX f2 ON db_datadict.t1_my_tablex;
310 SELECT constraint_schema, constraint_name, table_schema,
311 table_name, column_name, ordinal_position
312 FROM information_schema.key_column_usage
313 WHERE table_name = 't1_my_tablex'
314 ORDER BY constraint_schema, constraint_name, table_schema,
315 table_name, ordinal_position;
316 constraint_schema constraint_name table_schema table_name column_name ordinal_position
317 db_datadict PRIMARY db_datadict t1_my_tablex first_col 1
318 db_datadict PRIMARY db_datadict t1_my_tablex f2 2
319 ALTER TABLE db_datadict.t1_my_tablex ADD UNIQUE my_idx (f2);
320 SELECT constraint_schema, constraint_name, table_schema,
321 table_name, column_name, ordinal_position
322 FROM information_schema.key_column_usage
323 WHERE table_name = 't1_my_tablex'
324 ORDER BY constraint_schema, constraint_name, table_schema,
325 table_name, ordinal_position;
326 constraint_schema constraint_name table_schema table_name column_name ordinal_position
327 db_datadict my_idx db_datadict t1_my_tablex f2 1
328 db_datadict PRIMARY db_datadict t1_my_tablex first_col 1
329 db_datadict PRIMARY db_datadict t1_my_tablex f2 2
330 DROP INDEX my_idx ON db_datadict.t1_my_tablex;
331 SELECT constraint_schema, constraint_name, table_schema,
332 table_name, column_name, ordinal_position
333 FROM information_schema.key_column_usage
334 WHERE table_name = 't1_my_tablex'
335 ORDER BY constraint_schema, constraint_name, table_schema,
336 table_name, ordinal_position;
337 constraint_schema constraint_name table_schema table_name column_name ordinal_position
338 db_datadict PRIMARY db_datadict t1_my_tablex first_col 1
339 db_datadict PRIMARY db_datadict t1_my_tablex f2 2
340 ALTER TABLE db_datadict.t1_my_tablex ADD UNIQUE my_idx (f4,first_col);
341 SELECT constraint_schema, constraint_name, table_schema,
342 table_name, column_name, ordinal_position
343 FROM information_schema.key_column_usage
344 WHERE table_name = 't1_my_tablex'
345 ORDER BY constraint_schema, constraint_name, table_schema,
346 table_name, ordinal_position;
347 constraint_schema constraint_name table_schema table_name column_name ordinal_position
348 db_datadict my_idx db_datadict t1_my_tablex f4 1
349 db_datadict my_idx db_datadict t1_my_tablex first_col 2
350 db_datadict PRIMARY db_datadict t1_my_tablex first_col 1
351 db_datadict PRIMARY db_datadict t1_my_tablex f2 2
352 SELECT table_name, column_name
353 FROM information_schema.key_column_usage
354 WHERE table_name = 't1_my_tablex'
355 ORDER BY table_name, column_name;
356 table_name column_name
357 t1_my_tablex f2
358 t1_my_tablex f4
359 t1_my_tablex first_col
360 t1_my_tablex first_col
361 DROP TABLE db_datadict.t1_my_tablex;
362 SELECT table_name, column_name
363 FROM information_schema.key_column_usage
364 WHERE table_name = 't1_my_tablex';
365 table_name column_name
366 SELECT table_name FROM information_schema.key_column_usage
367 WHERE table_name = 't1_my_tablex';
368 table_name
369 CREATE TABLE db_datadict.t1_my_tablex
370 ENGINE = <engine_type> AS
371 SELECT 1 AS f1;
372 SELECT table_name FROM information_schema.key_column_usage
373 WHERE table_name = 't1_my_tablex';
374 table_name
375 ALTER TABLE db_datadict.t1_my_tablex ADD PRIMARY KEY(f1);
376 SELECT table_name FROM information_schema.key_column_usage
377 WHERE table_name = 't1_my_tablex';
378 table_name
379 t1_my_tablex
380 SELECT table_name FROM information_schema.key_column_usage
381 WHERE table_name = 't1_my_tablex';
382 table_name
383 t1_my_tablex
384 DROP DATABASE db_datadict;
385 SELECT table_name FROM information_schema.key_column_usage
386 WHERE table_name = 't1_my_tablex';
387 table_name
388 ########################################################################
389 # Testcases 3.2.1.3-3.2.1.5 + 3.2.1.8-3.2.1.12: INSERT/UPDATE/DELETE and
390 # DDL on INFORMATION_SCHEMA table are not supported
391 ########################################################################
392 DROP DATABASE IF EXISTS db_datadict;
393 DROP TABLE IF EXISTS db_datadict.t1;
394 CREATE DATABASE db_datadict;
395 CREATE TABLE db_datadict.t1 (f1 BIGINT)
396 ENGINE = <engine_type>;
397 INSERT INTO information_schema.key_column_usage
398 (constraint_schema, constraint_name, table_name)
399 VALUES ( 'mysql', 'primary', 'db');
400 ERROR 42000: Access denied for user 'root'@'localhost' to database 'information_schema'
401 INSERT INTO information_schema.key_column_usage
402 SELECT * FROM information_schema.key_column_usage;
403 ERROR 42000: Access denied for user 'root'@'localhost' to database 'information_schema'
404 UPDATE information_schema.key_column_usage
405 SET table_name = 'db1' WHERE constraint_name = 'primary';
406 Got one of the listed errors
407 DELETE FROM information_schema.key_column_usage WHERE table_name = 't1';
408 ERROR 42000: Access denied for user 'root'@'localhost' to database 'information_schema'
409 TRUNCATE information_schema.key_column_usage;
410 ERROR 42000: Access denied for user 'root'@'localhost' to database 'information_schema'
411 CREATE INDEX i3 ON information_schema.key_column_usage(table_name);
412 ERROR 42000: Access denied for user 'root'@'localhost' to database 'information_schema'
413 ALTER TABLE information_schema.key_column_usage ADD f1 INT;
414 ERROR 42000: Access denied for user 'root'@'localhost' to database 'information_schema'
415 DROP TABLE information_schema.key_column_usage;
416 ERROR 42000: Access denied for user 'root'@'localhost' to database 'information_schema'
417 ALTER TABLE information_schema.key_column_usage
418 RENAME db_datadict.key_column_usage;
419 ERROR 42000: Access denied for user 'root'@'localhost' to database 'information_schema'
420 ALTER TABLE information_schema.key_column_usage
421 RENAME information_schema.xkey_column_usage;
422 ERROR 42000: Access denied for user 'root'@'localhost' to database 'information_schema'
423 DROP TABLE db_datadict.t1;
424 DROP DATABASE db_datadict;