INSERT Statements

Omitted Column Uses Default

Omitted defaulted columns use schema defaults.

highlighted = computed this step

Omitted column uses default

When a defaulted column is omitted, the schema supplies its pinned default.

omitted uses default\text{omitted uses default}

Omit status and note

The insert is accepted 1 time and fills 2 defaults.

defaults=2\text{defaults}=2

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.

Omitted column uses default: base rowsidnamestatusnote1Adaactiveseed2BennewNULL SchemacolumnnotNulldefaultidyesNO_DEFAULTnameyesNO_DEFAULTstatusyesnewnotenonone Column list to rowinsertcolumnsvaluesdecisionappendIndexreasons0(id, name)(3, Cy)accepted2() Resolved insert cellsinsertcolumnsupplieddefaultresultsourcereason0idyesNO_DEFAULT3explicitok0nameyesNO_DEFAULTCyexplicitok0statusnonewnewdefaultok0notenononenonedefaultok Rows after INSERTidnamestatusnote1Adaactiveseed2BennewNULL3Cynewnone INSERT factsfactvaluebaseRowCount2insertAttemptCount1acceptedRowCount1rejectedRowCount0finalRowCount3defaultFillCount2explicitNullCount0

Read sources

The resolved-cells table marks the default-filled cells.

source default\text{source default}

Summary

Only defaults shown in the schema can be used.

pinned defaults only\text{pinned defaults only}