The first migration is always rolled back on Windows

[2joy]

20210329163410_initial_migration.txt

Synthetic first migration example for demonstration.

-- migrate:up
CREATE SCHEMA IF NOT EXISTS up;

-- migrate:down
CREATE SCHEMA IF NOT EXISTS down;

On Windows, the first migration will always be rolled back and both schemes will appear in the database.
On Linux all is fine.
This behavior was seen only in the first migration. If you add a migration before it, even one consisting of only comments, the down schema will not be created.

! UPDATE:
I figured out what was causing the poblem. These are Windows line breaks (\r\n). I attach a file created on Windows, with it the same behavior occurs under Linux.

[amacneil]

Definitely sounds like a bug. I don't have time to investigate right now, but I have a feeling it's probably something to do with our migration parsing logic in https://github.com/amacneil/dbmate/blob/main/pkg/dbmate/migration.go#L57 .

A good place to start would be adding a unit test specifically testing \r\n line endings.