Prisma Migrate Diff coming back when it shouldn't
Our team is using Prisma as our ORM, and have a Github Action that runs
as part of our CI/CD. In a recent merge, the Diff command is flagging the follow changes
[*] Changed the
Project
table
[+] Added column assignedUsers
[+] Added column tags
However, as you can see in our PR, both the schema changes, and the corresponding migrations, are present.
Would appreciate some help!![No description](https://cdn.answeroverflow.com/1240086613757923368/Screenshot_2024-05-14_at_4.png)
1 Reply
Very weirdly, I ran Prisma migrate diff locally, and it came up with these same diffs, as well as another change from a sperate branch that was present on my development DB.
I then ran npx prisma db push, re-ran the
migrate diff
and it came back as clean. This indicates the state of my DB is having some sort of impact on this migrate diff
command, which makes no sense since I'm checking Prisma.schema against my migrations folder, not against the current state of my DB 🤕