You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
The up SQL ensures that any title values written to the old schema will be rewritten to match the CHECK constraint in the new schema. It is the migration author's responsibility to ensure that this SQL works and produces a value that really does satisfy the constraint. If the up SQL fails then the backfill operation on start will fail and the migration will be rolled back.
Having a way to test the up SQL against all (or a subset) of the values in the table before performing any DDL operations would provide a better user experience and help migration authors validate migrations before execution.
The text was updated successfully, but these errors were encountered:
Provide a way to allow the
up
SQL to be verified for correctness before performing any DDL operations.For example, in this add
CHECK
constraint migration:The
up
SQL ensures that anytitle
values written to the old schema will be rewritten to match theCHECK
constraint in the new schema. It is the migration author's responsibility to ensure that this SQL works and produces a value that really does satisfy the constraint. If theup
SQL fails then the backfill operation on start will fail and the migration will be rolled back.Having a way to test the
up
SQL against all (or a subset) of the values in the table before performing any DDL operations would provide a better user experience and help migration authors validate migrations before execution.The text was updated successfully, but these errors were encountered: