Commit

6ad4949

While testing a post, I tried to make CockroachDB roll back a failed migration as one unit. By default it commits before every schema change, as MySQL does. So I turned that setting off, unlocked the table, and put everything in one transaction: a data fix, a new column, then a NOT NULL that one row breaks. The NOT NULL check failed after the commit. CockroachDB's hint: "Some of the non-DDL statements may have committed successfully." It undid the new column and kept the data fix. Schemity's migration dialog now warns about CockroachDB before you press Apply. https://schemity.com/blog/transactional-ddl-postgres-mysql-cockroachdb/

commit 6ad4949