HiveBrain v1.2.0
Get Started
← Back to all entries
patternMinor

Does MariaDB support schema changes inside a transaction?

Submitted by: @import:stackexchange-dba··
0
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?

Solution

No.

"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.