SHOW FUNCTIONS

    Parameters

    1. mysql> show full functions in testDb\G
    2. *************************** 1. row ***************************
    3.         Signature: my_add(INT,INT)
    4.       Return Type: INT
    5.     Function Type: Scalar
    6. Intermediate Type: NULL
    8.         Signature: my_count(BIGINT)
    9.       Return Type: BIGINT
    10.     Function Type: Aggregate
    11. Intermediate Type: NULL
    12.        Properties: {"object_file":"http://host:port/libudasample.so","finalize_fn":"_ZN9doris_udf13CountFinalizeEPNS_15FunctionContextERKNS_9BigIntValE","init_fn":"_ZN9doris_udf9CountInitEPNS_15FunctionContextEPNS_9BigIntValE","merge_fn":"_ZN9doris_udf10CountMergeEPNS_15FunctionContextERKNS_9BigIntValEPS2_","md5":"37d185f80f95569e2676da3d5b5b9d2f","update_fn":"_ZN9doris_udf11CountUpdateEPNS_15FunctionContextERKNS_6IntValEPNS_9BigIntValE"}
    13. *************************** 3. row ***************************
    14.         Signature: id_masking(INT)
    15.       Return Type: VARCHAR
    16.     Function Type: Alias
    17. Intermediate Type: NULL
    19. 3 rows in set (0.00 sec)
    20. mysql> show builtin functions in testDb like 'year%';
    21. +---------------+
    22. | Function Name |
    23. +---------------+
    24. | year          |
    25. | years_add     |
    26. | years_diff    |
    27. | years_sub     |
    28. +---------------+