pingcap / pingcap/tidb

Add parser support for CREATE loadable functions and DROP function

Open
#61,131 0 comments 0 reactions 0 assignees View on GitHub
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

Open the contributing 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

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.