Debian Codegraph @

mysql-test/suite/service_udf_registration/r/udf_reg_same_func.result

raw
1 INSTALL COMPONENT "file://component_udf_reg_int_same_func";
2 select myfunc_int(5);
3 myfunc_int(5)
4 5
5 select myfunc_int(5,6,9);
6 myfunc_int(5,6,9)
7 20
8 SELECT * FROM performance_schema.user_defined_functions
9 WHERE udf_name IN('myfunc_int')
10 ORDER BY udf_name;
11 UDF_NAME UDF_RETURN_TYPE UDF_TYPE UDF_LIBRARY UDF_USAGE_COUNT
12 myfunc_int integer function NULL 1
13 INSTALL COMPONENT "file://component_udf_reg_int_func";
14 ERROR HY000: Initialization method provided by component 'mysql:test_udf_registration' failed.
15 select myfunc_int(5);
16 myfunc_int(5)
17 5
18 select myfunc_int(5,6,9);
19 myfunc_int(5,6,9)
20 20
21 SELECT * FROM performance_schema.user_defined_functions
22 WHERE udf_name IN('myfunc_int')
23 ORDER BY udf_name;
24 UDF_NAME UDF_RETURN_TYPE UDF_TYPE UDF_LIBRARY UDF_USAGE_COUNT
25 myfunc_int integer function NULL 1
26 UNINSTALL COMPONENT "file://component_udf_reg_int_same_func";
27 SELECT * FROM performance_schema.user_defined_functions
28 WHERE udf_name IN('myfunc_int')
29 ORDER BY udf_name;
30 UDF_NAME UDF_RETURN_TYPE UDF_TYPE UDF_LIBRARY UDF_USAGE_COUNT
31 select myfunc_int(5);
32 ERROR 42000: FUNCTION test.myfunc_int does not exist
33 UNINSTALL COMPONENT "file://component_udf_reg_int_func";
34 ERROR HY000: Component specified by URN 'file://component_udf_reg_int_func' to unload has not been loaded before.