Bug #21410 Flow control functions within the general SQL context

Description:
This is perhaps non-standard, but because there is no support for ROLLBACK/COMMIT statements within routines, it is very difficult to do something like this in just SQL...

How to repeat:
drop table if exists test;
create table test(id int not null) type=InnoDB;

set autocommit=0;
start transaction;

set @error='bad';
insert into test select 15;
insert into test select 16;
if @error='' then
rollback;
else
commit;
end if;

Suggested fix:
Add the same flow control from routines into general SQL context.

Thank you for a feature request. I think, request for COMMIT/ROLLBACK support in stored procedures (not triggers!) is much more reasonable. SQL is not a good place to introduce flow control statements.

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".