Default Values

Missing Required Column Rejects

A required column with no default fails closed.

highlighted = computed this step

Missing required column rejects

A NOT NULL column with no default must be supplied.

missing required column\text{missing required column}

Omit id

The candidate is rejected with 1 visible rejection reason.

reasons=1\text{reasons}=1

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

Missing required column rejects: base rowsidnamestatusnotescore1Adaactiveseed102BennewNULL0 Schema defaultscolumnnotNulldefaultidyesNO_DEFAULTnameyesNO_DEFAULTstatusyesnewnotenononescoreyes0 Candidate resolutioncolumnsupplieddefaultresultsourcestatusreasonidnoNO_DEFAULTMISSINGmissingrejectedmissing_required_no_defaultnameyesNO_DEFAULTCyexplicitokokstatusnonewnewdefaultokoknotenononenonedefaultokokscoreno00defaultokok Candidate checkfieldvaluedecisionrejectedresolvedRow()reasons({column:id, reason:missing_required_no_default})insertedRowIndexnone Rows after candidateidnamestatusnotescore1Adaactiveseed102BennewNULL0 DEFAULT factsfactvaluebaseRowCount2schemaColumnCount5defaultColumnCount3suppliedColumnCount1omittedColumnCount4appliedDefaultCount3explicitValueCount1explicitNullCount0rejectedReasonCount1candidateDecisionrejectedfinalRowCount2explicitNullInvokesDefaultno_toy_rule

Read the reason

The id column has NO_DEFAULT and notNull yes, so the insert fails closed.

missing required no default\text{missing required no default}

Summary

A default is not invented for a required column.

no hidden fill\text{no hidden fill}