INSERT Statements

Honest by Construction

Expected INSERT facts are assertions only.

highlighted = computed this step

Honest by construction

Expected INSERT facts are assertions only.

compiler is source of truth\text{compiler is source of truth}

Render checked facts

The guarded INSERT accepts 1 row and fills 2 defaults.

accepted=1\text{accepted}=1

INSERT examples are tiny finite row appends; SQL dialect completeness, generated defaults, identity columns, constraints beyond visible NOT NULL, triggers, transactions, indexes, performance, and product behavior are out of scope.

Honest by construction: base rowsidnamestatusnote1Adaactiveseed2BennewNULL SchemacolumnnotNulldefaultidyesNO_DEFAULTnameyesNO_DEFAULTstatusyesnewnotenonone Column list to rowinsertcolumnsvaluesdecisionappendIndexreasons0(id, name)(3, Cy)accepted2() Resolved insert cellsinsertcolumnsupplieddefaultresultsourcereason0idyesNO_DEFAULT3explicitok0nameyesNO_DEFAULTCyexplicitok0statusnonewnewdefaultok0notenononenonedefaultok Rows after INSERTidnamestatusnote1Adaactiveseed2BennewNULL3Cynewnone INSERT factsfactvaluebaseRowCount2insertAttemptCount1acceptedRowCount1rejectedRowCount0finalRowCount3defaultFillCount2explicitNullCount0

Try to tamper

Wrong expected facts, derived sidecars, duplicate or missing columns, value-count mismatches, bools, and floats fail closed.

tamper rejected\text{tamper rejected}

Summary

This book shows exact finite INSERT behavior only.

scoped INSERT model\text{scoped INSERT model}