Debian Codegraph @

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

raw
1 select * from performance_schema.user_defined_functions
2 where UDF_NAME like '%' limit 1;
3 select * from performance_schema.user_defined_functions
4 where UDF_NAME='niamatakava';
5 insert into performance_schema.user_defined_functions
6 set UDF_NAME='FOO', UDF_RETURN_TYPE='int', UDF_TYPE='function',
7 UDF_LIBRARY='bar', UDF_USAGE_COUNT=2;
8 ERROR 42000: INSERT command denied to user 'root'@'localhost' for table 'user_defined_functions'
9 update performance_schema.user_defined_functions
10 set UDF_USAGE_COUNT=12;
11 ERROR 42000: UPDATE command denied to user 'root'@'localhost' for table 'user_defined_functions'
12 update performance_schema.user_defined_functions
13 set UDF_USAGE_COUNT=12 where UDF_NAME='FOO';
14 ERROR 42000: UPDATE command denied to user 'root'@'localhost' for table 'user_defined_functions'
15 select UDF_USAGE_COUNT from performance_schema.user_defined_functions
16 where UDF_NAME='::1';
17 UDF_USAGE_COUNT
18 delete from performance_schema.user_defined_functions
19 where UDF_NAME='foo';
20 ERROR 42000: DELETE command denied to user 'root'@'localhost' for table 'user_defined_functions'
21 delete from performance_schema.user_defined_functions;
22 ERROR 42000: DELETE command denied to user 'root'@'localhost' for table 'user_defined_functions'
23 LOCK TABLES performance_schema.user_defined_functions READ;
24 ERROR 42000: SELECT, LOCK TABLES command denied to user 'root'@'localhost' for table 'user_defined_functions'
25 UNLOCK TABLES;
26 LOCK TABLES performance_schema.user_defined_functions WRITE;
27 ERROR 42000: SELECT, LOCK TABLES command denied to user 'root'@'localhost' for table 'user_defined_functions'
28 UNLOCK TABLES;