apache / apache/datafusion-sqlparser-rs

MySQL: No support for stored procedure DEFINER

Open
#711 0 comments 0 reactions 0 assignees View on GitHub
Dominant language
Rust
Stars
3.5k
Forks
772
Avg merge
4d 9h
Merged PRs (30d)
17

Description

If the stored procedure contains a DEFINER, a ParserError is raised:
```
ParserError("Expected an object type after CREATE, found: DEFINER")
```
Exemple of code causing such an error:
```sql
CREATE
DEFINER = foo@`%` PROCEDURE bar(IN first char(15), IN second tinyint)
proc: begin
```

Contributor guide

No contributing guide indexed for this repository

Research direction

Start by reproducing the supplied CREATE DEFINER PROCEDURE example and trace the CREATE statement parsing entry point that raises the ParserError. The work is done when this MySQL form parses successfully without regressing existing CREATE statement behavior; no file or test is named in the issue.

Written by the indexing model from the issue text.

Assessment

Tech stack
mysql, rust, sql
Domain
databases
Issue type
Bug
Difficulty
3/5
Estimated time
1-2 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
50/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.