Was contributed upstream also http://bugs.mysql.com/bug.php?id=70948

Okay. This is more than simply BEGIN...END, as it also includes output placeholders for prepared statements (e.g. in PREPARE "SELECT...INTO ?"). Which looks like a cool, but different feature.

And it's unfortunately less than I expected, as it only covers (and tests) BEGIN...END (and DECLARE), but not IF and loops.

atcurtis, what did you need this feature for, I mean, in that exactly scope?
Do you want to work more on it, or you'd prefer if I take it as is and finalize it myself ?

Ah, and there's also SET ? = expr syntax.
atcurtis — why did you do that? Any use cases?

I've now pushed a — significantly reworked — patch to github. Without SET ? = expr syntax, but with SELECT ... INTO ?. Without BEGIN ATOMIC (it wasn't atomic in the contributed patch either, in mine it is not accepted at all). And with support for IF, CASE, LOOP, REPEAT, WHILE.

elenst, could you please do some testing of this feature?

Assorted notes

New status variable: Com_compound_sql

From http://dev.mysql.com/doc/refman/5.6/en/sql-syntax-compound-statements.html

• RETURN does not work (expectedly)
• (for outermost blocks) labels, ITERATE, LEAVE do not work

Ran some manual and automated tests, haven't got anything except for the issues listed in "Issue Links" section. Please push, and I will include new functionality in my general auto tests.

OK to push