strongduanmu commented on pull request #10372: URL: https://github.com/apache/shardingsphere/pull/10372#issuecomment-842864015
> Hi, > > From [MySQL DOC](https://dev.mysql.com/doc/refman/8.0/en/create-function-loadable.html), `Udf` points `user defined functions`, `MySQLCreateUdfStatement` is proper to include all users' function? @tristaZero `MySQLCreateUdfStatement` is not very suitable for user defined functions. It is specifically used for loadable functions. Maybe it is better to rename it to `MySQLCreateLoadableFunctionStatement`. According to the document, the loadable function is defined as follows: > A loadable function is a way to extend MySQL with a new function that works like a native (built-in) MySQL function such as ABS() or CONCAT() Because of the loaded shared library file, loadable functions can be used globally, while user-defined functions can only be used in the corresponding db range. Due to these different characteristics, the loadable function is divided into DALStatement, and the user-defined function is divided into DDLStatement, which also leads to the statement is not convenient to reuse, because we will use different routing engines according to the statement type. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: [email protected]
