patternMinor
Does MariaDB support schema changes inside a transaction?
Viewed 0 times
mariadbchangestransactiondoesschemasupportinside
Problem
MySQL doesn't support schema changes, inside a transaction so there's no way to roll back after during a failed migration involving schema changes.
This capability is supported by Postgres and SQLite. Any chance MariaDB supports it?
This capability is supported by Postgres and SQLite. Any chance MariaDB supports it?
Solution
No.
"DDL statements (CREATE, ALTER, DROP) [...] cause an implicit COMMIT"
Thanks horse with no name.
"DDL statements (CREATE, ALTER, DROP) [...] cause an implicit COMMIT"
Thanks horse with no name.
Context
StackExchange Database Administrators Q#101818, answer score: 6
Revisions (0)
No revisions yet.