News for hackers. Stuff that matters.

A comment on It’s fine, Rewind: Revert a migration without losing data. Parent comment

Re:It’s fine, Rewind: Revert a migration without losing data by robertlagrant on Thursday March 24, 2022 @05:23PM (#30795505)
And now I have a follow-up!

So what if you upgrade your data structure, add a new required column and a record is inserted. You then roll back, removing the column, in order to fix a bug. When you roll forward again, is that removed/readded column's data for the inserted record still there?

[ Parent | on HN ]
Re:It’s fine, Rewind: Revert a migration without losing data by shlomi-noach on Friday March 25, 2022 @02:41AM (#30799286)
So what you are describing here is Rewind-the-Rewind. We have built the support for this in OSS Vitess, and the answer would be "yes", you would roll forward and regain the new column with data again. But this is not (yet?) supported in PlanetScale.
[ Parent | on HN ]