Debian Codegraph @

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

raw
1 SHOW TABLES FROM information_schema LIKE 'ROUTINES';
2 Tables_in_information_schema (ROUTINES)
3 ROUTINES
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.ROUTINES;
11 CREATE PROCEDURE test.p1() SELECT * FROM information_schema.ROUTINES;
12 CREATE FUNCTION test.f1() returns BIGINT
13 BEGIN
14 DECLARE counter BIGINT DEFAULT NULL;
15 SELECT COUNT(*) INTO counter FROM information_schema.ROUTINES;
16 RETURN counter;
17 END//
18 # Attention: The printing of the next result sets is disabled.
19 SELECT * FROM information_schema.ROUTINES;
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.8.1: INFORMATION_SCHEMA.ROUTINES layout
28 #########################################################################
29 DESCRIBE information_schema.ROUTINES;
30 Field Type Null Key Default Extra
31 SPECIFIC_NAME varchar(64) NO NULL
32 ROUTINE_CATALOG varchar(64) NO NULL
33 ROUTINE_SCHEMA varchar(64) NO NULL
34 ROUTINE_NAME varchar(64) NO NULL
35 ROUTINE_TYPE enum('FUNCTION','PROCEDURE') NO NULL
36 DATA_TYPE longtext YES NULL
37 CHARACTER_MAXIMUM_LENGTH bigint YES NULL
38 CHARACTER_OCTET_LENGTH bigint YES NULL
39 NUMERIC_PRECISION int unsigned YES NULL
40 NUMERIC_SCALE int unsigned YES NULL
41 DATETIME_PRECISION int unsigned YES NULL
42 CHARACTER_SET_NAME varchar(64) YES NULL
43 COLLATION_NAME varchar(64) YES NULL
44 DTD_IDENTIFIER longtext YES NULL
45 ROUTINE_BODY varchar(3) NO
46 ROUTINE_DEFINITION longtext YES NULL
47 EXTERNAL_NAME binary(0) YES NULL
48 EXTERNAL_LANGUAGE varchar(64) NO SQL
49 PARAMETER_STYLE varchar(3) NO
50 IS_DETERMINISTIC varchar(3) NO
51 SQL_DATA_ACCESS enum('CONTAINS SQL','NO SQL','READS SQL DATA','MODIFIES SQL DATA') NO NULL
52 SQL_PATH binary(0) YES NULL
53 SECURITY_TYPE enum('DEFAULT','INVOKER','DEFINER') NO NULL
54 CREATED timestamp NO NULL
55 LAST_ALTERED timestamp NO NULL
56 SQL_MODE set('REAL_AS_FLOAT','PIPES_AS_CONCAT','ANSI_QUOTES','IGNORE_SPACE','NOT_USED','ONLY_FULL_GROUP_BY','NO_UNSIGNED_SUBTRACTION','NO_DIR_IN_CREATE','NOT_USED_9','NOT_USED_10','NOT_USED_11','NOT_USED_12','NOT_USED_13','NOT_USED_14','NOT_USED_15','NOT_USED_16','NOT_USED_17','NOT_USED_18','ANSI','NO_AUTO_VALUE_ON_ZERO','NO_BACKSLASH_ESCAPES','STRICT_TRANS_TABLES','STRICT_ALL_TABLES','NO_ZERO_IN_DATE','NO_ZERO_DATE','ALLOW_INVALID_DATES','ERROR_FOR_DIVISION_BY_ZERO','TRADITIONAL','NOT_USED_29','HIGH_NOT_PRECEDENCE','NO_ENGINE_SUBSTITUTION','PAD_CHAR_TO_FULL_LENGTH','TIME_TRUNCATE_FRACTIONAL') NO NULL
57 ROUTINE_COMMENT text NO NULL
58 DEFINER varchar(288) NO NULL
59 CHARACTER_SET_CLIENT varchar(64) NO NULL
60 COLLATION_CONNECTION varchar(64) NO NULL
61 DATABASE_COLLATION varchar(64) NO NULL
62 SHOW CREATE TABLE information_schema.ROUTINES;
63 View Create View character_set_client collation_connection
64 ROUTINES CREATE ALGORITHM=UNDEFINED DEFINER=`mysql.infoschema`@`localhost` SQL SECURITY DEFINER VIEW `information_schema`.`ROUTINES` AS select `rtn`.`name` AS `SPECIFIC_NAME`,`cat`.`name` AS `ROUTINE_CATALOG`,`sch`.`name` AS `ROUTINE_SCHEMA`,`rtn`.`name` AS `ROUTINE_NAME`,`rtn`.`type` AS `ROUTINE_TYPE`,if((`rtn`.`type` = 'PROCEDURE'),'',substring_index(substring_index(`rtn`.`result_data_type_utf8`,'(',1),' ',1)) AS `DATA_TYPE`,internal_dd_char_length(`rtn`.`result_data_type`,`rtn`.`result_char_length`,`coll_result`.`name`,0) AS `CHARACTER_MAXIMUM_LENGTH`,internal_dd_char_length(`rtn`.`result_data_type`,`rtn`.`result_char_length`,`coll_result`.`name`,1) AS `CHARACTER_OCTET_LENGTH`,`rtn`.`result_numeric_precision` AS `NUMERIC_PRECISION`,`rtn`.`result_numeric_scale` AS `NUMERIC_SCALE`,`rtn`.`result_datetime_precision` AS `DATETIME_PRECISION`,(case `rtn`.`result_data_type` when 'MYSQL_TYPE_STRING' then if((`cs_result`.`name` = 'binary'),NULL,`cs_result`.`name`) when 'MYSQL_TYPE_VAR_STRING' then if((`cs_result`.`name` = 'binary'),NULL,`cs_result`.`name`) when 'MYSQL_TYPE_VARCHAR' then if((`cs_result`.`name` = 'binary'),NULL,`cs_result`.`name`) when 'MYSQL_TYPE_TINY_BLOB' then if((`cs_result`.`name` = 'binary'),NULL,`cs_result`.`name`) when 'MYSQL_TYPE_MEDIUM_BLOB' then if((`cs_result`.`name` = 'binary'),NULL,`cs_result`.`name`) when 'MYSQL_TYPE_BLOB' then if((`cs_result`.`name` = 'binary'),NULL,`cs_result`.`name`) when 'MYSQL_TYPE_LONG_BLOB' then if((`cs_result`.`name` = 'binary'),NULL,`cs_result`.`name`) when 'MYSQL_TYPE_ENUM' then if((`cs_result`.`name` = 'binary'),NULL,`cs_result`.`name`) when 'MYSQL_TYPE_SET' then if((`cs_result`.`name` = 'binary'),NULL,`cs_result`.`name`) else NULL end) AS `CHARACTER_SET_NAME`,(case `rtn`.`result_data_type` when 'MYSQL_TYPE_STRING' then if((`cs_result`.`name` = 'binary'),NULL,`coll_result`.`name`) when 'MYSQL_TYPE_VAR_STRING' then if((`cs_result`.`name` = 'binary'),NULL,`coll_result`.`name`) when 'MYSQL_TYPE_VARCHAR' then if((`cs_result`.`name` = 'binary'),NULL,`coll_result`.`name`) when 'MYSQL_TYPE_TINY_BLOB' then if((`cs_result`.`name` = 'binary'),NULL,`coll_result`.`name`) when 'MYSQL_TYPE_MEDIUM_BLOB' then if((`cs_result`.`name` = 'binary'),NULL,`coll_result`.`name`) when 'MYSQL_TYPE_BLOB' then if((`cs_result`.`name` = 'binary'),NULL,`coll_result`.`name`) when 'MYSQL_TYPE_LONG_BLOB' then if((`cs_result`.`name` = 'binary'),NULL,`coll_result`.`name`) when 'MYSQL_TYPE_ENUM' then if((`cs_result`.`name` = 'binary'),NULL,`coll_result`.`name`) when 'MYSQL_TYPE_SET' then if((`cs_result`.`name` = 'binary'),NULL,`coll_result`.`name`) else NULL end) AS `COLLATION_NAME`,if((`rtn`.`type` = 'PROCEDURE'),NULL,`rtn`.`result_data_type_utf8`) AS `DTD_IDENTIFIER`,'SQL' AS `ROUTINE_BODY`,if(can_access_routine(`sch`.`name`,`rtn`.`name`,`rtn`.`type`,`rtn`.`definer`,true),`rtn`.`definition_utf8`,NULL) AS `ROUTINE_DEFINITION`,NULL AS `EXTERNAL_NAME`,`rtn`.`external_language` AS `EXTERNAL_LANGUAGE`,'SQL' AS `PARAMETER_STYLE`,if((`rtn`.`is_deterministic` = 0),'NO','YES') AS `IS_DETERMINISTIC`,`rtn`.`sql_data_access` AS `SQL_DATA_ACCESS`,NULL AS `SQL_PATH`,`rtn`.`security_type` AS `SECURITY_TYPE`,`rtn`.`created` AS `CREATED`,`rtn`.`last_altered` AS `LAST_ALTERED`,`rtn`.`sql_mode` AS `SQL_MODE`,`rtn`.`comment` AS `ROUTINE_COMMENT`,`rtn`.`definer` AS `DEFINER`,`cs_client`.`name` AS `CHARACTER_SET_CLIENT`,`coll_conn`.`name` AS `COLLATION_CONNECTION`,`coll_db`.`name` AS `DATABASE_COLLATION` from ((((((((`mysql`.`routines` `rtn` join `mysql`.`schemata` `sch` on((`rtn`.`schema_id` = `sch`.`id`))) join `mysql`.`catalogs` `cat` on((`cat`.`id` = `sch`.`catalog_id`))) join `mysql`.`collations` `coll_client` on((`coll_client`.`id` = `rtn`.`client_collation_id`))) join `mysql`.`character_sets` `cs_client` on((`cs_client`.`id` = `coll_client`.`character_set_id`))) join `mysql`.`collations` `coll_conn` on((`coll_conn`.`id` = `rtn`.`connection_collation_id`))) join `mysql`.`collations` `coll_db` on((`coll_db`.`id` = `rtn`.`schema_collation_id`))) left join `mysql`.`collations` `coll_result` on((`coll_result`.`id` = `rtn`.`result_collation_id`))) left join `mysql`.`character_sets` `cs_result` on((`cs_result`.`id` = `coll_result`.`character_set_id`))) where (0 <> can_access_routine(`sch`.`name`,`rtn`.`name`,`rtn`.`type`,`rtn`.`definer`,false)) utf8mb3 utf8mb3_general_ci
65 SHOW COLUMNS FROM information_schema.ROUTINES;
66 Field Type Null Key Default Extra
67 SPECIFIC_NAME varchar(64) NO NULL
68 ROUTINE_CATALOG varchar(64) NO NULL
69 ROUTINE_SCHEMA varchar(64) NO NULL
70 ROUTINE_NAME varchar(64) NO NULL
71 ROUTINE_TYPE enum('FUNCTION','PROCEDURE') NO NULL
72 DATA_TYPE longtext YES NULL
73 CHARACTER_MAXIMUM_LENGTH bigint YES NULL
74 CHARACTER_OCTET_LENGTH bigint YES NULL
75 NUMERIC_PRECISION int unsigned YES NULL
76 NUMERIC_SCALE int unsigned YES NULL
77 DATETIME_PRECISION int unsigned YES NULL
78 CHARACTER_SET_NAME varchar(64) YES NULL
79 COLLATION_NAME varchar(64) YES NULL
80 DTD_IDENTIFIER longtext YES NULL
81 ROUTINE_BODY varchar(3) NO
82 ROUTINE_DEFINITION longtext YES NULL
83 EXTERNAL_NAME binary(0) YES NULL
84 EXTERNAL_LANGUAGE varchar(64) NO SQL
85 PARAMETER_STYLE varchar(3) NO
86 IS_DETERMINISTIC varchar(3) NO
87 SQL_DATA_ACCESS enum('CONTAINS SQL','NO SQL','READS SQL DATA','MODIFIES SQL DATA') NO NULL
88 SQL_PATH binary(0) YES NULL
89 SECURITY_TYPE enum('DEFAULT','INVOKER','DEFINER') NO NULL
90 CREATED timestamp NO NULL
91 LAST_ALTERED timestamp NO NULL
92 SQL_MODE set('REAL_AS_FLOAT','PIPES_AS_CONCAT','ANSI_QUOTES','IGNORE_SPACE','NOT_USED','ONLY_FULL_GROUP_BY','NO_UNSIGNED_SUBTRACTION','NO_DIR_IN_CREATE','NOT_USED_9','NOT_USED_10','NOT_USED_11','NOT_USED_12','NOT_USED_13','NOT_USED_14','NOT_USED_15','NOT_USED_16','NOT_USED_17','NOT_USED_18','ANSI','NO_AUTO_VALUE_ON_ZERO','NO_BACKSLASH_ESCAPES','STRICT_TRANS_TABLES','STRICT_ALL_TABLES','NO_ZERO_IN_DATE','NO_ZERO_DATE','ALLOW_INVALID_DATES','ERROR_FOR_DIVISION_BY_ZERO','TRADITIONAL','NOT_USED_29','HIGH_NOT_PRECEDENCE','NO_ENGINE_SUBSTITUTION','PAD_CHAR_TO_FULL_LENGTH','TIME_TRUNCATE_FRACTIONAL') NO NULL
93 ROUTINE_COMMENT text NO NULL
94 DEFINER varchar(288) NO NULL
95 CHARACTER_SET_CLIENT varchar(64) NO NULL
96 COLLATION_CONNECTION varchar(64) NO NULL
97 DATABASE_COLLATION varchar(64) NO NULL
98 USE test;
99 DROP PROCEDURE IF EXISTS sp_for_routines;
100 DROP FUNCTION IF EXISTS function_for_routines;
101 CREATE PROCEDURE sp_for_routines() SELECT 'db_datadict';
102 CREATE FUNCTION function_for_routines() RETURNS INT RETURN 0;
103 SELECT specific_name,routine_catalog,routine_schema,routine_name,routine_type,
104 routine_body,external_name,external_language,parameter_style,sql_path
105 FROM information_schema.routines
106 WHERE routine_schema = 'test' AND
107 (routine_catalog IS NOT NULL OR external_name IS NOT NULL
108 OR external_language IS NOT NULL OR sql_path IS NOT NULL
109 OR routine_body <> 'SQL' OR parameter_style <> 'SQL'
110 OR specific_name <> routine_name);
111 SPECIFIC_NAME ROUTINE_CATALOG ROUTINE_SCHEMA ROUTINE_NAME ROUTINE_TYPE ROUTINE_BODY EXTERNAL_NAME EXTERNAL_LANGUAGE PARAMETER_STYLE SQL_PATH
112 function_for_routines def test function_for_routines FUNCTION SQL NULL SQL SQL NULL
113 sp_for_routines def test sp_for_routines PROCEDURE SQL NULL SQL SQL NULL
114 DROP PROCEDURE sp_for_routines;
115 DROP FUNCTION function_for_routines;
116 ################################################################################
117 # Testcase 3.2.8.2 + 3.2.8.3: INFORMATION_SCHEMA.ROUTINES accessible information
118 ################################################################################
119 DROP DATABASE IF EXISTS db_datadict;
120 DROP DATABASE IF EXISTS db_datadict_2;
121 CREATE DATABASE db_datadict charset latin1;
122 USE db_datadict;
123 CREATE TABLE res_6_408002_1(f1 CHAR(3), f2 TEXT(25), f3 DATE, f4 INT)
124 ENGINE = <other_engine_type>;
125 INSERT INTO res_6_408002_1(f1, f2, f3, f4)
126 VALUES('abc', 'xyz', '1989-11-09', 0815);
127 DROP PROCEDURE IF EXISTS sp_6_408002_1;
128 CREATE PROCEDURE sp_6_408002_1()
129 BEGIN
130 SELECT * FROM db_datadict.res_6_408002_1;
131 END//
132 CREATE DATABASE db_datadict_2 charset latin1;
133 USE db_datadict_2;
134 CREATE TABLE res_6_408002_2(f1 CHAR(3), f2 TEXT(25), f3 DATE, f4 INT)
135 ENGINE = <other_engine_type>;
136 INSERT INTO res_6_408002_2(f1, f2, f3, f4)
137 VALUES('abc', 'xyz', '1990-10-03', 4711);
138 DROP PROCEDURE IF EXISTS sp_6_408002_2;
139 CREATE PROCEDURE sp_6_408002_2()
140 BEGIN
141 SELECT * FROM db_datadict_2.res_6_408002_2;
142 END//
143 DROP USER 'testuser1'@'localhost';
144 CREATE USER 'testuser1'@'localhost';
145 DROP USER 'testuser2'@'localhost';
146 CREATE USER 'testuser2'@'localhost';
147 DROP USER 'testuser3'@'localhost';
148 CREATE USER 'testuser3'@'localhost';
149 GRANT SELECT ON db_datadict_2.* TO 'testuser1'@'localhost';
150 GRANT EXECUTE ON db_datadict_2.* TO 'testuser1'@'localhost';
151 GRANT EXECUTE ON db_datadict.* TO 'testuser1'@'localhost';
152 GRANT SELECT ON db_datadict.* TO 'testuser2'@'localhost';
153 GRANT EXECUTE ON PROCEDURE db_datadict_2.sp_6_408002_2
154 TO 'testuser2'@'localhost';
155 GRANT EXECUTE ON db_datadict_2.* TO 'testuser2'@'localhost';
156 FLUSH PRIVILEGES;
157 # Establish connection testuser1 (user=testuser1)
158 SELECT * FROM information_schema.routines where routine_schema like 'db_datadict%';
159 SPECIFIC_NAME ROUTINE_CATALOG ROUTINE_SCHEMA ROUTINE_NAME ROUTINE_TYPE DATA_TYPE CHARACTER_MAXIMUM_LENGTH CHARACTER_OCTET_LENGTH NUMERIC_PRECISION NUMERIC_SCALE DATETIME_PRECISION CHARACTER_SET_NAME COLLATION_NAME DTD_IDENTIFIER ROUTINE_BODY ROUTINE_DEFINITION EXTERNAL_NAME EXTERNAL_LANGUAGE PARAMETER_STYLE IS_DETERMINISTIC SQL_DATA_ACCESS SQL_PATH SECURITY_TYPE CREATED LAST_ALTERED SQL_MODE ROUTINE_COMMENT DEFINER CHARACTER_SET_CLIENT COLLATION_CONNECTION DATABASE_COLLATION
160 sp_6_408002_1 def db_datadict sp_6_408002_1 PROCEDURE NULL NULL NULL NULL NULL NULL NULL NULL SQL NULL NULL SQL SQL NO CONTAINS SQL NULL DEFINER YYYY-MM-DD hh:mm:ss YYYY-MM-DD hh:mm:ss ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION root@localhost utf8mb4 utf8mb4_0900_ai_ci latin1_swedish_ci
161 sp_6_408002_2 def db_datadict_2 sp_6_408002_2 PROCEDURE NULL NULL NULL NULL NULL NULL NULL NULL SQL NULL NULL SQL SQL NO CONTAINS SQL NULL DEFINER YYYY-MM-DD hh:mm:ss YYYY-MM-DD hh:mm:ss ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION root@localhost utf8mb4 utf8mb4_0900_ai_ci latin1_swedish_ci
162 # Establish connection testuser2 (user=testuser2)
163 SELECT * FROM information_schema.routines where routine_schema like 'db_datadict%';
164 SPECIFIC_NAME ROUTINE_CATALOG ROUTINE_SCHEMA ROUTINE_NAME ROUTINE_TYPE DATA_TYPE CHARACTER_MAXIMUM_LENGTH CHARACTER_OCTET_LENGTH NUMERIC_PRECISION NUMERIC_SCALE DATETIME_PRECISION CHARACTER_SET_NAME COLLATION_NAME DTD_IDENTIFIER ROUTINE_BODY ROUTINE_DEFINITION EXTERNAL_NAME EXTERNAL_LANGUAGE PARAMETER_STYLE IS_DETERMINISTIC SQL_DATA_ACCESS SQL_PATH SECURITY_TYPE CREATED LAST_ALTERED SQL_MODE ROUTINE_COMMENT DEFINER CHARACTER_SET_CLIENT COLLATION_CONNECTION DATABASE_COLLATION
165 sp_6_408002_2 def db_datadict_2 sp_6_408002_2 PROCEDURE NULL NULL NULL NULL NULL NULL NULL NULL SQL NULL NULL SQL SQL NO CONTAINS SQL NULL DEFINER YYYY-MM-DD hh:mm:ss YYYY-MM-DD hh:mm:ss ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION root@localhost utf8mb4 utf8mb4_0900_ai_ci latin1_swedish_ci
166 # Establish connection testuser3 (user=testuser3)
167 SELECT * FROM information_schema.routines where routine_schema like 'db_datadict%';
168 SPECIFIC_NAME ROUTINE_CATALOG ROUTINE_SCHEMA ROUTINE_NAME ROUTINE_TYPE DATA_TYPE CHARACTER_MAXIMUM_LENGTH CHARACTER_OCTET_LENGTH NUMERIC_PRECISION NUMERIC_SCALE DATETIME_PRECISION CHARACTER_SET_NAME COLLATION_NAME DTD_IDENTIFIER ROUTINE_BODY ROUTINE_DEFINITION EXTERNAL_NAME EXTERNAL_LANGUAGE PARAMETER_STYLE IS_DETERMINISTIC SQL_DATA_ACCESS SQL_PATH SECURITY_TYPE CREATED LAST_ALTERED SQL_MODE ROUTINE_COMMENT DEFINER CHARACTER_SET_CLIENT COLLATION_CONNECTION DATABASE_COLLATION
169 # Switch to connection default and close connections testuser1,testuser2,testuser3
170 DROP USER 'testuser1'@'localhost';
171 DROP USER 'testuser2'@'localhost';
172 DROP USER 'testuser3'@'localhost';
173 USE test;
174 DROP DATABASE db_datadict;
175 DROP DATABASE db_datadict_2;
176 #########################################################################
177 # 3.2.1.13+3.2.1.14+3.2.1.15: INFORMATION_SCHEMA.ROUTINES modifications
178 #########################################################################
179 DROP DATABASE IF EXISTS db_datadict;
180 CREATE DATABASE db_datadict charset latin1;
181 SELECT * FROM information_schema.routines WHERE routine_schema = 'db_datadict';
182 SPECIFIC_NAME ROUTINE_CATALOG ROUTINE_SCHEMA ROUTINE_NAME ROUTINE_TYPE DATA_TYPE CHARACTER_MAXIMUM_LENGTH CHARACTER_OCTET_LENGTH NUMERIC_PRECISION NUMERIC_SCALE DATETIME_PRECISION CHARACTER_SET_NAME COLLATION_NAME DTD_IDENTIFIER ROUTINE_BODY ROUTINE_DEFINITION EXTERNAL_NAME EXTERNAL_LANGUAGE PARAMETER_STYLE IS_DETERMINISTIC SQL_DATA_ACCESS SQL_PATH SECURITY_TYPE CREATED LAST_ALTERED SQL_MODE ROUTINE_COMMENT DEFINER CHARACTER_SET_CLIENT COLLATION_CONNECTION DATABASE_COLLATION
183 USE db_datadict;
184 CREATE PROCEDURE sp_for_routines() SELECT 'db_datadict';
185 CREATE FUNCTION function_for_routines() RETURNS INT RETURN 0;
186 SELECT * FROM information_schema.routines WHERE routine_schema = 'db_datadict'
187 ORDER BY routine_name;
188 SPECIFIC_NAME function_for_routines
189 ROUTINE_CATALOG def
190 ROUTINE_SCHEMA db_datadict
191 ROUTINE_NAME function_for_routines
192 ROUTINE_TYPE FUNCTION
193 DATA_TYPE int
194 CHARACTER_MAXIMUM_LENGTH NULL
195 CHARACTER_OCTET_LENGTH NULL
196 NUMERIC_PRECISION 10
197 NUMERIC_SCALE 0
198 DATETIME_PRECISION NULL
199 CHARACTER_SET_NAME NULL
200 COLLATION_NAME NULL
201 DTD_IDENTIFIER int
202 ROUTINE_BODY SQL
203 ROUTINE_DEFINITION RETURN 0
204 EXTERNAL_NAME NULL
205 EXTERNAL_LANGUAGE SQL
206 PARAMETER_STYLE SQL
207 IS_DETERMINISTIC NO
208 SQL_DATA_ACCESS CONTAINS SQL
209 SQL_PATH NULL
210 SECURITY_TYPE DEFINER
211 CREATED <created>
212 LAST_ALTERED <modified>
213 SQL_MODE ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION
214 ROUTINE_COMMENT
215 DEFINER root@localhost
216 CHARACTER_SET_CLIENT utf8mb4
217 COLLATION_CONNECTION utf8mb4_0900_ai_ci
218 DATABASE_COLLATION latin1_swedish_ci
219 SPECIFIC_NAME sp_for_routines
220 ROUTINE_CATALOG def
221 ROUTINE_SCHEMA db_datadict
222 ROUTINE_NAME sp_for_routines
223 ROUTINE_TYPE PROCEDURE
224 DATA_TYPE
225 CHARACTER_MAXIMUM_LENGTH NULL
226 CHARACTER_OCTET_LENGTH NULL
227 NUMERIC_PRECISION NULL
228 NUMERIC_SCALE NULL
229 DATETIME_PRECISION NULL
230 CHARACTER_SET_NAME NULL
231 COLLATION_NAME NULL
232 DTD_IDENTIFIER NULL
233 ROUTINE_BODY SQL
234 ROUTINE_DEFINITION SELECT 'db_datadict'
235 EXTERNAL_NAME NULL
236 EXTERNAL_LANGUAGE SQL
237 PARAMETER_STYLE SQL
238 IS_DETERMINISTIC NO
239 SQL_DATA_ACCESS CONTAINS SQL
240 SQL_PATH NULL
241 SECURITY_TYPE DEFINER
242 CREATED <created>
243 LAST_ALTERED <modified>
244 SQL_MODE ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION
245 ROUTINE_COMMENT
246 DEFINER root@localhost
247 CHARACTER_SET_CLIENT utf8mb4
248 COLLATION_CONNECTION utf8mb4_0900_ai_ci
249 DATABASE_COLLATION latin1_swedish_ci
250 ALTER PROCEDURE sp_for_routines SQL SECURITY INVOKER;
251 ALTER FUNCTION function_for_routines COMMENT 'updated comments';
252 SELECT * FROM information_schema.routines WHERE routine_schema = 'db_datadict'
253 ORDER BY routine_name;
254 SPECIFIC_NAME function_for_routines
255 ROUTINE_CATALOG def
256 ROUTINE_SCHEMA db_datadict
257 ROUTINE_NAME function_for_routines
258 ROUTINE_TYPE FUNCTION
259 DATA_TYPE int
260 CHARACTER_MAXIMUM_LENGTH NULL
261 CHARACTER_OCTET_LENGTH NULL
262 NUMERIC_PRECISION 10
263 NUMERIC_SCALE 0
264 DATETIME_PRECISION NULL
265 CHARACTER_SET_NAME NULL
266 COLLATION_NAME NULL
267 DTD_IDENTIFIER int
268 ROUTINE_BODY SQL
269 ROUTINE_DEFINITION RETURN 0
270 EXTERNAL_NAME NULL
271 EXTERNAL_LANGUAGE SQL
272 PARAMETER_STYLE SQL
273 IS_DETERMINISTIC NO
274 SQL_DATA_ACCESS CONTAINS SQL
275 SQL_PATH NULL
276 SECURITY_TYPE DEFINER
277 CREATED <created>
278 LAST_ALTERED <modified>
279 SQL_MODE ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION
280 ROUTINE_COMMENT updated comments
281 DEFINER root@localhost
282 CHARACTER_SET_CLIENT utf8mb4
283 COLLATION_CONNECTION utf8mb4_0900_ai_ci
284 DATABASE_COLLATION latin1_swedish_ci
285 SPECIFIC_NAME sp_for_routines
286 ROUTINE_CATALOG def
287 ROUTINE_SCHEMA db_datadict
288 ROUTINE_NAME sp_for_routines
289 ROUTINE_TYPE PROCEDURE
290 DATA_TYPE
291 CHARACTER_MAXIMUM_LENGTH NULL
292 CHARACTER_OCTET_LENGTH NULL
293 NUMERIC_PRECISION NULL
294 NUMERIC_SCALE NULL
295 DATETIME_PRECISION NULL
296 CHARACTER_SET_NAME NULL
297 COLLATION_NAME NULL
298 DTD_IDENTIFIER NULL
299 ROUTINE_BODY SQL
300 ROUTINE_DEFINITION SELECT 'db_datadict'
301 EXTERNAL_NAME NULL
302 EXTERNAL_LANGUAGE SQL
303 PARAMETER_STYLE SQL
304 IS_DETERMINISTIC NO
305 SQL_DATA_ACCESS CONTAINS SQL
306 SQL_PATH NULL
307 SECURITY_TYPE INVOKER
308 CREATED <created>
309 LAST_ALTERED <modified>
310 SQL_MODE ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION
311 ROUTINE_COMMENT
312 DEFINER root@localhost
313 CHARACTER_SET_CLIENT utf8mb4
314 COLLATION_CONNECTION utf8mb4_0900_ai_ci
315 DATABASE_COLLATION latin1_swedish_ci
316 DROP PROCEDURE sp_for_routines;
317 DROP FUNCTION function_for_routines;
318 SELECT * FROM information_schema.routines WHERE routine_schema = 'db_datadict';
319 SPECIFIC_NAME ROUTINE_CATALOG ROUTINE_SCHEMA ROUTINE_NAME ROUTINE_TYPE DATA_TYPE CHARACTER_MAXIMUM_LENGTH CHARACTER_OCTET_LENGTH NUMERIC_PRECISION NUMERIC_SCALE DATETIME_PRECISION CHARACTER_SET_NAME COLLATION_NAME DTD_IDENTIFIER ROUTINE_BODY ROUTINE_DEFINITION EXTERNAL_NAME EXTERNAL_LANGUAGE PARAMETER_STYLE IS_DETERMINISTIC SQL_DATA_ACCESS SQL_PATH SECURITY_TYPE CREATED LAST_ALTERED SQL_MODE ROUTINE_COMMENT DEFINER CHARACTER_SET_CLIENT COLLATION_CONNECTION DATABASE_COLLATION
320 CREATE PROCEDURE sp_for_routines() SELECT 'db_datadict';
321 CREATE FUNCTION function_for_routines() RETURNS INT RETURN 0;
322 SELECT * FROM information_schema.routines WHERE routine_schema = 'db_datadict'
323 ORDER BY routine_name;
324 SPECIFIC_NAME function_for_routines
325 ROUTINE_CATALOG def
326 ROUTINE_SCHEMA db_datadict
327 ROUTINE_NAME function_for_routines
328 ROUTINE_TYPE FUNCTION
329 DATA_TYPE int
330 CHARACTER_MAXIMUM_LENGTH NULL
331 CHARACTER_OCTET_LENGTH NULL
332 NUMERIC_PRECISION 10
333 NUMERIC_SCALE 0
334 DATETIME_PRECISION NULL
335 CHARACTER_SET_NAME NULL
336 COLLATION_NAME NULL
337 DTD_IDENTIFIER int
338 ROUTINE_BODY SQL
339 ROUTINE_DEFINITION RETURN 0
340 EXTERNAL_NAME NULL
341 EXTERNAL_LANGUAGE SQL
342 PARAMETER_STYLE SQL
343 IS_DETERMINISTIC NO
344 SQL_DATA_ACCESS CONTAINS SQL
345 SQL_PATH NULL
346 SECURITY_TYPE DEFINER
347 CREATED <created>
348 LAST_ALTERED <modified>
349 SQL_MODE ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION
350 ROUTINE_COMMENT
351 DEFINER root@localhost
352 CHARACTER_SET_CLIENT utf8mb4
353 COLLATION_CONNECTION utf8mb4_0900_ai_ci
354 DATABASE_COLLATION latin1_swedish_ci
355 SPECIFIC_NAME sp_for_routines
356 ROUTINE_CATALOG def
357 ROUTINE_SCHEMA db_datadict
358 ROUTINE_NAME sp_for_routines
359 ROUTINE_TYPE PROCEDURE
360 DATA_TYPE
361 CHARACTER_MAXIMUM_LENGTH NULL
362 CHARACTER_OCTET_LENGTH NULL
363 NUMERIC_PRECISION NULL
364 NUMERIC_SCALE NULL
365 DATETIME_PRECISION NULL
366 CHARACTER_SET_NAME NULL
367 COLLATION_NAME NULL
368 DTD_IDENTIFIER NULL
369 ROUTINE_BODY SQL
370 ROUTINE_DEFINITION SELECT 'db_datadict'
371 EXTERNAL_NAME NULL
372 EXTERNAL_LANGUAGE SQL
373 PARAMETER_STYLE SQL
374 IS_DETERMINISTIC NO
375 SQL_DATA_ACCESS CONTAINS SQL
376 SQL_PATH NULL
377 SECURITY_TYPE DEFINER
378 CREATED <created>
379 LAST_ALTERED <modified>
380 SQL_MODE ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION
381 ROUTINE_COMMENT
382 DEFINER root@localhost
383 CHARACTER_SET_CLIENT utf8mb4
384 COLLATION_CONNECTION utf8mb4_0900_ai_ci
385 DATABASE_COLLATION latin1_swedish_ci
386 use test;
387 DROP DATABASE db_datadict;
388 SELECT * FROM information_schema.routines WHERE routine_schema = 'db_datadict';
389 SPECIFIC_NAME ROUTINE_CATALOG ROUTINE_SCHEMA ROUTINE_NAME ROUTINE_TYPE DATA_TYPE CHARACTER_MAXIMUM_LENGTH CHARACTER_OCTET_LENGTH NUMERIC_PRECISION NUMERIC_SCALE DATETIME_PRECISION CHARACTER_SET_NAME COLLATION_NAME DTD_IDENTIFIER ROUTINE_BODY ROUTINE_DEFINITION EXTERNAL_NAME EXTERNAL_LANGUAGE PARAMETER_STYLE IS_DETERMINISTIC SQL_DATA_ACCESS SQL_PATH SECURITY_TYPE CREATED LAST_ALTERED SQL_MODE ROUTINE_COMMENT DEFINER CHARACTER_SET_CLIENT COLLATION_CONNECTION DATABASE_COLLATION
390 #########################################################################
391 # 3.2.8.4: INFORMATION_SCHEMA.ROUTINES routine body too big for
392 # ROUTINE_DEFINITION column
393 #########################################################################
394 DROP DATABASE IF EXISTS db_datadict;
395 CREATE DATABASE db_datadict charset latin1;
396 USE db_datadict;
397 CREATE TABLE db_datadict.res_6_408004_1
398 (f1 LONGTEXT , f2 MEDIUMINT , f3 LONGBLOB , f4 REAL , f5 YEAR)
399 ENGINE = <other_engine_type>;
400 INSERT INTO db_datadict.res_6_408004_1
401 VALUES ('abc', 98765 , 99999999 , 98765, 10);
402 CREATE TABLE db_datadict.res_6_408004_2
403 (f1 LONGTEXT , f2 MEDIUMINT , f3 LONGBLOB , f4 REAL , f5 YEAR)
404 ENGINE = <other_engine_type>;
405 INSERT INTO db_datadict.res_6_408004_2
406 VALUES ('abc', 98765 , 99999999 , 98765, 10);
407 # Checking the max. possible length of (currently) 4 GByte is not
408 # in this environment here.
409 CREATE PROCEDURE sp_6_408004 ()
410 BEGIN
411 DECLARE done INTEGER DEFAULt 0;
412 DECLARE variable_number_1 LONGTEXT;
413 DECLARE variable_number_2 MEDIUMINT;
414 DECLARE variable_number_3 LONGBLOB;
415 DECLARE variable_number_4 REAL;
416 DECLARE variable_number_5 YEAR;
417 DECLARE cursor_number_1 CURSOR FOR SELECT * FROM res_6_408004_1 LIMIT 0, 10;
418 DECLARE cursor_number_2 CURSOR FOR SELECT * FROM res_6_408004_1 LIMIT 0, 10;
419 DECLARE cursor_number_3 CURSOR FOR SELECT * FROM res_6_408004_1 LIMIT 0, 10;
420 DECLARE cursor_number_4 CURSOR FOR SELECT * FROM res_6_408004_1 LIMIT 0, 10;
421 DECLARE cursor_number_5 CURSOR FOR SELECT * FROM res_6_408004_1 LIMIT 0, 10;
422 DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET done = 1;
423 BEGIN
424 OPEN cursor_number_1;
425 WHILE done <> 1 DO
426 FETCH cursor_number_1
427 INTO variable_number_1, variable_number_2, variable_number_3,
428 variable_number_4, variable_number_5;
429 IF done <> 0 THEN
430 INSERT INTO res_6_408004_2
431 VALUES (variable_number_1, variable_number_2, variable_number_3,
432 variable_number_4, variable_number_5);
433 END IF;
434 END WHILE;
435 BEGIN
436 BEGIN
437 SET done = 0;
438 OPEN cursor_number_2;
439 WHILE done <> 1 DO
440 FETCH cursor_number_2
441 INTO variable_number_1, variable_number_2, variable_number_3,
442 variable_number_4, variable_number_5;
443 IF done <> 0 THEN
444 INSERT INTO res_6_408004_2
445 VALUES(variable_number_1, variable_number_2, variable_number_3,
446 variable_number_4, variable_number_5);
447 END IF;
448 END WHILE;
449 END;
450 SET done = 0;
451 OPEN cursor_number_3;
452 WHILE done <> 1 DO
453 FETCH cursor_number_3
454 INTO variable_number_1, variable_number_2, variable_number_3,
455 variable_number_4, variable_number_5;
456 IF done <> 0 THEN
457 INSERT INTO res_6_408004_2
458 VALUES(variable_number_1, variable_number_2, variable_number_3,
459 variable_number_4, variable_number_5);
460 END IF;
461 END WHILE;
462 END;
463 END;
464 BEGIN
465 SET done = 0;
466 OPEN cursor_number_4;
467 WHILE done <> 1 DO
468 FETCH cursor_number_4
469 INTO variable_number_1, variable_number_2, variable_number_3,
470 variable_number_4, variable_number_5;
471 IF done <> 0 THEN
472 INSERT INTO res_6_408004_2
473 VALUES (variable_number_1, variable_number_2, variable_number_3,
474 variable_number_4, variable_number_5);
475 END IF;
476 END WHILE;
477 END;
478 BEGIN
479 SET @a='test row';
480 SELECT @a;
481 SELECT @a;
482 SELECT @a;
483 END;
484 BEGIN
485 SET done = 0;
486 OPEN cursor_number_5;
487 WHILE done <> 1 DO
488 FETCH cursor_number_5
489 INTO variable_number_1, variable_number_2, variable_number_3,
490 variable_number_4, variable_number_5;
491 IF done <> 0 THEN
492 INSERT INTO res_6_408004_2
493 VALUES (variable_number_1, variable_number_2, variable_number_3,
494 variable_number_4, variable_number_5);
495 END IF;
496 END WHILE;
497 END;
498 BEGIN
499 SET @a='test row';
500 SELECT @a;
501 SELECT @a;
502 SELECT @a;
503 END;
504 END//
505 CALL db_datadict.sp_6_408004 ();
506 @a
507 test row
508 @a
509 test row
510 @a
511 test row
512 @a
513 test row
514 @a
515 test row
516 @a
517 test row
518 SELECT * FROM db_datadict.res_6_408004_2;
519 f1 f2 f3 f4 f5
520 abc 98765 99999999 98765 2010
521 abc 98765 99999999 98765 2010
522 abc 98765 99999999 98765 2010
523 abc 98765 99999999 98765 2010
524 abc 98765 99999999 98765 2010
525 abc 98765 99999999 98765 2010
526 SELECT *, LENGTH(routine_definition) FROM information_schema.routines
527 WHERE routine_schema = 'db_datadict';
528 SPECIFIC_NAME sp_6_408004
529 ROUTINE_CATALOG def
530 ROUTINE_SCHEMA db_datadict
531 ROUTINE_NAME sp_6_408004
532 ROUTINE_TYPE PROCEDURE
533 DATA_TYPE
534 CHARACTER_MAXIMUM_LENGTH NULL
535 CHARACTER_OCTET_LENGTH NULL
536 NUMERIC_PRECISION NULL
537 NUMERIC_SCALE NULL
538 DATETIME_PRECISION NULL
539 CHARACTER_SET_NAME NULL
540 COLLATION_NAME NULL
541 DTD_IDENTIFIER NULL
542 ROUTINE_BODY SQL
543 ROUTINE_DEFINITION BEGIN
544 DECLARE done INTEGER DEFAULt 0;
545 DECLARE variable_number_1 LONGTEXT;
546 DECLARE variable_number_2 MEDIUMINT;
547 DECLARE variable_number_3 LONGBLOB;
548 DECLARE variable_number_4 REAL;
549 DECLARE variable_number_5 YEAR;
550 DECLARE cursor_number_1 CURSOR FOR SELECT * FROM res_6_408004_1 LIMIT 0, 10;
551 DECLARE cursor_number_2 CURSOR FOR SELECT * FROM res_6_408004_1 LIMIT 0, 10;
552 DECLARE cursor_number_3 CURSOR FOR SELECT * FROM res_6_408004_1 LIMIT 0, 10;
553 DECLARE cursor_number_4 CURSOR FOR SELECT * FROM res_6_408004_1 LIMIT 0, 10;
554 DECLARE cursor_number_5 CURSOR FOR SELECT * FROM res_6_408004_1 LIMIT 0, 10;
555 DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET done = 1;
556 BEGIN
557 OPEN cursor_number_1;
558 WHILE done <> 1 DO
559 FETCH cursor_number_1
560 INTO variable_number_1, variable_number_2, variable_number_3,
561 variable_number_4, variable_number_5;
562 IF done <> 0 THEN
563 INSERT INTO res_6_408004_2
564 VALUES (variable_number_1, variable_number_2, variable_number_3,
565 variable_number_4, variable_number_5);
566 END IF;
567 END WHILE;
568 BEGIN
569 BEGIN
570 SET done = 0;
571 OPEN cursor_number_2;
572 WHILE done <> 1 DO
573 FETCH cursor_number_2
574 INTO variable_number_1, variable_number_2, variable_number_3,
575 variable_number_4, variable_number_5;
576 IF done <> 0 THEN
577 INSERT INTO res_6_408004_2
578 VALUES(variable_number_1, variable_number_2, variable_number_3,
579 variable_number_4, variable_number_5);
580 END IF;
581 END WHILE;
582 END;
583 SET done = 0;
584 OPEN cursor_number_3;
585 WHILE done <> 1 DO
586 FETCH cursor_number_3
587 INTO variable_number_1, variable_number_2, variable_number_3,
588 variable_number_4, variable_number_5;
589 IF done <> 0 THEN
590 INSERT INTO res_6_408004_2
591 VALUES(variable_number_1, variable_number_2, variable_number_3,
592 variable_number_4, variable_number_5);
593 END IF;
594 END WHILE;
595 END;
596 END;
597 BEGIN
598 SET done = 0;
599 OPEN cursor_number_4;
600 WHILE done <> 1 DO
601 FETCH cursor_number_4
602 INTO variable_number_1, variable_number_2, variable_number_3,
603 variable_number_4, variable_number_5;
604 IF done <> 0 THEN
605 INSERT INTO res_6_408004_2
606 VALUES (variable_number_1, variable_number_2, variable_number_3,
607 variable_number_4, variable_number_5);
608 END IF;
609 END WHILE;
610 END;
611 BEGIN
612 SET @a='test row';
613 SELECT @a;
614 SELECT @a;
615 SELECT @a;
616 END;
617 BEGIN
618 SET done = 0;
619 OPEN cursor_number_5;
620 WHILE done <> 1 DO
621 FETCH cursor_number_5
622 INTO variable_number_1, variable_number_2, variable_number_3,
623 variable_number_4, variable_number_5;
624 IF done <> 0 THEN
625 INSERT INTO res_6_408004_2
626 VALUES (variable_number_1, variable_number_2, variable_number_3,
627 variable_number_4, variable_number_5);
628 END IF;
629 END WHILE;
630 END;
631 BEGIN
632 SET @a='test row';
633 SELECT @a;
634 SELECT @a;
635 SELECT @a;
636 END;
637 END
638 EXTERNAL_NAME NULL
639 EXTERNAL_LANGUAGE SQL
640 PARAMETER_STYLE SQL
641 IS_DETERMINISTIC NO
642 SQL_DATA_ACCESS CONTAINS SQL
643 SQL_PATH NULL
644 SECURITY_TYPE DEFINER
645 CREATED YYYY-MM-DD hh:mm:ss
646 LAST_ALTERED YYYY-MM-DD hh:mm:ss
647 SQL_MODE ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION
648 ROUTINE_COMMENT
649 DEFINER root@localhost
650 CHARACTER_SET_CLIENT utf8mb4
651 COLLATION_CONNECTION utf8mb4_0900_ai_ci
652 DATABASE_COLLATION latin1_swedish_ci
653 LENGTH(routine_definition) 2549
654 DROP DATABASE db_datadict;
655 ########################################################################
656 # Testcases 3.2.1.3-3.2.1.5 + 3.2.1.8-3.2.1.12: INSERT/UPDATE/DELETE and
657 # DDL on INFORMATION_SCHEMA table are not supported
658 ########################################################################
659 DROP DATABASE IF EXISTS db_datadict;
660 CREATE DATABASE db_datadict charset latin1;
661 USE db_datadict;
662 CREATE PROCEDURE sp_for_routines() SELECT 'db_datadict';
663 USE test;
664 INSERT INTO information_schema.routines (routine_name, routine_type )
665 VALUES ('p2', 'procedure');
666 ERROR 42000: Access denied for user 'root'@'localhost' to database 'information_schema'
667 UPDATE information_schema.routines SET routine_name = 'p2'
668 WHERE routine_body = 'sql';
669 ERROR 42000: Access denied for user 'root'@'localhost' to database 'information_schema'
670 DELETE FROM information_schema.routines ;
671 ERROR 42000: Access denied for user 'root'@'localhost' to database 'information_schema'
672 TRUNCATE information_schema.routines ;
673 ERROR 42000: Access denied for user 'root'@'localhost' to database 'information_schema'
674 CREATE INDEX i7 ON information_schema.routines (routine_name);
675 ERROR 42000: Access denied for user 'root'@'localhost' to database 'information_schema'
676 ALTER TABLE information_schema.routines ADD f1 INT;
677 ERROR 42000: Access denied for user 'root'@'localhost' to database 'information_schema'
678 ALTER TABLE information_schema.routines DISCARD TABLESPACE;
679 ERROR 42000: Access denied for user 'root'@'localhost' to database 'information_schema'
680 DROP TABLE information_schema.routines ;
681 ERROR 42000: Access denied for user 'root'@'localhost' to database 'information_schema'
682 ALTER TABLE information_schema.routines RENAME db_datadict.routines;
683 ERROR 42000: Access denied for user 'root'@'localhost' to database 'information_schema'
684 ALTER TABLE information_schema.routines RENAME information_schema.xroutines;
685 ERROR 42000: Access denied for user 'root'@'localhost' to database 'information_schema'
686 DROP DATABASE db_datadict;