When running with sql_mode=ORACLE, MariaDB (the bb-10.2-compatibility branch) does not understand the optional function or procedure name after the END keyword which ends the entire routine definition. We'll extend the parser to understand the optional name, so this script is parsed without syntax errors:
In case of stand-alone routines we'll also allow qualified names: END test.p1;
Optional routine names are also possible inside a package body definition:
In case of package routines the name specified in END cannot be qualified.
If the name specified in CREATE does not match the name specified in END, an error will be reported.
Under terms of this patch we'll only fix traditional (stand-alone) stored functions and procedures.
Handling the name after the END for package routines will be done in package related tasks (e.g.
MDEV-10591 or MDEV-11952)