I5 (2 points)
https://knobit.org/id/task/ddl-review/I5
Also as Turtle · JSON-LD · RDF/XML
| dcterms:license | https://creativecommons.org/licenses/by/4.0/ |
|---|---|
| owl:sameAs | https://bitbucket.org/reffa/ontology/id/task/ddl-review/I5 |
| rdfs:label | I5 (2 points) en |
| schema:hasPart | ddl-review I5a: greenfield DDL against a populated table |
| schema:hasPart | ddl-review I5b: drop script as rollback |
| schema:identifier | I5 |
| schema:position | 8 |
| schema:text | Deployment, 1 each: (a) tightening payout_iban to NOT NULL cannot be deployed by running this greenfield DDL against a populated database where 3% of migrated rows are null - it needs a backfill and a hand-written migration, and the generated diff is the statement of intent; (b) 99_drop_tables.sql is not a rollback for a migration, and the runbook step that uses it would remove the data. en |
Used by
| has question | Generated DDL review, Postgres and Snowflake (DDL review skills) |
|---|---|
| schema:isPartOf | ddl-review I5a: greenfield DDL against a populated table |
| schema:isPartOf | ddl-review I5b: drop script as rollback |