ory / x / 11613733032

62%

push

github

feat: migration box now supports autocommit DDL changes (#818)

To better support CockroachDB, a new migration type ("autocommit") has been added. Autocommit migrations will not be executed in a transaction, which resolves issues in when running large DDL changes in crdb transactions.

To use this feature, just add `.autocommit` to the filename:

```
1234_name.autocommit.up.sql < does not run in transaction
1234_name.up.sql < runs in transaction
```

Works with all combinations:

```
1234_name.postgres.autocommit.up.sql
```

49 of 62 new or added lines in 2 files covered. (79.03%)

7209 of 11518 relevant lines covered (62.59%)

4035.2 hits per line