|
Rather than crude inserts directly into mysq.func table:
INSERT INTO mysql.func VALUES ('calgetstats',0,'ha_columnstore.so','function');
INSERT INTO mysql.func VALUES ('calsettrace',2,'ha_columnstore.so','function');
INSERT INTO mysql.func VALUES ('calsetparms',0,'ha_columnstore.so','function');
INSERT INTO mysql.func VALUES ('calflushcache',2,'ha_columnstore.so','function');
{nformat}
Use the CREATE FUNCTION OR REPLACE function for UDFs.
Use [DROP FUNCTION](https://mariadb.com/kb/en/drop-function-udf/) to remove previous functions that are no longer used.
|