INSERT Statements

Required Column Missing

A required column with no default rejects the row.

highlighted = computed this step

Required column missing

A required column with no default rejects the insert row.

missing required column\text{missing required column}

Omit id

Accepted rows are 0, and rejected rows are 1.

rejected=1\text{rejected}=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.

Required column missing: base rowsidnamestatusnote1Adaactiveseed2BennewNULL SchemacolumnnotNulldefaultidyesNO_DEFAULTnameyesNO_DEFAULTstatusyesnewnotenonone Column list to rowinsertcolumnsvaluesdecisionappendIndexreasons0(name)(Cy)rejectednone({insert:0, column:id, reason:missing_required_no_default}) Resolved insert cellsinsertcolumnsupplieddefaultresultsourcereason0idnoNO_DEFAULTMISSINGmissingmissing_required_no_default0nameyesNO_DEFAULTCyexplicitok0statusnonewnewdefaultok0notenononenonedefaultok Rows after INSERTidnamestatusnote1Adaactiveseed2BennewNULL INSERT factsfactvaluebaseRowCount2insertAttemptCount1acceptedRowCount0rejectedRowCount1finalRowCount2defaultFillCount2explicitNullCount0

Read reasons

The insert result lists the missing required id column.

reason visible\text{reason visible}

Summary

Rejected rows do not append to the output table.

no append\text{no append}