|
Let's implement a Transact-SQL procedural language parser for sql_mode=MSSQL, so users migrating from SQL Server to MariaDB do not have to rewrite their stored procedures.
CREATE PROCEDURE grammar
CREATE [ OR ALTER ] { PROC | PROCEDURE }
|
[schema_name.] procedure_name [ ; number ]
|
[ { @parameter_name [ type_schema_name. ] data_type }
|
[ VARYING ] [ NULL ] [ = default ] [ OUT | OUTPUT | [READONLY]
|
] [ ,...n ]
|
[ WITH <procedure_option> [ ,...n ] ]
|
[ FOR REPLICATION ]
|
AS { [ BEGIN ] sql_statement [;] [ ...n ] [ END ] }
|
[;]
|
|
<procedure_option> ::=
|
[ ENCRYPTION ]
|
[ RECOMPILE ]
|
[ EXECUTE AS Clause ]
|
|
[MDEV-32522]