Fix MySQL parsing of GRANT, REVOKE, and CREATE VIEW

apache / datafusion-sqlparser-rs

Extensible SQL Lexer and Parser for Rust

Apache License 2.0

2.81k stars 543 forks source link

Fix MySQL parsing of GRANT, REVOKE, and CREATE VIEW #1538

Open mvzink opened 5 days ago

mvzink commented 5 days ago

Support MySQL style 'user'@'host' syntax.
Support wildcards on grant objects: *.*.
Make CASCADE/RESTRICT in revoke statements optional since MySQL doesn't accept it.
Support optional MySQL parameters for create view: algorithm, definer (requires user@host syntax), and security context.

mvzink commented 5 days ago

Would appreciate feedback on the naming the MySQL-specific params types (would a generic/non-branded name be better?) and the API change for wildcard support (didn't want to change all 107 parse_object_name callsites for an option that is so niche, but happy to be convinced otherwise).