Add parser support for CREATE loadable functions and DROP function
Open
type/enhancement
- Dominant language
- Go
- Stars
- 40.5k
- Forks
- 6.2k
- PR merge metrics
- PR metrics pending
Description
## Enhancement
```
CREATE [AGGREGATE] FUNCTION [IF NOT EXISTS] function_name
RETURNS {STRING|INTEGER|REAL|DECIMAL}
SONAME shared_library_name
```
```
DROP FUNCTION [IF EXISTS] function_name
```
ref https://dev.mysql.com/doc/refman/8.4/en/create-function-loadable.html
https://dev.mysql.com/doc/refman/8.4/en/drop-function-loadable.html
Contributor guide
Research direction
Use the linked MySQL CREATE FUNCTION and DROP FUNCTION references as the behavior specification. Start by locating TiDB's SQL parser grammar and related parser tests, then add coverage for the shown forms and verify that the supported syntax is accepted.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- go, mysql
- Domain
- databases
- Issue type
- Feature
- Difficulty
- 3/5
- Estimated time
- 1-2 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 48/100