Is there are a way to rollback if any error show up ? #5
Description
The CREATE TABLE statement in InnoDB is processed as a single transaction. This means that a ROLLBACK from the user does not undo CREATE TABLE statements the user made during that transaction.
Based on https://dev.mysql.com/doc/refman/8.0/en/implicit-commit.html, it seems there is no way to rollback DDL for mariadb. I've already try it, and it always fails. It only work for DML query.