Default Values

Multiple Defaults in One Insert

Several omitted defaulted columns resolve together.

highlighted = computed this step

Multiple defaults in one insert

One candidate can omit several defaulted columns.

several defaults\text{several defaults}

Fill several cells

The insert applies 3 default cells and leaves 3 final rows.

final rows=3\text{final rows}=3

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.

Multiple defaults in one insert: base rowsidnamestatusnotescore1Adaactiveseed102BennewNULL0 Schema defaultscolumnnotNulldefaultidyesNO_DEFAULTnameyesNO_DEFAULTstatusyesnewnotenononescoreyes0 Candidate resolutioncolumnsupplieddefaultresultsourcestatusreasonidyesNO_DEFAULT3explicitokoknameyesNO_DEFAULTCyexplicitokokstatusnonewnewdefaultokoknotenononenonedefaultokokscoreno00defaultokok Candidate checkfieldvaluedecisionacceptedresolvedRow(3, Cy, new, none, 0)reasons()insertedRowIndex2 Rows after candidateidnamestatusnotescore1Adaactiveseed102BennewNULL03Cynewnone0 DEFAULT factsfactvaluebaseRowCount2schemaColumnCount5defaultColumnCount3suppliedColumnCount2omittedColumnCount3appliedDefaultCount3explicitValueCount2explicitNullCount0rejectedReasonCount0candidateDecisionacceptedfinalRowCount3explicitNullInvokesDefaultno_toy_rule

Read the resolved row

Each defaulted column is resolved separately from the same schema.

cell by cell\text{cell by cell}

Summary

The compiler does not guess defaults that are not in the schema.

pinned defaults only\text{pinned defaults only}