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