Procedure with COMMIT
COMMIT inside a procedure ends the transaction and starts a new one. Functions cannot do this. Call the procedure outside any open transaction block.
task
Write procedure load_batches() that inserts 1, 2, 3 into batch_log and commits after each, then CALL it.