Recognises generated SQL edited by hand

Mida see tähendab

A file in `08-ddl/` that regeneration does not reproduce byte for byte. The header says `DO NOT HAND-EDIT`; look for the edit anyway — an added constraint, a reordered statement, a tweaked type, a comment. From here the model and the database tell different stories and nothing mechanical can say which is right.

Kuidas seda hinnatakse

Flags the deficient case and passes the acceptable one. Deficient: `ck_fact_payment_settled_le_instructed` added straight into `01_create_tables.sql` after a deploy failure; the next regeneration drops it, nobody notices for two releases, and over-settled payments load again Acceptable: The check added to `fact_payment.check_constraints` in `physical-model.yaml` and the DDL regenerated; `diff -r 08-ddl /tmp/ddl-check` empty, and that diff run in CI

Tugineb

Explains generated artefacts and their single source of truthK-851 · Teadmine

Vajalik

Puudub