github.com/matrixorigin/matrixone@v1.2.0/test/distributed/cases/udf/udf.result (about)

     1  create function sql_sum (a int, b int) returns int language sql as '$1 + $2';
     2  select sql_sum(1, 1) as ret;
     3  ret
     4  2
     5  drop function sql_sum(int, int);
     6  create database db1;
     7  use db1;
     8  select name, db from mo_catalog.mo_user_defined_function where db = 'db1';
     9  name    db
    10  create function helloworld () returns int language sql as 'select id from tbl1 limit 1';
    11  select name, db from mo_catalog.mo_user_defined_function where db = 'db1';
    12  name    db
    13  helloworld    db1
    14  drop database db1;
    15  select name, db from mo_catalog.mo_user_defined_function where db = 'db1';
    16  name    db
    17  create function db1.helloworld5 () returns int language sql as 'select id from tbl1 limit 1';
    18  invalid database db1
    19  create database db1;
    20  use db1;
    21  create function db1.helloworld5 () returns int language sql as 'select id from tbl1 limit 1';
    22  drop function db1.helloworld5();
    23  drop function db2.helloworld5();
    24  invalid database db2
    25  drop database db1;